Training & Events

Excel Level 2

Course Objectives

  • Organize, protect, and display data using various tools.
  • Use the IF function, create linking formulas, and manage links.
  • Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources.
  • Create and modify charts to present data effectively; customize charts to enhance their appearance.
  • Create, apply and modify styles to format worksheets consistently and quickly; use comments, text boxes to annotate worksheets, and sparklines to highlight and explain data.

If you are uncertain if you qualify for this training, please contact and we will provide you with an assessment.  

Course Content

  • Worksheet Organization -  Managing Range Names; Creating and Using Workbook Templates; Applying Worksheet Security; Creating and Using Outlines
  • Advanced Formulas - Using the IF Function; Linking Formulas; Modifying and Restoring Links
  • Using Multiple Workbooks & Worksheets - Working with Multiple Workbooks; Working with Multiple Worksheets; Consolidating Data
  • Working with Charts - Creating Charts; Changing Chart Data; Modifying Chart Elements; Creating Custom Charts
  • Applying Formatting - Working with Styles; Annotating Worksheets; Using Sparklines

Date: June 14, 2023

Location: 1000 Waverley | PC Lab   

Time: 8:30 am - 4:00 pm


Member: $100.00 plus gst |Non-Member: $200.00 plus gst

Course Instructor

Claudette Craig is the owner of CD Consulting. She has more than 2S years experience coordinating and facilitating courses, with a primary focus on the design and instruction of various Microsoft products. She has her Microsoft Office Specialist (MOS) certification at the Master Level. Her background includes working with a wide client-base in all business sectors, developing and implementing database applications and designing user reference materials and on-line training videos.


Excel 365 Level 2

  • $200.00 (Members pay $100.00)