In this course, you will learn the practical techniques to manage/analyze 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
simplify and automate repetitive tasks with Microsoft Excel Macro/VBA.
OBJECTIVE:
- 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 analyze 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