+65 6336 5482 (Weekdays, 9am - 6pm) 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.

1 Day Course

This course addresses the need of users of Microsoft Excel who find themselves repetitively performing certain tasks. And have desire to automate these tasks through recording using Excel Macros.

2 Day Course

This course is for Microsoft Excel user who need to work with workbooks and worksheets in their automation while using macros.

Reporting with Excel

Manual report creation in an office setting can be a mundane task as in most instances, the changes to the report by various stakeholders are mainly statistical and very minor. Thus, these courses are structured with the intent of educating workers on how to make report creation a more streamline process with the use of features in Microsoft Excel.

With Excel's data preparation and visualisation features, editing or creating reports can be done with just a click of an update button.

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.