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

Microsoft Excel: Intermediate

Course Dates:

8 Jun 2018
22 Jun 2018
12 Jul 2018
2 Aug 2018
11 Sep 2018

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.

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

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list