Microsoft Excel Advanced Training

Course Dates:

25 & 26 Jan 2018
20 & 21 Feb 2018
19 & 20 Mar 2018
19 & 20 Apr 2018
14 & 15 May 2018

Course Specifications

Course length: 2 days (9.00am to 5.00pm)

Course Fees: S$285.00 (Group Discount of 10% for 3 or more participants)

Course Objective:

New and Advanced features of Excel 2010/2013/2016. Participant will get in-depth knowledge to manage, filter and generate reports from Excel database. You will gain knowledge to use advanced functions of Excel and hence increase productivity, augment data in spreadsheets using templates, charts, graphics, and formulas and be work efficient.

Target Audience

For those who have attended Microsoft Excel Basic course or for users with fair knowledge in Microsoft Excel.

Course Content

Custom & Conditional Formats

  • Create custom number format 
  • Apply Conditional Formatting 
  • Templates

Using Advanced Formulas & Functions

  • The Excel Date Function
  • Truncate Text Data in Excel with the LEFT Function
  • LEFT Function
  • RIGHT Function
  • Using Logical Functions
  • VLookup 
  • HLookup

Working with Range Names

  • Assign a Range Name
  • Edit a Range Name
  • Consolidating Data

Working or Managing Tables

  • Create a Table
  • Delete a table without losing the data or table formatting
  • Create a Data List in Excel
  • Removing the Duplicate Record

Data Sorting and Filtering

  • Perform a Quick Sort
  • Perform a Custom Sort
  • Filter Data
  • Creating a Custom AutoFilter
  • Advanced Filter

Fetch result from your data 

  • Create Subtotals
  • Using Automatic Outline
  • Grouping Data Manually
  • Data Validation Rule

Getting Master with Charts

  • Create a Chart
  • Change the Chart Type
  • Change the Chart Style
  • Change the Chart Location
  • Add Axis Titles
 Pivot Tables
  • Insert a Pivot Table
  • Change Summary Calculation
  • Two-dimensional Pivot Table
  • Updating a PivotTable Report
  • Change Data Source 
  • Moving PivotTable Report Fields
  • Using Expand and Collapse Buttons
  • Hiding PivotTable Report Items
  • Introducing Slicers
  • Formatting a Pivot Table Report
  • Formatting the values in the pivot table
 Sharing Workbook 
  • Shared a Workbook with other users
  • Tracking Changes
  • Accept/Reject Changes
  • Turn off change tracking for a Workbook
  • Resolve conflicting changes in a Shared Workbook
  • End the sharing of a Workbook
  • Stop sharing the Workbook
 Worksheet Protection
  • Protect a Worksheet
  • Protect a Workbook
  • Protecting Cell with a Password
  • Protect your Excel Files 
 Hands-on with Macros
  • Display the Developer Tab 
  • Record a macro
  • Changing Macro Security Setting
  • Creating a Macro Button
  • Assign a Macro
  • Running and Deleting a Macro 
  • Run a Existing Macro 

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list

Our Testimonials

During the Advanced Excel class, the trainer helped me to clarify my doubts especially the VLookup.
- Clarinda

A very engaging course that I really enjoyed. The tutor was very cheerful and helpful.
- Manisha

Good experience and thanks to the Trainer for her kind patient in teaching our company.
- Belle

Why choose us?

Hands-on Training Method
ACTA and Microsoft Certified Trainers
Small class size
Complete Course Material
Affordable Price
Certification of Completion
Central Location

Our Training Location

10 Anson Road
#31-12 International Plaza
Singapore 079903
(Tanjong Pagar MRT Station)

Call: +65 6673 4479


Privacy Policy