Introduction:

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.

What Will You Learn:

1. For Basic level, by the end of program, learner will be able to:

• get started with Excel 2016;
• explore the general environment of Excel 2016;
• perform simple calculation & formatting.

2. For Intermediate level, by the end of the program, learner will be able to:

• use the IF and VLOOKUP/HLOOKUP functions;
• manipulate information;
• apply sorting;
• filter data;
• apply charting elements;
• use Sparklines to show data trend.

Who Should Attend:

Learners who are new to Excel and need to know the Excel 2016 and learners who wants to create a report and perform calculation by using the Excel functions and features.

Prerequisite:

• Learners should have already known how to use Microsoft Windows and mouse & keyboard (for Basic level).
• Learners should have already known the Basic level of Microsoft Excel (for Intermediate level).