Microsoft Excel Intermediate

CAD 335.00

Intensive, hands-on, one-day Excel Intermediate 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.

SKU: N/A Category:

Microsoft Excel Intermediate

2013/2016/2019/365

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 Intermediate course is designed for office users or those planning to work in an office. It is an intermediate course that covers mastering intermediate functions and formulas, charting, Data Listing, filtration and sorting and introduction to PivotTable reporting. Please refer to the detailed course outline below to learn what is covered in the course.

Prerequisites: Working experience with Microsoft Excel or skills learnt in our Excel Level-1 course. At least six months of experience working in Windows environment. Some keyboard skills also required.
Course Duration: One Day
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_Intermediate_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

  • Using the Range Names
  • 3D Formulas
  • Text Function: PROPER
  • Text Function: LOWER
  • Text Function: UPPER
  • Text Function: RIGHT
  • Text Function: LEFT
  • Function: CONCATENATE
  • Concatenation Operator “&”
  • Function: FIND
  • Function: TODAY
  • Function: IF
  • Function: IF (extra exercise)
  • Function: AND
  • Function: OR
  • Function: SUMIFS
  • Function: COUNTIFS
  • MATCH Function
  • VLOOKUP FUNCTION (Definition)
  • Function: VLOOKUP – FALSE
  • VLOOKUP-TRUE.xlsx
  • Functions: VLOOKUP and MATCH
  • Excel Table Feature
  • Filtering Excel Data
  • SUBTOTAL and Data Outlining
  • Creating Charts
  • PivotTable-A
  • PivotTable-B
  • PivotChart

Handy Keyboard Shortcuts

  • Covered with Above Exercises

 

 

Class Start Time

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

Course Date

14-Sep-2022, 12-Oct-2022, 08-Nov-2022, 07-Dec-2022, 04-Jan-2023, 01-Feb-2023, 01-Mar-2023, 29-Mar-2023, 26-Apr-2023, 24-May-2023, 21-Jun-2023, 19-Jul-2023, 16-Aug-2023, 13-Sep-2023, 11-Oct-2023, 08-Nov-2023, 06-Dec-2023, 27-Sep-2022, 26-Oct-2022, 01-Nov-2022, 23-Nov-2022, 21-Dec-2022, 18-Jan-2023, 15-Feb-2023, 15-Mar-2023, 12-Apr-2023, 10-May-2023, 07-Jun-2023, 05-Jul-2023, 02-Aug-2023, 30-Aug-2023, 27-Sep-2023, 25-Oct-2023, 22-Nov-2023, 20-Dec-2023