Excel Level 2 Training - Manitoba Customer Contact Association

Excel Level 2 Training

Date: Aug 13, 2019

Location: 1000 Waverley Street

Time: 8:30 am - 4:00 pm 

Members $99.00 per person

Non Members $149.00 per person


Who should attend?                                                    

This course is intended for participants who are familiar with Microsoft Excel 2016
Course Objectives

Upon completion of the course, participants will be able to accomplish the following:

  • Organize, protect, and display data using various tools.
  • Use the IF function, nesting functions, 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 and text boxes to annotate worksheets, and using sparklines to highlight and explain data.
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; Nesting Functions; Linking Formulas; Modifying and Restoring Links

Using Multiple Workbooks and 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

About the Instructor …

Claudette Craig is the owner of CD Consulting. She has more than 25 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.

Back to Calendar...