Leveraging Functions and Formulas using MS Excel
Download PDF Outline ————————————- Course Objectives At the end of the course, participants will be able to use Excel Functions and Formulas more effectively. Target Audience This course is suitable for participants who need to utilise the various pre-set functions in Microsoft Excel to create formulas and perform calculations. Course Outline Using SUM, AVERAGE, MAX, […]
Reporting with Pivot Table and Pivot Chart
Download PDF Outline ————————————- Course Objectives At the end of the course, participants will be able to use Excel to transform transactional data into summary reports. Target Audience This course is intended for participants who need to master the various commands available in Microsoft Excel’s PivotTable and PivotChart in order to summarise, analyse and create […]
Visual Basic Application for Excel 2016
Download PDF Outline ————————————- Successful learners of Visual Basic Application (VBA) for Excel 2016 Course are able to use Visual Basic functions like Macros to convert tedious manual tasks into one click of a button to increase spreadsheet productivity, and to use Userforms for user interactive interfaces. VBA Excel 2016 Course Target Audience Those […]