Excel Charts Masterclass: Visualization Rookie to Charts Pro

Focused View

David Fortin

40:53

56 View

1. Introduction

1. My professional career as a CPA (Whos your instructor).mp4

01:42

2. This course format.mp4

01:05

3. The Data Set Example.mp4

00:56

4. Charts Basics.mp4

01:52

2. Bar Charts

1.1 Daily Use - Bar Charts - Presentation Support.xlsx

1.2 Daily Use - Bar Charts - Presentation.pptx

1.3 One Pager - BAR CHARTS V3.pdf

1. Use Cases How I use Bar Charts in my day-to-day.mp4

01:32

2.1 How To Make Bar Charts - Bar Charts.xlsx

2. How to make Bar Charts.mp4

01:31

3. Adding column totals on bar charts (Using combo charts).mp4

04:35

4. The Danger of Bar Charts.mp4

01:49

5. Bar Charts Assignment.html

3. Pie Charts

1.1 Daily Use - Pie Charts - Presentation Support.xlsx

1.2 Daily Use - Pie Charts - Presentation.pptx

1.3 One Pager - PIE CHARTS V2.pdf

1. Use Cases How I use Pie Charts in my day-to-day.mp4

02:18

2.1 How To Make Pie Charts - Pie Charts.xlsx

2. How to make Pie Charts.mp4

01:24

3. Pie of pie.mp4

01:38

4. Danger of Pie Charts.mp4

01:16

5. Pie Charts Assignment.html

4. Line Charts

1.1 Daily Use - Line Charts - Presentation Support.xlsx

1.2 Daily Use - Line Charts - Presentation.pptx

1.3 One Pager - LINE CHARTS V1.pdf

1. Use Cases How I use Line Charts in my day-to-day.mp4

03:10

2. How to make Line Charts.mp4

04:39

3. Danger of Line Charts.mp4

00:28

4. Line Charts Assignment.html

5. Combo Charts & Pivot Charts [Assignment Free yay!]

1.1 Daily Use - Combo Charts - Presentation Support.xlsx

1.2 Daily Use - Combo Charts - Presentation.pptx

1.3 How To Make Combo and Pivot Charts.xlsx

1.4 One Pager - COMBO CHARTS V5.pdf

1. Use Cases How I use Combo Charts in my day-to-day.mp4

01:56

2. How to make Combo Charts.mp4

01:38

3. How to make Pivot Charts.mp4

04:57

6. Additional Content

1. Quick tip 1 Multi Level Charts.mp4

00:18

2. Quick tip 2 PivotCharts in 15 seconds.mp4

00:15

3. Quick Tip 3 Transform your data in tables, so your chart automatically update.mp4

00:34

4. Quick Tip 4 Waterfall Charts.mp4

00:28

5. Quick tip 5 Sparklines.mp4

00:20

7. Conclusion

1.1 One Pager - BAR CHARTS V3.pdf

1.2 One Pager - COMBO CHARTS V5.pdf

1.3 One Pager - LINE CHARTS V1.pdf

1.4 One Pager - PIE CHARTS V2.pdf

1. Thank you!!! Please leave a review and watch this last video!.mp4

00:32

Description

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.

Who is this 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.

What You Need to Know?

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.

More details

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.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Charts

David Fortin

Instructor's Courses

I am a CPA / Je suis CPAI go by / Mon avatar est Piggy Bank Accountant I teach you Excel the fun way / Je vous enseigne Excel de façon moderne- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -EnglishI worked for a Big Four (Accounting Firm) for a few years, then in Financial Planning & Analysis for Ubisoft and now I work for a tech company! Feel free to ask anything and reach out directly on social medias. Youtube is where I'm the most active (under the handle "Piggy Bank Accountant)- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -FrenchJ'ai une expérience importante en matière de comptabilité en entreprise. J'ai plus de 10 ans d'experience avec Microsoft Excel et j'ai géré des dossiers importants tel que le financement d'une entreprise pour plus de 30M$ et la vente de cette dernière pour plusieurs centaines de millions. Je fais beaucoup de video tutoriel/astuce Excel sur Youtube (sous le nom de "Piggy Bank Accountant En Français")Il est possible pour nous de travailler ensemble! N'hésitez pas à me rejoindre

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.