The tool every analyst uses daily: data cleaning, essential and advanced formulas, XLOOKUP, pivot tables, Power Query, charts and interactive dashboards, with real business datasets.
Course Curriculum
| 1. Excel Foundations | |||
| 1.1 The data analyst role and the analysis process | 00:09:00 | ||
| 1.2 Workbooks, sheets, tables and formatting | 00:10:00 | ||
| 1.3 Sorting, filtering and conditional formatting | 00:10:00 | ||
| 2. Formulas | |||
| 2.1 Math and statistical functions | 00:12:00 | ||
| 2.2 Logical functions: IF, IFS, AND, OR | 00:12:00 | ||
| 2.3 Text and date functions | 00:12:00 | ||
| 2.4 XLOOKUP, INDEX and MATCH | 00:14:00 | ||
| 2.5 SUMIFS, COUNTIFS and AVERAGEIFS | 00:10:00 | ||
| 2.6 Dynamic arrays: FILTER, SORT, UNIQUE | 00:12:00 | ||
| 3. Data Cleaning | |||
| 3.1 Common data problems and how to fix them | 00:10:00 | ||
| 3.2 Power Query: import, clean and transform | 00:15:00 | ||
| 3.3 Merging and appending tables | 00:10:00 | ||
| 4. Analysis & Dashboards | |||
| 4.1 Pivot tables and pivot charts | 00:15:00 | ||
| 4.2 Choosing the right chart | 00:09:00 | ||
| 4.3 Slicers and interactive dashboards | 00:14:00 | ||
| 4.4 What-if analysis and Goal Seek | 00:09:00 | ||
| 4.5 Final project: sales dashboard for a retail company | 00:22:00 | ||
Course Reviews
No Reviews found for this course.






Up Academy Data & AI Team