Need a new search?
If you didn't find what you were looking for, try a new search!
8 cool ways to identify and remove duplicates in Excel
When working with data in Excel, it is very likely you will encounter duplication. How do you deal with duplicates in Excel? Dealing with duplicates in Excel is 2-stage process –first identify if you have duplicates, and secondly remove the [...]
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 [...]
How to Consolidate Data from Multiple Worksheets in Excel
Do you have data in multiple worksheets that you wish to aggregate into a single sheet? Then this article is primarily written to address just that -how to consolidate data from multiple worksheets to a summary worksheets in Excel. [...]
Using Excel Macros to Combine Multiple Sheets
Using Excel macros to combine multiple sheets is one of the ways to greatly enhance productivity by automating and speeding up the process, especially where the number of worksheets are many. This article is part of the 3 approaches we’re exploring. If [...]
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 [...]
Top “X” Products in Excel Dashboards Free eBook
You've taken the first step! Congratulations and welcome aboard! You are now on your way to becoming splendid in creating Excel Dashboards and taking your analytics skills to the next level. As a subscriber, you’ll receive all kinds of helpful insider information from [...]
Top 5 Values in Excel eBook
Free E-Book 3 Ways to Show Top 5 Values in Excel Dashboards Learn how to interactively display top or bottom 5 items from a long list. Whether you want to show top 5 sales agents in a given period, or the bottom 10 [...]
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 [...]
4 steps: How to Create Waterfall Charts in Excel 2013
How to Create a Waterfall Chart in Excel 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 [...]