Information & Communication Technology Microsoft Excel (Advanced) – Manipulating Data Effectively   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 Functions. Leverage on Excel critical formulas in enhancing work efficiency-If/Nested If, And/Or, Count/Counta, Countif, Sumif/Average Ifs Learn the basics of Excel Macro   Topics Covered   Target Audience   Methodology   Scheme SBL Fee RM477 Duration 14 Hours Members Less -