This course with Excel MVP Oz du Soleil takes you beyond basic spreadsheet skills to harness the full analytical power of Microsoft Excel. Oz begins with essential keyboard shortcuts and formula development strategies that will dramatically increase your efficiency. You’ll explore a comprehensive range of advanced functions including XLOOKUP/VLOOKUP, INDEX, and sophisticated counting, statistical, text, date/time, array, mathematical, and information functions. Each concept is explained through practical, real-world examples that demonstrate how these powerful tools solve complex data challenges. Learn how to develop a personal style for approaching formula creation as well as how to troubleshoot when formulas don’t behave as expected. The course concludes with challenging exercises designed to test and reinforce your new skills, ensuring you can confidently apply advanced Excel functions in your professional work.
Learn More
