Data Analysis with Microsoft Excel

This course takes you from basic spreadsheet habits to genuinely analytical Excel skills used by business analysts every day. You will learn how to structure data properly, write lookup and logic formulas like XLOOKUP and SUMIFS, and clean messy data with text functions and data validation. From there, you will build PivotTables and charts to summarize and visualize large datasets, and use conditional formatting to build simple dashboards. The final module covers advanced techniques: What-If analysis tools (Goal Seek, Data Tables, Scenario Manager) and an introduction to Power Query and Power Pivot for handling larger, messier, multi-table datasets. By the end, you will be able to take a raw export and turn it into a clean, summarized, decision-ready analysis.