With manpower shortage in most companies, individuals are constantly burdened with the ever increasing workload. These courses are designed to educate workers on how to ultilise features that are included in Microsoft Excel to automate various repetitive work tasks in the workplace.
Since most organisations already have Office365 licenses for their employees, increased competency in advanced Excel can cause major improvements with modest training investment.
Preparing data is always the first thing to do when creating reports. Very often data are not given in the format you want, or not entered as you require. All this will require user to reformat or clean the data before it can be used. Microsoft Power Query allows you to quickly reformat and clean the data, preparing for use in Microsoft Pivot Table.
If your job requires you to manipulate millions of rows and work with multiple tables to create a single master list for data visualisation. And create calculated column and measures to enrich your dataset. Working with Power Pivot, it allows limitless possibility to create your visualisation.