WHAT YOU WILL LEARN
This course transforms you from a basic user into a power user capable of handling complex data and business intelligence tasks:
Advanced Data Retrieval
Mastery of lookup functions including VLOOKUP, HLOOKUP, INDEX+MATCH, and the modern XLOOKUP.
Dynamic Data Analysis
Expertise in PivotTables and PivotCharts, including data grouping, slicers, and conditional formatting.
Business Intelligence (BI)
Proficiency in Power Query for data cleaning and Power Pivot for building relational data models.
Data Modeling & DAX
Introduction to building data relationships and writing DAX measures for sophisticated calculations.
Financial Modeling
Practical application of financial functions such as NPV, IRR, PMT, and FV for business forecasting.
Automation
Basic skills in Macro recording and an introduction to VBA to automate repetitive spreadsheet tasks.


