Homepage 1

I don't know what I don't know (about Excel)

You have no problem preparing the reports every month. But every time you see somebody use a short cut, you feel that you don't know enough Excel yet. You find learning Basic, Intermediate and Advanced Level Excel courses is not going to help. There are too much to learn and probably wouldn't be using most of the worksheet functions and features most of the time. Yet you hope you can be better in Excel so that you can prepare those monthly reports faster and easier.

If that is what you are thinking, I have good news for you. I used to be like you. I bit the bullet and read as many Excel books from cover to cover, and watch as many Excel videos as I could. There were a lot of repetitions and after learning something new, I need to find out where can I use it. I took me years to master the functions and it is a never ending journey. I am still learning now. But not everything I learnt could be put to use. That I found out the hard way. Having going through this journey, I don't want you to go through the same journey as me and spent years on it. But you still need Excel and you can't just abandon it. It is such an important app that help you analyze all the data that is given to you. That's when I decided to design an Excel course that you can learn all the essential functions for business analysis in just 2 days. 

After attending the course, all you have to do is to apply and apply and you will become an expert in Business Analysis in Excel. You no longer have to spend hours working on that set of raw data that you downloaded from the system. With just a few clicks, the report will be ready for you to analyze and cut down on unnecessary overtime.

Latest from the Blog

Pivot Table with Percentage of Sales

I was reviewing the video recording of our course "Grow Your Profit Through Data Analytics and Data Modelling" and this feature was highlighted. Do you know that you can present the Monthly Sales and % of Sales side by side as you see in the picture?Not many people know of this function. If you know, that's good. If you don't, you can learn about it in our course "Grow Your Pro [...]

Continue reading

The Primary Purpose of Data Visualization

Data Visualization is not about seeing the numbers. It is about seeing patterns.I have seen many organizations clutter their chart with numbers and missed the pattern altogether.In the charts taken from a utility bill, it only showed the consumption over the months and the average against neighbours as well as the national average. That's what data visualization is designed to [...]

Continue reading

One Step to Data Analytics from Excel

Do you see the white dotted lines on the road?  Just like this road that is separated by the dotted line, Excel and Data Analytics are also separated by a thin dotted line. If you have been extracting data, filtering data, copying and pasting data in Excel, you can easily step across to the other side of the road and take the data analytics path. Both share the same skills [...]

Continue reading

Arrow or Dart?

The target was at a distance, about 100m away. She held up the bow, place the arrow on the bow, pulled the arrow against the string and took aim. The arrow flew out of the bow and she let go and hit the target at the bullseye. The bow is like the control key on your keyboard. The arrow key is the arrow. If you just simply press the arrow key, you can only move to the next [...]

Continue reading

Most Popular Posts

Pivot Table with Percentage of Sales

I was reviewing the video recording of our course "Grow Your Profit Through Data Analytics and Data Modelling" and this feature was highlighted. Do you know that you can present the Monthly Sales and % of Sales side by side as you see in the picture?Not many people know of this function. If you know, that's good. If you don't, you can learn about it in our course "Grow Your Pro [...]

Continue reading

We are changing our focus

We have always positioned ourselves as an Excel course provider, although we do not offer basic, intermediate and advanced Excel courses. Business professionals like our courses because we showed them shortcuts and how to save time working with Excel. They learnt how to use a Pivot Table, VLOOKUP and charting.It is always our aim to help business professionals who attend our co [...]

Continue reading

3 skills you need to Excel in Reporting

1. Data source Not all the data comes nicely in an Excel worksheet. Some come in csv format, text or linked to some data sources. If you are lucky and there is IT support, you can get the IT guys to organize the data nicely for you. If not, there is a bit of moving around to get the data in the right layout. Splitting and grouping of the data is usually done within Excel and yo [...]

Continue reading

3 tell-tale signs that your date is stored wrongly

1. You have one worksheet for one year of data.Your data for all the different years should be stored in one worksheet. If you break them into multiple worksheets, you are storing your data wrongly. What is the implication when you store them in multiple worksheets? You cannot analyze your data across different years and you will find them you are spending hours trying to com [...]

Continue reading

Don't Forget...

As a subscriber, you never miss a post AND you get access to my exclusive free guide/weekly content/add whatever benefits you offer to your subscribers. Sign up today and join over 20,000 happy subscribers!

There are some problems with the configuration of the opt-in shortcode
>