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. If you have not gone through the various approaches, follow these links:

Continue reading “Using Excel Macros to Combine Multiple Sheets”

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 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”