Effective Charts and Visualizations [Excel & PowerPoint]

person icon William Kiarie

Buy Now

Effective Charts and Visualizations [Excel & PowerPoint]

Name: Effective Charts and Visualizations [Excel &amp; PowerPoint]
Price: 9.99 USD
Author: William Kiarie

Learn the secrets to create magazine-style charts and visually-rich tables that grab user attention!

updated on icon Updated on Sep, 2023

language icon Language - English

person icon William Kiarie

architecture icon Data Visualization,Excel,Power Point,Office Productivity,Microsoft

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint 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 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.

Who this course is for:

Those involved in reporting or/and developing documents that require data visualization and charts

Goals

What will you learn in this course:

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

What are the prerequisites for this course?

The ideal learner should have a 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.

Effective Charts and Visualizations [Excel & PowerPoint]

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

Everything data analysis and visualization in Excel | Power BI | Google Sheets

I create engaging content that draw practical scenarios from my 10+ years career training staff of different companies to use Excel, Google Sheets and Power BI efficiently and effectively.

My goal is to help you process data faster, and accelerate time-to-insights for timely decision making. I also hope that if you're looking for a job, the skills taught will give you an upper hand in interviews and in your roles.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.