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

Microsoft Excel: Intermediate

Course Objective

Microsoft Excel Intermediate course will equip you with hands-on knowledge to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

You will: -

  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.

Target Audience

This course is designed for students who already have foundational knowledge and skills in Microsoft Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Microsoft Excel to analyze and present data.

Training Methodologies

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

Trainer

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

Course Content

Lesson 1: Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Outline and Subtotal Data
  • Topic D: Consolidate Data

Lesson 2: Advanced Functions

  • Topic A: Work with Logical Functions
  • Topic B: Work with Date & Time Functions

Lesson 3: Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts

Course Duration

1 Day

Course Time

9am to 5pm

Course Fee

$185.00

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

Course Dates

5 Oct 2015
8 Nov 2018
10 Nov 2018 (Sat)
8 Dec 2018 (Sat)
11 Dec 2018