Training & Events

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 maryam@biomb.ca 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

Pricing

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.