Microsoft Excel Advanced

CAD 350.00

Intensive, hands-on, one-day Excel Advanced course delivered online by a Live Trainer and not recorded Videos. Please read prerequisites and other details in the description below.

We have distinct course dates for Pacific and Eastern Time zones. You can explore both options below.

Microsoft Excel Advanced

Microsoft Excel is a spreadsheet application used all over the world in commercial and industrial applications where numbers are involved. This could include analysis, payroll, inventory, finance, accounting, charting, data listing and complex calculations of any kind.

Our Excel Advanced course is designed for office users or those planning to work in an office. It is an advanced course that prepares you to work with data validation, macros, formula auditing, conditional formatting and tools related to data analysis. Please refer to the detailed course outline below to learn what is covered in the course.

Prerequisites: Substantial working experience with Microsoft Excel or skills learnt in our Excel Level-1 and 2 courses. At least six months of experience working in Windows environment with mouse. Some keyboard skills also required.
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person option is available for group training only)
Course Outline Download: Excel_Advanced_Level
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Course Outline

Excel Features Covered with Hands-on Exercises

  • Advanced File Properties
  • Data Validation
  • Macros-Using Absolute References
  • Macros-Using Relative References
  • Macros-Nesting
  • Macros-Editing
  • Customizing Excel
  • Conditional Formatting
  • Advanced Conditional Formatting-Function AND
  • Advanced Conditional Formatting-Function MOD
  • Range Protection
  • Worksheet Protection
  • Workbook Protection
  • Remove Duplicates
  • Tracing Cells
  • Error Checking Tool
  • Using Watch Window
  • Evaluating Formula
  • Charts: Adding a Trendline
  • Charts: Creating a Dual Axis Chart
  • Using Goal Seek
  • Using Scenario Manager
  • Quick Analysis- Sparklines
  • Consolidating Data
  • Linking Workbooks
  • Importing Text Data into Excel
  • Excel Custom Formats

Handy Keyboard Shortcuts

  • Covered with Above Exercises


Class Start Time

9:00 AM Pacific Time, 9:00 AM Eastern Time

Course Date

05-Jan-2024, 01-Mar-2024, 26-Apr-2024, 21-Jun-2024, 16-Aug-2024, 11-Oct-2024, 06-Dec-2024, S, 19-Jan-2024, 15-Mar-2024, 10-May-2024, 05-Jul-2024, 30-Aug-2024, 25-Oct-2024, 20-Dec-2024