Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 27th Jul'25 to 06th Aug'25
Data Visualization - Charts and more in Excel
- How to choose the correct chart for your data – it’s not just pie charts
- Formatting your chart
- Large datasets – you need a pivot chart
- Working around pivot chart limitations
- How to use conditional formatting to highlight areas of interest.
- Getting your chart into PowerPoint – Dos and Don’ts.
Overview of the webinar
A key part of data visualization is choosing the correct chart for your data. While the much-loved pie chart is a “go to” for many users, it is often not the best fit for your data. But how to choose?
Excel can help you choose the chart that is the best fit so that you can show off your data to its best.
We will also be looking at data structure practices around how to make chart creation easier and some hacks about how to work around your data selection process.
You will learn how to format your chart to make it more visually appealing and make it easier for your audience to understand.
You will learn how to create a pivot chart for larger datasets and identify some of its limitations and how to work around them.
You will see how to use conditional formatting to color code your data automatically and identify duplicates and outliers
You will also learn how to easily get your chart into PowerPoint.
Identify Dos and Don’ts about when you do that and also how to apply animation to your chart to make your presentation slicker.
The session will be practical, fun and will be demonstration based. The working file will be provided as well.
Who should attend?
- All Excel Users
- Any Individual that is tasked with presenting data for reports or decision making
Why should you attend?
If you need to be able to present your data in a visually appealing way, you need to be able to choose the correct chart and format it in a way that gets your message across. This session will help you do that.
If you are working with larger datasets, regular charts will not be fit for purpose and you will need to use a pivot table. You will learn how to do that in this session.
If you want to use color to highlight specific areas of your data or identify entries that meet certain criteria, Conditional formatting in Excel can help you do that. Learn how to apply conditional formatting to identify areas of interest.
If you need to get your Excel chart into PowerPoint – this will help you identify possible pitfalls and how to avoid them.
Faculty - Ms.Anne Walsh
Making Excel & Power BI Training Effective & Enjoyable | Amazon Best-Selling Author | 25+ Years of Referral-Driven Success. Puts the “fun in functions” and has been known to use puns.
Best selling Amazon author of Hate Excel? Learn to love the software that can transform your confidence and career.