Microsoft Excel is one of the most widely used spreadsheet and data management programs in organisations today. An understanding of Excel can be a critical factor in being able to carry out a variety of responsibilities.
This course introduces Microsoft Excel users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables.
MS Excel is an important tool for data analysis. Many users had the impression that without using the Virtual Basic for Applicants (VBA), the data analysis cannot be worked. The statement above shall be proven inaccurate, as the data analysis job could still be done effectively and efficiently. It is important to possess the best skills in data collection before commencing data analysis jobs.