Description
Master NEW Excel Functions in Office 365 & Office 2021 is a mastering course on new Excel functions in Office 365 and Office 2021, published by Udemy Academy. Learn to use the new Excel functions (FILTER, UNIQUE, SORT, XLOOKUP…) to dramatically simplify what you do in Excel.
Analyzing data in Excel for Microsoft 365 is easier than ever. We have new Excel functions like XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE and more! In addition; Microsoft has changed the Excel calculation engine. This change affects everyone who uses the Microsoft 365 version: beginners to advanced users of Excel. There are several ways you can apply dynamic arrays and new Excel functions to your files. This course will show you how to maximize the new potential in Excel 365!
What you will learn in the Master NEW Excel Functions in Office 365 & Office 2021 training course:
- New Master Excel formulas (FILTER, UNIQUE, XLOOKUP, SORT, SORTBY, SEQUENCE, RANDARRAY and more dynamic array functions)
- Learn how to think outside the box to solve any Excel challenge you face.
- Be the first to unlock the power of Microsoft Excel’s new calculation engine.
- Add never-before-seen INTERACTIVITY to your Excel reports (creating Pivot Table style reports, without using Pivot Tables)
- Maximize the new potential in Excel and learn how to use the new DYNAMIC ARRAYS formulas to improve your files.
- Lifetime access to proven and advanced Excel courses including challenges, quizzes and exercises
Who is this course suitable for:
- Business professionals who use Excel to analyze data and create reports.
- You want a complete course to understand everything in Excel’s new calculation engine.
- Want to learn how to create interactive reports with dynamic array formulas in Excel?
Course details
- Publisher: Yudmi
- teacher: Leila Gharani
- English language
- Training level: introductory to advanced
- Number of courses: 91
- Training duration: 7 hours and 8 minutes
Course headings
Course prerequisites
- You HAVE Microsoft 365 & the NEW Excel Dynamic Array formulas (see the 3rd Preview lecture)
- You currently use Excel and are familiar with SUM, IF & VLOOKUP functions
- MAC USERS: Excel Dynamic arrays are also available in Excel for Microsoft 365 for Mac. Please note: The course is taught for Excel on Windows. If you have a Mac, I wouldn’t be able to help you if you run into problems.
Pictures
Course introduction video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
Password file(s): www.downloadly.ir
Size
2.34 GB
Be the first to comment