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 you probably have toknow some Excel formulas or functions to get this done efficiently. If not, goodluck to your copying and pasting. 2. Analysis Once you have gotten the data in the right format,…

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 courses solve their problem by showing them solution that they could take and implement immediately after completing the course. Most of them love us and we are glad that they did. At the beginning of this year, we started review our courses, the feedback, the objectives of what…