Excel for Data Analysis

Clean, summarise and chart data with formulas, PivotTables and Power Query.

1. Excel Basics for Analysts: Cells, References and TablesSet up a worksheet the way analysts do: clean columns, correct cell references and an Excel Table.
2. Cleaning Data in ExcelFix the problems that break analysis: stray spaces, inconsistent text, numbers stored as text, duplicates and bad dates.
3. Formulas and Logical Functions: IF, AND, OR, IFSMake a worksheet decide things: categorise rows, combine conditions and handle errors cleanly.
4. SUMIFS, COUNTIFS and AVERAGEIFSAnswer business questions such as revenue by region or orders above a value, using one formula each.
5. Lookup Functions: XLOOKUP, VLOOKUP and INDEX MATCHPull matching values from another table, the Excel equivalent of a database join.
6. Text and Date FunctionsExtract parts of text, build labels and calculate with dates: month ends, working days and time between dates.
7. Dynamic Arrays: FILTER, SORT and UNIQUEWrite one formula that returns a whole list: unique values, sorted results and filtered rows that update themselves.
8. PivotTablesSummarise thousands of rows in seconds by dragging fields: totals, counts, percentages, groups and slicers.
9. Charts and Conditional FormattingChoose the right chart for the question, remove clutter and highlight what matters in a table.
10. Power Query: Repeatable Data PreparationImport, clean, reshape and combine data with steps that re-run on refresh, so you never repeat manual cleaning.
11. What-If Analysis and Statistics in ExcelTest scenarios with Goal Seek and data tables, then describe data with averages, spread and correlation.
12. Project: Build a Sales Dashboard in ExcelCombine everything from this course into one interactive page with KPIs, charts and slicers.