Advanced Excel Analytics | |||
Module 01: Introduction | 00:05:00 | ||
Module 02: How to Benefit from the Course | 00:02:00 | ||
Module 03: Download Project Files | 00:07:00 | ||
Module 04: Exploring Project Data | 00:05:00 | ||
Module 05: Data Cleaning and Customization | 00:03:00 | ||
Module 06: Understanding Data Values | 00:04:00 | ||
Module 07: Date and Time Categorized | 00:07:00 | ||
Module 08: Combine Date and Time Field | 00:05:00 | ||
Module 09: Categorize Weather Conditions by Logical Operation | 00:09:00 | ||
Module 10: Advanced Percentile Calculation | 00:11:00 | ||
Module 11: Joining Data from Multiple Sources | 00:08:00 | ||
Module 12: Joining Data by VLOOKUP and MATCH Function | 00:09:00 | ||
Module 13: Analyzing Trends by COUNTIF Function | 00:09:00 | ||
Module 14: Create Real Time Data Feed by Free API | 00:06:00 | ||
Module 15: Extract Realtime Data by Filter XML Function | 00:11:00 | ||
Module 16: Categorize Realtime Data by VLOOKUP & Conditional Formatting Part 01 | 00:06:00 | ||
Module 17: Categorize Realtime Data by VLOOKUP & Conditional Formatting Part 02 | 00:06:00 | ||
Module 18: Generate Dynamic Source Data by INDEX and MATCH Function | 00:06:00 | ||
Module 19: Build Chart Visualization by TRIGONMETRY Function | 00:07:00 | ||
Module 20: Formatting Combo Chart Visualization | 00:05:00 | ||
Module 21: Formatting and Customization Technique Part 1 | 00:07:00 | ||
Module 22: Formatting and Customization Technique Part 2 | 00:06:00 | ||
Module 23: Advanced Formatting and Dashboard Design | 00:06:00 | ||
Module 24: Course Wrap up | 00:06:00 | ||
Resources | |||
Resources – Advanced Excel Analytics | 00:00:00 | ||
Assignment | |||
Assignment – Advanced Excel Analytics | 00:00:00 |
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.