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”

What you need is BIG INSIGHTS!

You need an appealing, interactive dashboard that articulately gives you the insights you need to make a decision.

Its theĀ era of BIG DATA!. Organizations have access to volumes of data trickling from all angles. It goes without saying therefore that we should no longer be emphasizing on big data per se but rather seek BIG INSIGHTS from the data.

Continue reading “What you need is BIG INSIGHTS!”

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 articulately gives you the insights you need to make a decision.

Continue reading “Top Managers Love for Beautiful Things “Dashboards””