What you’ll learn
- Use Excel’s new FILTER Function to find multiple match results
- Use Excel’s new XLOOKUP function for complex lookups (no more VLOOKUP or Index Match)
- Create Excel Dashboard reports in MINUTES instead of HOURS
- Create Pivot Table style reports, without using Pivot Tables – no need to press “refresh” this way
- Quickly create dynamic loan amortization reports in Excel or dynamic calendars
- Master the new UNIQUE, SORT & SORTBY Excel Functions
- Use the brand new Excel RANDARRAY Function to randomly sort lists
- Use VLOOKUP, IF and SUMIFS together with Excel Dynamic Arrays formulas
- How to add Interactivity to your Excel reports as never done before
- How to use the new Dynamic Arrays formulas in your files
- How Excel’s calculation engine has changed and how this impacts all existing formulas
- Compatibility & how older files behave in the new Excel and New Excel files in the old Excel
- Do Dynamic Arrays make our spreadsheets faster or slower?
- Use Dynamic Array referencing as Excel chart ranges
- Solve difficult problems – such as split text and numbers from alphanumeric values & much more…
- Most importantly – how to think outside the box to solve any challenges you come across
Who this course is for:
- Business Professionals who use Excel to analyze data & create reports
- You’d like a complete course to understand ALL there is to Excel’s NEW Calculation engine
- You’d like to learn how to create interactive reports with Excel dynamic array formulas
Can I download Master NEW Excel Functions in Office 365 & Office 2021 course?
You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Master NEW Excel Functions in Office 365 & Office 2021 course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.com
Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.