Excel Financial Dashboards
COURSE OVERVIEW
Create eye-catching dashboards and reports that will command attention in your company. Discover how to compile and convert enormous amounts of data into concise visual information.
Use Excel’s features to create complex, interactive tables and charts to raise the standard of your reporting. Understand the principles underlying dashboard design so you can consistently generate work of the highest caliber.
You will learn all you need to know about creating a dashboard report, including how to build your calculations. If you adhere to these straightforward guidelines each time, your spreadsheets will be structured and you’ll be able to create Excel dashboards that are simple to update.
The course includes the following key topics:
TOPICS
• Introduction to Excel Dashboards
• Creating Charts and Graphs
• Creating Tables and Pivot Tables
• Adding Filters and Slicers
• Adding Conditional Formatting
• Data Preparation
• Creating the Dashboard
• Using Filters and Slicers
• Sharing the Dashboard
And much more!
WHO SHOULD ATTEND
- Those who wish to design attractive dashboards in Excel.
- Those upgrading from earlier software versions and those with a basic understanding of Excel 2019/365.
- Users who already have a solid understanding of Microsoft Excel and want to improve it.
OUTCOMES
- Create eye-catching dashboards and reports that will command attention
in your company. - Discover how to compile and convert enormous amounts of data into concise visual information.
- Use Excel’s features to create complex, interactive tables and charts to raise the standard of your reporting.
- Understand the principles underlying dashboard design so you can consistently generate work of the highest caliber.
- You will learn all you need to know about creating a dashboard report, including how to build your calculations.
TRAINING CHANNELS:
Choose your preferred training type/method of delivery below.
IN-HOUSE TRAINING
We come to you!
ON DEMAND TRAINING
Flexible Training: No minimum delegates. Your Date. Your Duration. Face to Face or Online.