Learn how to quickly feed real-time data from an API directly into Excel using WEBSERVICE and FILTERXML functions, enabling powerful insights and real-time analytics.
Overview
Syllabus
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Using the knowledge checks
- Download and explore files
- Custom date dimensions
- Date formatting
- Combine fields with concatenate
- Knowledge check
- Categorize data
- Calculate percentiles
- Join data with VLOOKUP
- Knowledge check
- Move tabs across workbooks
- Combine VLOOKUP and MATCH to join data
- Use COUNTIF to analyze trends
- Scale values to a custom range
- Knowledge check
- Create an API feed with WEBSERVICE
- Extract components with FILTERXML
- Categorize real-time data
- Knowledge check
- Generate dynamic chart source data
- Build a combo chart
- Customize formatting
- Knowledge check
- Key analytics concepts
- Apply the skill set
- Knowledge check
- Next steps: Share, connect, and explore
Taught by
Chris Dutton