Excel: Advanced Formulas and Functions (2026)
Released 9/2026
With Oz du Soleil
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Skill level: Intermediate | Genre: eLearning | Language: English + subtitle | Duration: 3h 10m | Size: 799.8 MB
Examine tables, IF statements, lookups, dynamic arrays, and many more functions and formulas you can use for sophisticated data challenges.
Course details
Embark on a journey through advanced Excel formulas and functions. Learn how to use tables and dynamic arrays to maintain data integrity effortlessly. Learn about the power of IF statements and conditions to build decision-making capabilities into your spreadsheets. Explore the versatile lookup functions like VLOOKUP, XLOOKUP, and INDEX/MATCH to compare and combine data efficiently. Discover strategic formula tips that will enhance your formula-building process, making them more readable and less error-prone. Learn how to work with text and arrays, employ statistical and math functions, and harness dynamic solutions with the cutting-edge features in Excel. Intended for intermediate to advanced Excel users, this course is well-suited for those looking to push their Excel skills to new heights. By the end of this course, you will be more equipped to manage and navigate data effectively to make more informed data-driven decisions.
Skills covered
Excel Formulas, Microsoft Excel, Microsoft 365 Copilot
Homepage
Excel: Advanced Formulas and Functions (2026)
