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).

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

Suitability:

This course is definitely NOT for you if locking cells ($ sign), VLOOKUP & PivotTables are news to you!

You need 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.

This course is not suitable for Absolute Beginners in Microsoft Excel. If you are a beginner, we recommend that you start with less advanced Excel courses. You can write to Getrude on getrude.gichuhi@strathmore.edu 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

.

Upcom­ing Train­ing Days

24th -26th April 2019

17th – 19th July 2019

18th -20th September 2019

Cost

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.