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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
4 steps: How to Create Waterfall Charts in Excel 2013
How to Create a Waterfall Chart in Excel Safaricom, the most admired brand in [...]
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 [...]
From 4 hours to 1 minute filling in blanks in Excel
Save 99% of Time Spent Filling in Blanks in Excel Every time I’m training staff from various corporates [...]
What you need is BIG INSIGHTS!
You need an appealing, interactive dashboard that articulately gives you the insights you need to make a decision.
Top Managers Love for Beautiful Things “Dashboards”
If you are involved in management reporting, the statement above resonates with you. You need an appealing, interactive dashboard that [...]