PAY-BACK
17990
Excel Crash Course - Data Analysis, Dashboards and Heatmaps
Business ► Data Science
Software ► Office
English 
Certified skills you will learn
Business
Data analysis
Business
Problem-solving
Business
Analytical skills
Computer Science
Excel power user
Skills legend
Levels
Skills have 3 levels to communicate the right grade of competence.
29 lectures
3 hours
Certificates
179.90 €
Analysis of Twitter Dataset and Designing Heatmaps
Lecture 1Understanding the dataset
05:23
Lecture 2Extracting other details for analysis
09:09
Lecture 3Creating Pivot tables
07:58
Lecture 4Applying Conditional Formatting using Colour Scales
02:30
Lecture 5Applying Custom Number Formats
03:20
Lecture 6Adding Slicers to Dashboard Pivot Tables
01:40
Lecture 7Adding Custom Image to Charts
11:25
Lecture 8Interlude - Data Manipulation Challenge
01:50
Lecture 9Adding Heatmap Legend
01:33
Lecture 10Wrapping up - Introduction to Open Analytics
02:01
Advanced Currency Converter Using Dynamic Arrays with Power Query
Lecture 11Introduction to Modern Excel Tables and Dynamic Arrays
11:15
Lecture 12Introduction to Power Query in Excel
08:25
Lecture 13Applying Power Query Transformations
06:20
Lecture 14Structured Table Referencing
11:35
Lecture 15The XLOOKUP Function and more Pivots
04:55
Laundry Service Model and Invoicing Dashboard
Lecture 16Introduction to the Project
01:26
Lecture 17Overview of the Laundry Model Project
03:43
Lecture 18Understanding the Inputs
03:01
Lecture 19Formatting Input Tables
04:11
Lecture 20Duplicate and Combine Tables with Power Query
09:21
Lecture 21Rounding Digits in Power Query
01:42
Lecture 22Load Specific Tables from Power Query
01:50
Lecture 23Feature Extraction and Named Ranges
09:57
Lecture 24Combining Elements - Data Validation and Named Ranges
07:49
Lecture 25Combining Elements - Understanding the INDIRECT Function
02:28
Lecture 26Combining Elements - Dynamic Drop-down Menu with Data Validation
03:35
Lecture 27Combining Elements - INDEX and MATCH with Multiple Criteria
11:58
Lecture 28Understanding the MATCH formula with Multiple Criteria
05:51
Lecture 29Laundry Business Invoicing Dashboard
06:16