The Most Complete Excel Dashboards Training2018-07-21T16:32:50+00:00

Executive Excel Dashboards Training

Cut down by over 60% the time spent producing reports.

For better trainer interaction, only 12 spots are open. Claim your seat now

Date: 19-21 Sep, 2018  |  Fee: KES 41,900 |  Cut-off: Fri 14th Sep, 2018 |  Venue: The Heron Portico Hotel, Nairobi

Apply Now
excel dashboards for pharmaceuticals

Business managers need timely access to accurate data – presented in a clear and understandable way.

DCA’s Excel Dashboards course equips you with the skills needed to build informative, professional, visual-rich dashboards that will allow managers to step back from the details and see the key trends and relationships that drive their companies …with responsive features to switch views

Download this dashboard

Save time. Save money

Let us do the maths…

Assuming you spend 8 hours (probably more) in a month working on a certain report (i.e. before you can start interrogating the numbers). This translates to 96 hours in a year.

Now, let’s take a conservative estimate that your time is worth $20 per hour. That is $1,920 worth of your time every year!

And…

Am sure you’re familiar with the end-month reporting nightmares, uh?

This excel dashboard reporting course shows you how to set up your dashboards so that they take less time and effort to update.

You can then leave office early, spend more time with family or enjoy whatever you like instead of being stuck with reports till midnight.

What else do you get?

This course has all it takes to make you a true Excel dashboard hero. We stick closely to what’s really important. That is, the really key techniques for the user to pick up and use in a very practical way.

FEEDBACK

Don’t just take our word for it! Here are some of the unsolicited client speak.

excel dashboards past trainee

“The skills I acquired were life changing! The revelations of concepts that I could use to reduce manual work was just amazing. I’ve since applied these techniques which has helped sort of automate the reports resulting in greater speed of execution and less errors”


financial dashboards in excel

“Your dashboard training has already saved me a lot of time! I have used some tips which to present my funding analysis by location and staff type. Every month I just paste the new data and my source table self-adjusts. Magic! I then click the refresh button and my management dashboard is ready, just like that!”


Yakub Mohamed, Finance Officer, WFP

Course Structure

We’ll teach you the secrets that separate the analysis experts from the people with academic knowledge Excel. It is the level self-knowledge will not get you to.

Pre-Requisites

We believe in effective training and tangible results, hence, if you are a beginner, or even a regular user of Excel but are not familiar with VLOOKUP, basic charts and Pivot tables, this course is not for you. Completion of our Intermediate Excel course or its equivalent is important.

We like being honest -dashboard courses labelled for “all levels” end up being (as you already know) a frustration as you will end up just covering the basics!

Course Outline

Whether you want to create a financial dashboard, HR dashboard, marketing dashboard, or any other functional Excel dashboards, the formulas and techniques that you follow are the same.

Learn the different tools in Excel and how to expertly mix them together to creatively deliver value at high speed.

  • Retrieving external data
  • Data cleansing procedures –fill blanks, cleaning duplicates, creating auxiliary columns to segment data
  • How to deal with dates in your Excel dashboard using the TEXT, YEAR, MONTH, TODAY
  • Working with linked shapes for stylish dashboards
  • Pasting picture links and use of the Camera tool
  • Special charts –Gauge, Waterfall, Bullet charts
  • The REPT function for in-cell charts
  • Creating miniature charts suitable for dashboards
  • Showing trends using Sparklines
  • Make important data to stand out using conditional formatting –traffic lights, positive and negative indicators
  • Using the camera tool and/or linked pictures
  • Create scrolling charts to present a long list of information
  • Decision-making functions: IF, CHOOSE
  • Conditional aggregation functions: SUMIFS, COUNTIFS
  • Showing top/bottom performers using LARGE, SMALL, IF, RANK.EQ
  • Advanced pivot charts techniques -the applications
  • The proximity principle
  • User requirement analysis
  • Dashboard final touches, e.g. making slicers static, disabling resize on charts and other shapes, freezing to disable scrolling
  • Transferring your analytics into your dashboard
  • Drop down lists
  • Applications of Form and/or ActiveX controls (option buttons, combo boxes) and linking these to charts or key metrics
  • Leveraging on slicers –connect to multiple reports and customize their look to brand them
  • Self-adjusting named ranges

Join the Executive Excel Dashboards Course

Ready to Improve Your Reporting?

Booking Information

  • Remember, only 12 spots are available for this class. Cut-off date: Fri 14th Sep 2018
  • The workshop will run from 9am – 4pm.
  • Parking will be provided at the hotel at no extra cost.
  • Delegates should carry their laptops installed with MS Office 2010, 2013, or (preferably) 2016
Date Time Fee Venue
19-21 Sep, 2018 9am – 4pm KES 41,900 The Heron Portico Hotel, Nairobi
Book my seat now

Do you get a discount?

We have two discount options available. The discounts cannot be combined.

  • 10% early bird discount for registrations completed on or before Tue 4th Sep 2018
  • 10% corporate discount for 5 or more delegates

Corporates can run this course in-house with a minimum of 8 delegates

Want to run this in-house?

Contact Us

Who is teaching this course?

excel dashboards trainerWilliam is a seasoned data analytics and visualization consultant with over 7 years of experience in the field.

He has trained thousands of staff in various corporates including PwC, Tullow Oil, NIC Bank, World Vision, Toyota Kenya, Kuehne+Nagel, Unilever Tea, among many on how to leverage MS Excel and Power BI to create executive dashboards.

He holds a degree in Applied Statistics with Computing (BSc.) from Moi University, and a certificate on Analyzing and Visualizing Data with Power BI from Microsoft.

Don't be locked out. Enroll for the Excel dashboard class today!

Download FREE chart book

You also give consent to receive the latest news and marketing materials about our products. You can unsubscribe anytime.
Download Now