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
We inform you that the site allows the sending of technical cookies to give you the best experience on our website, as well as "third-party" cookies, including profiling cookies. We furthermore inform you that on the full privacy policy page, you can deny consent to the installation of any cookie. The continuation of the navigation will be considered an implicit consent to the use of cookies. Read MoreCookie settingsProceed to website
Privacy & Cookies Policy
Cookie Privacy
We inform you that the site allows the sending of technical cookies to give you the best experience on our website, as well as "third-party" cookies, including profiling cookies. We furthermore inform you that on the full privacy policy page, you can deny consent to the installation of any cookie. The continuation of the navigation will be considered an implicit consent to the use of cookies.
This site uses its own and other profiling cookies to ensure a better online experience, to personalize content and advertising, to provide social media features and to analyze our traffic. To deny consent to cookies, click on the opt-out button.