Need Help? Chat with us
LIFETIME ACCESS | CERTIFICATE | CAREER FOCUSED

New Microsoft Excel 2019 and Office 365 Features

Increase your productivity with all new Microsoft Excel 2019 and office 365 features and save time!

Have Queries? Ask us
US: +1 203-349-9909 / IN: +91-8080042523

Our Students
working in leading companies

What you will learn?

  • Learn about CONCAT function and see if TEXTJOIN is more powerful than the CONCAT function
  • Basic to intermediate examples on Filter function in Office 365 Excel
  • Learn about the function IFs and SWITCH formula
  • LET function in Excel Office 365 and 2019
  • A use case on MAXIFS and MINIFS functions of Office 365 Excel
  • Project: Concatenate different values based on the IDs using TEXTJOIN and IF functions
  • And more…

Who this Course is for?

  • Excel users who have basic skills but want to be BETTER
  • Anyone who wants to take their career to a new level
  • Anyone who want to expand their analytics skills
  • Anyone looking to improve their productivity

LEARNER'S REVIEW

Peter

Peter Klugsberger
Chief Contrarian & Organisational Truthteller, Ex-McKinsey, Sydney, Australia

“I would like to tell you that I am very impressed with Yoda Learning courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts. I found no other course with the same insights.”

Madalina

Madalina-Elena Gheorghe
Traducator, Romania

“Hello! Your courses were useful to me. Thank you again for your quick support and also for your availability.”

Len smith
Business Owner at The Writers’ Guru, Oldham, United Kingdom

“This will save so much time I am quite a heavy user of Visualization but have never formally learned how to use it properly This course has shown me how incredibly time consuming my ways of using it are.”

Biswa jeet

Biswajeet Pattnaik (Biswa)
Investment Advisor (Transaction & Portfolio Management), Saudi Aramco, Saudi Arabia

“Anyone who wants to exceed the expectations set by himself/Seniors/peers. It is crucial to convey the right ideas in the right format through a proper medium. Guns don’t kill as much as Powerpoint bullets. I made my mind to be a Subscriber of all of his courses after seeing his free videos, which make me think that I am actually in a real class and learning it by practicing it.”

Karnika Bhalla
Director of Finance, Administration & Compliance (DFAC) at Deloitte Consulting, Nepal

“We recently brought trainers from Yoda Learning Solutions to Nepal for an Advanced Financial Modeling training on an international donor funded project and they were excellent! In addition to the standard course content, which by the way they tailored to our business needs, we also benefited from many extra time-saving tips, tricks and tools. The facilitators are not only technically very knowledgeable, but also genuinely helpful and have a clear desire to help professionals work smarter, not harder. Thanks for a week very well spent!”

New Microsoft Excel 2019 and Office 365 Features COURSE CURRICULUM

Get detailed New Microsoft Excel 2019 and Office 365 Features course outline in your inbox – Download Curriculum

Topics

• CONCAT and TEXTJOIN
• FILTER
• IFS and SWITCH
• LET
• MAXIFS and MINIFS
• Project: TEXTJOIN and IF
• SEQUENCE
• SORT
• SORTBY
• UNIQUE
• XLOOKUP – Part 1
• XLOOKUP – Part 2
• XMATCH

Join now

No Frills

MS Excel 2019 and Office 365 New Features

Get Instant Access
$̶9̶9̶ $49
  • 1 Hours Of Videos
  • 10+ Video Lessons
  • Lifetime Access
  • Downloadable Sample Files
Get Instant Access

What Student’s Say?

The Course instructors at Yoda Learning are at Par. My only Weakness till date was Excel which is long gone now. Not only I’ve learned about Excel but I can confidently do VBA Coding and automate my Regular Excel Tasks. A colleague of mine made me watch a Couple of your Videos where you have taught Excel Tricks. And since it had a Lifetime Support it really motivated me to take your Course. Thank you so much for delivering your Best knowledge.

Peter Thomas
Peter Thomas
Sr. Consultant

I have all the courses from Yoda Learning. I consider it as one of the best platforms in making Learning easier for its Learners. The Courses here are comprehensive and one of the easiest Courses on the Online Platform in recent times. Professionally explained. I love the takeaways from the Course. It’s amazing especially the Money back Guarantee which gives you the Confidence to take the course.

Barbara_Kern
Barbara Pern
Data Analysis