Self-Paced Course
Excel Pro Tips: Visualization
Think outside the pie chart and explore some of Excel’s more powerful visualization tools, like filled maps, interactive form controls, sparklines, and more.
Course Description
The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.
This course is all about bringing data to LIFE, using some of Excel’s most powerful visualization tools. We aren’t talking about your basic pie charts and line graphs here -- we’re talking about unique features like filled maps, sparklines, custom templates, dynamic visuals, interactive form controls, and much more.
It's time to start working smarter, not harder. If you're ready to become a certified data viz rockstar, this is the course for you.
COURSE CURRICULUM:
- Course Structure & Outline
- DOWNLOAD: Course Resources
- Setting Expectations
- Introduction
- Chart Properties (Move & Size)
- Hidden Chart Source Data
- Filled Maps (Excel 2016+)
- Customizing Charts to Tell a Story
- Adding Sparklines
- Custom Chart Templates
- Heat Maps with Color Scales
- Analyzing Distribution with Histograms
- Goal Pacing with Gauge Charts
- Highlighting Time Periods
- Dynamic Source Ranges
- Interactive Form Controls
- QUIZ: Visualization Tips
- Course Feedback Survey
- Share the love!
- Next Steps
WHO SHOULD TAKE THIS COURSE?
- Excel users who want to create clear and effective charts & graphs
- Analysts or BI professionals looking to create interactive reports and dashboards, build custom visuals, or master advanced charting techniques
- Anyone seeking to explore some of Excel’s most useful visualization tools & techniques
WHAT ARE THE COURSE REQUIREMENTS?
- Microsoft Excel 2007-2019+ or Office 365 for PC/Windows (some demos may be unavailable for Mac or Excel Online)
- Completing the full Excel Charts & Graphs course is recommended, but not required
Start learning for FREE, no credit card required!
Every subscription includes access to the following course materials
- Interactive Project files
- Downloadable e-books
- Graded quizzes and assessments
- 1-on-1 Expert support
- 100% satisfaction guarantee
- Verified credentials & accredited badges
Ready to become a
data rockstar?
Start learning for free, no credit card required!