Office Productivity

Responsive Image

Programming with Excel 

Responsive Image

Report Generation with Excel 

Responsive Image

Foundations

Programming with Excel

With manpower shortage in most companies, individuals are constantly burdened with the ever increasing workload. These courses are designed to educate workers on how to ultilise features that are included in Microsoft Excel to automate various repetitive work tasks in the workplace.

Since most organisations already have Office365 licenses for their employees, increased competency in advanced Excel can cause major improvements with modest training investment.

Responsive Image
1 Day Course

The main purpose of the course is to give you the ability to add analysis capabilities to Excel spreadsheets and to provide you with a foundation to learn about more advanced data analytics with Excel or Power BI.

2 Day Course

Business Analytics with Qlik Sense, a scenario-based course, addresses the fundamentals required to enable you for self-service visualisation and discovery. The course combines demonstrations and hands-on exercises to teach the essential concepts for designing beautiful and effective Qlik Sense visualisations and guided stories.

Foundations

2 Day Course

This course is for users to familarise themselves with Microsoft Excel, do calculations by writing simple formulas and functions and manage multiple worksheets.

2 Day Course

This course is for users to learn how to format lists using advanced formatting commands, present data using Excel Charts and create summarise reports using Functions.

2 Day Course

This course is for users to use Microsoft Excel features for data analysis, extract data using Lookup functions and repeat task using Record Macros.