Excel Charts Masterclass: Visualization Rookie to Charts Pro

Charts Basics, Bar Charts, Pie Charts, Combo Charts, Data Visualization , Practical Real Life Examples

What you'll learn
Design professional-looking Excel charts using techniques such as color gradients, data labels, axis titles, bold text, chart titles, and adjusting data series
Learn to communicate a clear message using Excel charts by curating information, removing unnecessary elements, and ensuring comprehension within 5 seconds
Recognize when to use Pie Charts, Bar Charts, or Line Charts in real-life professional contexts.
Apply best practices for creating charts to enhance business understanding and facilitate effective business discussions.
Create basic charts, including clustered bar charts, stacked bar charts, and bar charts with totals in Microsoft Excel.
Create basic pie charts, doughnut charts, and pie-of-pie charts in Microsoft Excel.
Explore advanced charting techniques by creating combo charts that combine bar charts and line charts. Add data labels to the combo charts
Create pivot charts by pivoting data to group and display specific data in chart format. Learn to easily update the data set.
Create basic line charts and apply them in real-world contexts such as tracking sales evolution, cumulative sales evolution, and cash flow evolution.
Requirements
This course is designed for learners of all levels, including those with no prior experience in Excel. I will provide a step-by-step approach to ensure you can create charts effectively.
While not mandatory, having some familiarity with Excel, especially Pivot Tables, may make one short section of the course easier to follow (Pivot Charts). Rest assured, I'll guide you through it.
Description
This course is given by a Professional Accountant that has more than
10 years of experience
with Charts.
The course is going over
charts basics up to advanced details
that can make your charts shine.
I really gave my heart in this course and did the best to share you my
10 years of experience in less than 1 hour.
At the end of this course you should be able to
make stunning presentations
and really be a Charts Expert.
The course is focusing on the
MOST USED charts
that can answer
95% of the questions
in your day-to-day.
The
goal
of this course is to
help you make better charts
in Excel and deliver a better message when you make presentations.
The
sections
on this course are :
Bar Charts
(Including assignment)
Pie Charts
(Including assignment)
Line Charts
(Including assignment)
Combo
&
Pivot
Charts
Additional Content
section with quick tips to gain productivity/make your charts shine
At the beginning of each section, there is a
one pager PDF that
summarizes the information contained in the section. You can print these PDF prior, during or after the course in order to consolidate the information learned during the course.
I have built a
Use case
that we follow through most of the course for you to remember the context. In this way, if you can't do the course in a single session, you can easily digest and consume section by section. Each section are
less than 15 minutes
and my ultimate goal is for you to finish this course while having fun (Yes Excel can be fun)
I would very much appreciate if you could
leave a review
so I can improve and make this course better and better.
Who this course is for:
Excel Enthusiasts: Individuals seeking to expand their Excel skills and proficiency in creating various types of charts, including bar charts, pie charts, combo charts, and line charts.
Business Analysts: Professionals looking to enhance their data visualization skills and use Excel charts effectively for business analysis, including sales tracking and cash flow analysis.
Finance Professionals: Accountants, financial analysts, and finance managers interested in improving their financial reporting and data visualization capabilities.
Sales Managers: Sales professionals and managers aiming to gain insights into sales trends and effectively communicate them through charts.
Entrepreneurs: Business owners and entrepreneurs looking to leverage Excel for data-driven decision-making and financial analysis.
Students and Educators: Students and educators seeking practical Excel charting skills for coursework or teaching purposes.
Aspiring Business Analysts: Individuals preparing for a career in business analysis and wanting to acquire skills in creating professional charts and using best practices for data presentation.

More Info