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

Microsoft Excel: Advanced

Course Duration

2 Days

Course Time

9am to 5pm

Course Fee

$285.00

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

Course Dates

20 - 21 Aug 2018
30 - 31 Aug 2018
17 - 18 Sep 2018
18 & 19 Oct 2018
22 & 23 Nov 2018

Course Objective:

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

Target Audience

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

Training Methodologies

  • Training is hands-on using easy-to-follow step-by-step instructions.
  • 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: Conditional Formats and Templates

  • Apply Conditional Formatting
  • Templates

Lesson 2: Advanced Formulas, Functions and Conditional Formatting

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

Lesson 3: Working with Range Names

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

Lesson 4: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Perform a Quick Sort
  • Custom Sort
  • Filter Data Apply Multiple Filters Advanced Filtering
  • Custom AutoFilter
  • Groups and Subtotals

Lesson 5: Visualizing Data with Charts

  • Types of Charts
  • Create a Chart
  • Chart Layout and Style
  • Create Sparklines Modify Sparklines

Lesson 6: Using Automated Analysis Tools

  • Use the Goal Seek Feature
  • Other Types of What-If Analysis

Lesson 7: Sharing and Collaborate Workbooks

  • Sharing Workbook
  • Understanding Track Changes
  • To Turn on Track Changes
  • Accept/Reject Changes
  • Turning off Track Changes
  • Add, Edit and Hide Comments Delete a Comment

Lesson 8: Protecting Workbooks

  • Document Inspector
  • Protect a Cell
  • Protect Workbook

Lesson 9: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Pivoting Data
  • To Add Filters
  • To Add Slicers PivotCharts

Lesson 10: Recording and Using Macro

  • Display the Developer Tab
  • Macro Security Setting
  • Record Macros
  • Edit Macros
  • Run Macros
  • Placing a Macro on the Quick Access Toolbar
  • A Quick Introduction to VBA Programming in Excel

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list