Advanced Analysis & Visualization in Excel



Goal is Simple: Learn to create one pager executive dashboards in MS Excel that update with the click of the Refresh button, or with a simple copy-paste of your new data.

This course is suitable for you if you answer YES to:-

  • Do you want to spend less time creating reports and more time analyzing and gaining insights from the reports?
  • Do your reports take a long time to update each reporting cycle?
  • Do you want to gain skills to avail credible dashboards that allow the management to understand what is going on and make better decisions, quickly?

Course Description:

This training aims at making the process of “Data to Decisions” efficient and cost effective. This will be achieved by maximum utilisation of the most basic, easily available and affordable reporting tool MS Excel. For example, it is interesting to note that although ALL organizations have MS Excel and use it in more than 50% of their reporting/analysis processes, only about 10% of the features available in Excel are used in most of the organizations. In terms of ROI, MS Excel is among the worst performing reporting tools in most organizations.

This training provides you with the technical know-how to move from reporting your data with simple tables full of dull numbers to creating and presenting key information through the use of high-impact, meaningful and appealing reporting solutions (dashboards).

The course will help you to:

  • Explore top 15 advanced data analysis functions that will save your report generation turn-around time!
  • Move from static, dull reports to interactive and insightful dashboards -learn to apply form controls, slicers, pick lists, and camera tool to create interaction
  • Show top performers using formulas and YoY% by a click of a mouse
  • Achieve more with advanced analytical charts -Pareto chart, Scrolling charts, Gauge Charts
  • Easily spot trends and patterns in your data by using icon sets, traffic lights, Sparklines and Custom Number formats
  • Creating a dashboard in Excel step-by-step


  • Participant needs to have been a regular user of Excel (at least 40% usage in a week), and are comfortable with creating simple lookup formulas and charts, as well as customizing them.
  • If you are a beginner, we recommend that you start with less advanced Excel courses. You can write to Rael on  with your inquiry.

Logistics & Delivery Method

This hands-on experience and highly practical course is run in a computer laboratory with workstations provided, and installed with latest version of Excel. Participants may bring their own laptops if they prefer installed with MS Office suite, 2013 or higher.

Benefits & Inclusions

Among other give-aways you will benefit with the following:

  • A comprehensive manual of content covered
  • Certificate of participation
  • On-going help: you can always e-mail the facilitator
  • Networking: meet industry peers and hear how they approach this subject



Register here



June 2021


KES 66,500 per par­ti­cipant.  Cov­ers the train­ing fee and lunch & refresh­ments for the three days, as well as the certificate.

Ps. 5% off for groups of 5 or more

Strathmore NITA number is: IT/042.


3 Days ; 9:00 a.m – 12:00.p.m


See them here

Course Outline

Download Here

Cancellation Policy

Read on our training cancellation policy here.


Send an email to: Rael on or call 0703034416/ +254707768821

Register for the course here.