Excel Charts Masterclass: Visualization Rookie to Charts Pro
Charts Basics, Bar Charts, Pie Charts, Combo Charts, Data Visualization , Practical Real Life Examples
Ratings 4.67 / 5.00
What You Will 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.
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 Should Attend!
- 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.