Course Information
Course Overview
Learn the secrets to create magazine-style charts and visually-rich tables that grab user attention!
Looking for creative ways to present your numbers with impact?
If you’re willing to think beyond and explore more than the pie charts, then you can use Excel to achieve impressive visualizations (charts & tables) that will add credibility to your reports and presentations.
Through interactive and hands-on demos and exercises you’ll learn modern data visualization techniques that have close resemblance to creating infographics!
Fairly all the charts presented in this course can be created in both Excel and PowerPoint.
And…
I’ll also show you how to create themes (a colour palette and fonts) that you can access across Excel, PowerPoint and Word …to save you having to look for your corporate colour codes.
We’ll dive into both simple and advanced, but creative techniques that allow you to create your own Excel charts and visually-rich tables from scratch …with confidence.
Course Content
- 7 section(s)
- 36 lecture(s)
- Section 1 Before we dive in
- Section 2 Getting Started: Hidden Tricks for Common Charts
- Section 3 Grab Attention with Non-Standard Charts
- Section 4 Adding Interactivity to Charts
- Section 5 Create Visually-Rich Tables using Conditional Formatting
- Section 6 Visually-Rich Tables using Custom Number Formats & Special Fonts
- Section 7 S06 Save Time with Branded Corporate Themes & PowerPoint Hacks
What You’ll Learn
- How to select the right [recommended] chart for your data story
- Create stylish, magazine-style charts that grab attention
- Adding interactivity for dynamic charts
- Visually-rich tables [conditional formatting, custom number formats & special fonts]
- Create corporate themes accessible in MS Excel, Word & PowerPoint
- Creative PowerPoint tips
Skills covered in this course
Reviews
-
MMahabubul Alam
The content and delivery level are very good but the sound is required to more stronger and clearer.
-
KKannan V
Well curated, and flawlessly presented. Thanks, William for the knowledge transfer!!
-
VVita Iefymenko
The course was useful and interesting. Thank you
-
MMomchil Kiryakov
It provided me with a lot of useful information