How to Combine Data from Multiple Worksheets into One Master Worksheet

One of the common headaches I have come across in the course of my career as a Trainer in Excel Dashboards is the question of how to combine data from multiple worksheets into one master worksheet, so that you can [...]

By |2018-11-27T11:44:23+03:00November 6th, 2016|

Using Shapes for Stylish Excel Dashboards

One of the key skills that will set you apart as an analyst is the ability to provide management with a distilled view of the key company numbers, with the ability to have multiple views in interactive Excel Dashboards. Surprisingly, using [...]

By |2018-09-06T10:54:13+03:00June 2nd, 2016|

4 steps: How to Create Waterfall Charts in Excel 2013

Safaricom, the most admired brand in the telecommunication industry in Kenya has seen yet a more profitable year 2015 with total revenue having a YoY growth of +12.9% to 163.4bn, whereas Free Cash Flow (FCF) grew by +21.3% to 27.5bn (Source: Safaricom Financial [...]

By |2017-12-15T16:50:27+03:00May 13th, 2016|
Grow your career with this FREE ONLINE video course

Zero to Pro with Excel Pivot Tables

  1. Pivot table fundamentals
  2. Save time with advanced hidden concepts
  3. Interactive Pivot-driven dashboard
  4. Intro to Power Pivot & Power Query
  5. Over 10 video lessons