Working with Real Time Data in Excel

2016
1:18 hours

00 – Introduction
Welcome
What you should know before watching this course
Using the exercise files
Using the knowledge checks
01 – Project Files
Download and explore files
02 – Standardize Date Fields
Custom date dimensions
Date formatting
Combine fields with concatenate
Knowledge check
03 – Create New Data Dimensions
Categorize data
Calculate percentiles
Join data with VLOOKUP
Knowledge check
04 – Combine Data to Evaluate Impact
Move tabs across workbooks
Combine VLOOKUP and MATCH to join data
Use COUNTIF to analyze trends
Scale values to a custom range
Knowledge check
05 – Real-Time Data Integration
Create an API feed with WEBSERVICE
Extract components with FILTERXML
Categorize real-time data
Knowledge check
06 – Custom Combo Chart Visualization
Generate dynamic chart source data
Build a combo chart
Customize formatting
Knowledge check
07 – Wrapping Up
Key analytics concepts
Apply the skill set
Knowledge check
08 – Conclusion
Next steps: Share, connect, and explore
Exercise Files