Support

Advanced Excel & Dashboards - Chandoo Masterclass

0 sessions available

Subject: Finance

Ages: All ages

Skill level: All difficulty levels

Excel

Dashboards

Chandoo

This course is part of the 2015 Chandoo Masterclass Special Event. There are two masterclasses being run ONLY during May and June 2015 in Australia:

Advanced Excel & Dashboards (2 days)
Data Analysis & Power Pivot (2 days)
The masterclasses are designed to be attended for four consecutive days but either two day session can be undertaken independently. Chandoo is also available for a limited number of in-house sessions. Please contact us to book Chandoo to come to your organisation during his trip to Australia for a private in-house session.

Excel Dashboards are used to convey vital business information to senior management, partners & customers. In our two day Masterclass, learn how to create stunning, world-class Excel dashboards. Along the way, you will learn how to use various...

see more

This course is part of the 2015 Chandoo Masterclass Special Event. There are two masterclasses being run ONLY during May and June 2015 in Australia:

Advanced Excel & Dashboards (2 days)
Data Analysis & Power Pivot (2 days)
The masterclasses are designed to be attended for four consecutive days but either two day session can be undertaken independently. Chandoo is also available for a limited number of in-house sessions. Please contact us to book Chandoo to come to your organisation during his trip to Australia for a private in-house session.

Excel Dashboards are used to convey vital business information to senior management, partners & customers. In our two day Masterclass, learn how to create stunning, world-class Excel dashboards. Along the way, you will learn how to use various advanced features in Excel so that you can save time and look good in front of your bosses & colleagues.

Benefits of Attending

Exposure to best-in-class dashboard techniques, design ideas & practical tips
Tips & ideas on using Excel better
USB stick with Example workbooks, PDF guides & videos
Access to selected videos & materials
Networking opportunities with fellow professionals & Chandoo
Email support for your Excel questions for three months.

Who Should Attend

This program is aimed at:

Managers
Systems & Reporting Analysts
Business & Data Analysts
MIS Reporting Analysts
Business Intelligence Professionals
Executives in Sales, Finance, Marketing or Customer Service
If you use Excel for more than 6 hours a week, you will benefit from this Masterclass.

Masterclass Agenda

DAY ONE

8:45 Registration
9:00 Using Excel for reporting
9:30 Excel formulas for analysis & dashboards

Structural references & Tables
Summing & finding data based on conditions
10:30 Morning break
10:45 Excel formulas for dashboards (contd.)

Using lookups to drive dashboards
12:30 Lunch
1:30 Applying conditional formatting & Sparklines for dashboards
3:00 Afternoon break
3:30 Building our first dashboard – Hands on exercise

Defining goals
Preparing a sketch
Designing the data sheet
Building the calculations she et
Setting up the dashboard
5:00 End of day one

DAY TWO

9:00 Day 1 Re-cap
9:15 Selecting the right chart for your data
9:45 Excel charting tips & techniques for dashboards
10:30 Morning break
10:45 Advanced charting techniques

Budget vs. Actual comparison charts
Secondary axis & combination charts
Waterfall chart
Highlighting chart data as needed
Dynamic & interactive charts
12:30 Lunch
1:30 Building our second dashboard – Hands on exercise
3:00 Afternoon break
3:30 Dashboard exercise – contd.
4:30 Q&A – Open house
5:00 End of Masterclass

see less




My Other Listings

Advanced Financial Modelling in Excel
Advanced Financial Modelling in Excel
4 sessions available starting from $880.00
Essential Dashboards in Excel
Essential Dashboards in Excel
0 sessions available
Implementing Cost Reduction Strategies for Managers
Implementing Cost Reduction Strategies for Managers
0 sessions available

see all listings »