Advanced Excel for Data Processing

Many organizations nowadays require their staff to operate Microsoft Excel beyond its basics to help gain understanding or formulate strategies from datasets. This hands-on workshop introduces advanced features in Excel for effectively processing and analyzing data. Learning outcome includes:

- Perform data processing and analysis using advanced functions (TRIM, CONCATENATE, VLookup, HLookup, SumIFS, CountIFS…)
- View data using tables, filters, database and criteria
- Perform data automation using VBA programming