Past Events › Information Technology (IT)

The Intermediate program aims to give the new spreadsheet user a thorough grounding in the Intermediate level of creating and working with spreadsheets using Microsoft Excel 2013. Learners will be guided for the commonly used functions and formulas in Excel 2013. While the Advanced program is designed for those with intermediate knowledge of Excel who wish to progress to the most complicated functions and features in Excel 2013.

This program is designed for advanced Microsoft Excel users who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation. They will have a need to create PivotTables on a regular basis and to produce reports with multiple PivotTables/PivotCharts to produce 'Business Intelligent' type dashboard reports.

This two days course covers the fundamental skill and knowledge to create Excel Macros. It provides the skills and knowledge required to fully exploit the features and capabilities of Excel Macros. During in-class hands-on exercise, you will be able to enhance your Excel Macro program using the programming skills in VBA.

The Basic program aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. While the Intermediate program is designed for those with basic knowledge of Excel who wish to progress to the most complicated functions and features in Excel 2016.

The Advanced program is designed for those with intermediate knowledge of Excel who wish to progress to the most complicated functions and features in Excel 2016.

This two days course covers the fundamental skill and knowledge to create Excel Macros. It provides the skills and knowledge required to fully exploit the features and capabilities of Excel Macros. During in-class hands-on exercise, you will be able to enhance your Excel Macro program using the programming skills in VBA.

PivotTables and PivotCharts are some of the Excel's most powerful features for analyzing data. This program takes PivotTables to the next level, teaching you how to use Power Pivot: a free add-in available only for Microsoft Excel 2010/2013/2016. Power Pivot links in with PivotTables, however the data used, can be manipulated and managed as though you were using a Relational Database (such as SQL or Access).

Power Query is the FREE Excel add-in from Microsoft that will help transform and manipulate your data into a format that is ready for PivotTables, reports, and so much more.

PivotTable and the VLOOKUP Function is the most popular and powerful feature in Microsoft Excel. PivotTable summarizes and analyses large amount of data; while VLOOKUP helps you to search and retrieve relevant information for your reporting. This course explores deeper into the usage of PivotTable and using VLOOKUP to obtain various complicated information.