In this course, you will learn the practical techniques to manage/analyse your data efficiently and at ease. You will also learn to apply and optimize Excel’s powerful functions and formulas at work. This course will enable you to simplifying and automate repetitive tasks with Microsoft Excel Macro/VBA.
OBJECTIVES:
- Apply the best practices of data import options to Extract, Transfer, Import/Export data and text files from worksheet, files, software & other programs.
- Apply techniques in cleaning up large volume of data: remove and rearranging duplicate rows/columns, spaces, fixing time, date and numbers.
- Manage, organize and summarize data in a particular order based on your criteria with the Sort and Subtotal features.
- Select and filter the data to view and set criteria to extract data that you intend to analyse using the View, Auto Filter and Advanced Filter functions.
- Structure and Present data impressively using Excel Tables.
- Match and reconcile your data using the Vlookup/Xlookup Functions.
- Leverage on Excel critical formulas in enhancing work efficiency-If/Nested If, And/Or, Count/Counta, Countif, Sumif/Averageifs
- Learn the basics of Excel Macro
Prerequisite
Experience in using Microsoft Excel basic features or have completed the Microsoft Excel (Fundamental & Intermediate).