• LOGIN
  • No products in the cart.

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

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.