|
|
|
|
|
|
MEF ACADEMY
3A06-3A07, Block A,
Phileo Damansara II,
No. 15 Jalan 16/11, Seksyen 16,
46350 Petaling Jaya,
Selangor Darul Ehsan,
Malaysia
Tel: 603-7955 7778
Fax: 603-7955 1945
|
|
|
|
| | | | - 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
| | | | | | | | | | |
Scheme
| SBL |
Fee
| RM477 |
Duration
| 14 Hours |
Members Less
| - |
| |
|
|
|
|
|
|