As Singapore goes into Post Circuit Breaker Phase Two, NTUC LHUB will be adhering to Safe Management Measures and guidelines recommended by MOH, MOE and SSG to ensure the safety of our trainees and staff. Click to read more.
+65 6336 5482 (LHUB) 8.30am to 5.30pm (Weekdays), 8.30am to 10am (Weekends) Learners Login

Office Productivity

Information Technology

Office Productivity
Excel Unleashed

Programming with Excel

Report Generation with Excel

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.

Preparing data is always the first thing to do when creating reports. Very often data are not given in the format you want, or not entered as you require. All this will require user to reformat or clean the data before it can be used. Microsoft Power Query allows you to quickly reformat and clean the data, preparing for use in Microsoft Pivot Table.

3 Day Course

If your job requires you to manipulate millions of rows and work with multiple tables to create a single master list for data visualisation. And create calculated column and measures to enrich your dataset. Working with Power Pivot, it allows limitless possibility to create your visualisation.

1 Day Course

This course teaches learners to create interactive dashboard using formulas and functions, without the need of user having the knowledge of Microsoft PivotTable.

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.

an NTUC Social Enterprise
© COPYRIGHT 2019 NTUC LearningHub. All Rights Reserved.