Microsoft Excel 2016 Training: Learn Advanced Excel Tips. Corporate Training Class in Singapore for Microsoft Office

Course Duration for Microsoft Excel 2016 Training : 2 days

SDF Funding is available to Singapore Companies (For company sponsored candidates).
Call +65 6250-3575 for Details.

SkillsFuture credits ready for Singaporeans.

“The Advanced Excel training will help me get my job done very quickly and easily. The things that I used to take many hours will now take only a few minutes with the use of formulas, macros and other tricks I learnt in the Excel 2016 workshop” – Carmen Leow, Pan Pacific Hotel, Singapore.

We also have Advanced Excel trainings on other versions of Microsoft Excel:

Advanced Excel 2016 Training in Singapore

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Course Outline

Course Objectives

Pre-Requisites

Target Audience

Course Objectives

Participants will learn how to use advanced excel functions of Excel® 2016 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.
Learn Pivot Tables, VLookups at Intellisoft

They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.

They will learn the use of VLOOKUP, PIVOT Tables in Excel 2016 to improve their productivity.

At Completion of the Advanced Excel 2016 Training:

After the successful completion of the Intermediate to Advanced Excel 2016 Training program, you will be able to:

calculate with advanced excel functions & formulas.
organize worksheet and table data using multiple techniques.
create and modify charts & graphs.
analyze data using excel Pivot Tables and Pivot Charts.
insert graphic objects.
customize and enhance workbooks and the Microsoft® Office Excel® 2016 environment.

You will know learn to deploy Advanced Excel 2016 techniques to increase productivity and improve efficiency by streamlining the workflow. Learn to:

collaborate with others using workbooks
audit worksheets
analyze data.
Work with multiple worksheets & workbooks
Import and export data in Excel

Go To Top

Target Audience

This program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more Advanced Functions of Excel 2016 to become more productive and make the most of Excel 2016.

The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data quickly, and easily with Microsoft Excel 2016 training.

In addition, the 2 day practical training on Excel is also great for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2016, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Go To Top

Course Outline

Lesson 1: Using Custom & Conditional Formats

Creating Your First Custom Format
Understanding the Date & Time Format Strings
Using Date & Time Custom Format
Understanding Conditional Formatting

Lesson 2: Using Range Names

Assigning Names to Groups of Cells
Managing Named Range
Using Names in Formulas

Lesson 3: Using Formulas & Functions in Excel

Understanding Formulas & Functions
Create a Relative & Absolute Reference
Working with Logic Functions
Working with Text Functions
Using More Text Function
Working with Lookup Functions
Understanding VLOOKUP() Function
Understanding HLOOKUP() Function
Challenge 03: Using Formulas & Functions

Lesson 4: Managing, Sorting & Filtering Tables

Create and Modify Tables
Sorting and Filtering Data in a Table
Build an Advanced Filter
Getting Summary Information in a Table
Calculate Total Row in a Table
Display Special Formatting for First or Last Column
Summing with Subtotals & Grand Totals
Validating Data During Entry
Working with Database Functions
Challenge 04: Organizing Worksheet & Table Data

Lesson 5: Working with Charts

Summarizing Data Visually Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Changing the Chart Body
Saving the Chart as a Template
Creating a Pie Chart
Creating Combination Charts
Challenge 05: Working with Chart

Lesson 6:Working with Pivot Tables

What is a Pivot Table
Anatomy of a Pivot Table
How does a Pivot Table Works
Create a Basic Pivot Table Report
Rearranging a Pivot Table Report
Customizing a Pivot Table
Changing Summary Calculations
Adding and Removing Subtotals
Sorting in a Pivot Table
Filtering in a Pivot Table
Filtering Using the Report Filter Area
Challenge 06: Working with Pivot Table

Lesson 7: Working with Shared Workbooks

Working in a Group Environment
Commenting in Cells
Tracking Changes in Workbooks
Turn on Track Changes
Accepting or Rejecting Changes
Review Changes
Keeping a Backup of your Changes
Create a Change History

Lesson 8: Working with Multiple Workbooks

Linking to Other Workbook
Create a Link to Other Workbooks
Consolidating Multiple Sets of Data
Consolidate Multiple Worksheets

Lesson 9: Protecting Your Worksheet & Workbook

Protecting Your Worksheet
Protect a Worksheet
Unprotect a Worksheet
Allowing Access to Parts of a Worksheet – I
Allowing Access to Parts of a Worksheet – II
Protecting Your Formulas
Protecting Your Workbook
Save Your Workbook with Password
Encrypting your Workbook

Lesson 10: Working with Excel Macros

Recording & Testing a Macro
Using the Developer Tab
Create a Macro
Relative and Absolute Recording
Testing the Macro
Running and Deleting Macros
Using the Macro dialog box
Using a Shortcut key
Placing a Macro on the Quick Access Toolbar
Delete a Macro
Saving a Workbook with a Macro
Saving a Macro to the XLSM Workbook
Saving a Macro to the Personal Macro Workbook
Macro Security
Creating Practical Macros
Inserting a Header

Go To Top

Pre-Requisites

Go To Top

How To Register

To Register for Microsoft Excel 2016 Training, Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call at at +65 6250-3575
or email to training@intellisoft.com.sg for any questions.or to register for the upcoming class of Advanced Excel 2016.

We also offer Corporate Trainings for Advanced Excel 2016 version, as well as customized trainings on Microsoft Excel 2013 and Excel 2010.

If you have a group of people in your company or department who are interested to learn the more advanced techniques in Microsoft Excel, we can arrange to conduct the Advanced Excel 2016 training at your office location too. Just call or email us for a quotation and details.