VTeach Training Partner
Your Training Partner
Follow Us:
Contact VTeach Training
Register for Training

Microsoft Excel: Intermediate

Course Objective

Upon successful completion of this course, you will be able to calculate Data with Advanced Formulas and Functions and develop Excel workbooks in order to work with and analyze the data. You will also be able to leverage the power of data analysis and presentation using charts.

Target Audience

This course is intended for students who wish to gain the intermediate understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.

Training Methodologies

  • Training is hands-on using easy-to-follow step-by-stepinstructions.
  • Instructor-Led Training (ILT) on live exercises of each topic.


Training will be conducted by our experienced local trainer who has more than 10 years of experience with relevant certification.

Course Content

Managing a Workbook

  • Inserting Header and Footer
  • Freeze, split options
  • Arrange the windows
  • Using Sorting, Custom AutoFill Lists

Printing Workbooks

  • Printing Workbook
  • Set Page break
  • Print Area

Calculating Data with Advanced Formulas

  • Using Range Names
  • Creating & Define Range Names
  • Using Range Names in Formulas
  • Consolidating data
  • Using Text and Date Functions
  • Using Logical Functions
  • Using the Vlookup and HlookupFunctions

Organizing Worksheet and Table Data

  • Format Tables
  • Modify Tables
  • Create a Data List in Excel
  • Learn more about filtering
  • Common filter
  • Clear a filter

Presenting Data Using Charts

  • Types of Charts
  • Creating Charts and Modifying Charts

Course Duration

1 Day

Course Time

9am to 5pm

Course Fee


(Group Discount of 10% for 3 or more participants)

Course Dates

25 Sep 2018
2 Oct 2018
13 Oct 2018 (Sat)
8 Nov 2018
10 Nov 2018 (Sat)