Effective Charts and Visualizations in Excel and PowerPoint
Learn the secrets to create magazine-style charts and visually-rich tables that grab user attention!
Updated on Nov, 2025
Language - English
Office Productivity,Microsoft,PowerPoint
Lectures -36
Resources -16
Duration -5.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Looking for creative ways to present your data story?
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 are closely related to creating infographics!
Almost 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 from 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.
Who this course is for:
- Those involved in reporting or developing documents that require data visualization and charts
Goals
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.
Prerequisites
The ideal learner should have general exposure to Excel in a (preferably, corporate) reporting scenario. You'll however be able to easily follow through even if you're a student.
Curriculum
Check out the detailed breakdown of what’s inside the course
Before Jumping In...
2 Lectures
-
Introduction and Scope
-
DOWNLOAD these practice files first
Getting Started: Hidden Tricks for the Most Common Charts
8 Lectures
Grab Attention with Non-Standard Charts
12 Lectures
Adding Interactivity to Charts
3 Lectures
Create Visually-rich Tables using Excel Conditional Formatting
3 Lectures
Visually-rich Tables Using Custom Number Formats and Special Fonts
6 Lectures
Save Time with Branded Corporate Themes & PowerPoint Hacks
2 Lectures
Instructor Details
William Kiarie
William Kiarie is a dedicated and knowledgeable instructor with a passion for simplifying complex concepts and helping learners achieve their goals. With strong expertise in technology, programming, and practical problem-solving, he delivers clear, engaging, and hands-on lessons that bridge theory and real-world application. William believes in empowering students through continuous learning, critical thinking, and creativity and making his courses both informative and inspiring for learners of all levels.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now