Excel Dashboards: Show top/bottom values

If you have used the MAX and MIN functions in Excel, then you know they return a single value representing the highest and the lowest value in a given range.  LARGE and SMALL functions on the other hand allow you to specify whether you want the 2nd, 3rd, 4th, largest/smallest value in the same range. As such, you have to specify the range of values, as well as the ‘Kth’ element, where ‘K’ is any number 1, 2, 3, and so on. The ‘k’ element tells Excel what top/bottom values to return from the specified range. Continue reading “Excel Dashboards: Show top/bottom values”

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 Results). What fascinated me though is the use of the waterfall chart to visualize both the revenues and the FCF. But have you ever wondered how to create this chart in Excel? This post will give you the 4 steps you need to create a waterfall chart in Excel 2013.

WF2

Continue reading “4 steps: How to Create Waterfall Charts in Excel 2013”

4 Steps to become an Advanced Excel User

Are you a beginner or a super user in Excel. ‘Does it matter really‘, you may ask. If you have to leave the office at 9pm or later generating a report OR you would spend 4+ hours filling in blanks OR you have to sort your data to get the highest sales, then you need to work on your Excel skills to save you tonnes of hours among other benefits!

Continue reading “4 Steps to become an Advanced Excel User”

From 4 hours to 1 minute filling in blanks in Excel

Every time I’m training staff from various corporates and I introduce this concept, the comments I get at the end is that ‘this is magic!‘ I normally inquire how the delegates deal with blanks in data. Some menial ways is to either (1)copy and paste, (2)autofill OR (3)use CTRL+D. All the methods work, the challenge is that people take 4 hours or more doing nothing productive. This posts addresses these inefficiencies. The data structure is as shown below:

Continue reading “From 4 hours to 1 minute filling in blanks in Excel”