SPECIALISTS IN FINANCIAL MODELLING
36 item(s) $1,185.00 AUD + GST

Advanced Excel & Dashboard Reporting - Chandoo Masterclass

Course info

Duration : 2 Days

Cost: $1,540.00 inc. GST.

Testimonials

"The presenter was very knowledgeable & friendly - Good guy!Advanced Excel and Dashboards Masterclass, Sydney, May 2015"

View testimonials for this course

Download the course outline

Upcoming workshops

Take this course in-house

Online Courses

Interested in taking this course online? Register your interest now!

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

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 & material on Chandoo.org
  • Networking opportunities with fellow professionals & Chandoo
  • Email support for your Excel questions for three months by Chandoo.org

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 1:

  • A whirlwind tour of modern Excel features
  • Data Analysis with Tables & Formulas
  • morning break
  • Data Analysis with Tables & Pivots
  • lunch
  • Effective business reporting with Excel
    • Which charts to use?
    • Common charting mistakes to avoid
    • Combining chart types & custom charts
    • Sparklines
    • Lightweight charting with Conditional Formatting
    • Maps

Day 2:

  • What makes a good dashboard?
  • Creating our first dashboard in Excel - Hands-on Exercise
  • Morning break
  • Building the calculation engine
  • Lunch
  • Adding visualizations
  • Dashboard Refinements
    • Interactive elements - slicers, timelines, form controls
    • Printing, publishing and sharing the report
  • Learning from world's best dashboards

Chandoo, Your Masterclass Leader

Chandoo, known for his most popular Excel & Dashboard site, Chandoo.org is famous for his clear explanations, practical approach and Excel mastery. Chandoo has trained more than 5,000 professionals from all over the world in Excel, Advanced Excel, Dashboards, VBA & Project Management. For his contribution to MS Excel users, Microsoft has awarded him the prestigious MVP award for years 2009, 2010, 2011, 2012 & 2013.

Chandoo (otherwise known as Purna Duggirala) is an MBA with more than 8 years’ experience in Excel based dashboards, reporting & consulting, and regularly travels the world delivering his specialist workshops.

What Chandoo’s past students say:

  • Chandoo is full of new innovative ways to crunch and communicate data.
  • The course contained good examples; he is a very open and responsive teacher.
  • This course has taught me more than I learnt in three years of working on my own!
  • It really made me re-evaluate the way I worked Excel to deliver my results.
  • I’ve always loved working with Excel, but this course gave me the kick to take my existing skills to the next level.
  • I enjoyed learning about the new, innovative features of Excel. Watching them used in ways that differ from what I have become accustomed to was great. The most mind-expanding topic for me was SUMPRODUCT formula. Very clever!

What do you get?

By attending this workshop, you will receive:

  • Two full days of tuition by Dashboard expert, Chandoo
  • Use of workstations, lunch and refreshments
  • Access to selected videos & material on Chandoo.org
  • 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 & material on Chandoo.org
  • Networking opportunities with fellow professionals & Chandoo
  • Email support for your Excel questions for 3 months by Chandoo.org

What should you have?

Suggested Skill Level

To benefit the most from this workshop, you need to have intermediate level working knowledge of MS Excel. 
Understanding of basic business terminology and reporting situations. 
Targeted at managers, analysts & reporting professionals with 3-7 years of experience

Software

This Masterclass is run in a specialist training venue with workstations provided. The course is demonstrated using Microsoft Excel 2016, but students can use older versions if they prefer. Delegates may also bring their own laptops.

Course fee of only $1,400 plus GST includes:

  • Two full days of tuition by Dashboard expert, Chandoo
  • Use of workstations, lunch and refreshments
  • USB stick with Example workbooks, PDF guides & videos
  • Access to selected videos & material on Chandoo.org
  • Email support for Excel questions for 3 months following the course by Chandoo.org
Attend all four days for $2,400 plus GST - Use Coupon Code: CHANDOO_2018 at checkout.