Training & Events
Excel Level 2 Training
This course is intended for Microsoft Excel 2016/2019 users.
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, 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.
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 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;
Course Instructor: Claudette Craig
Claudette Craig is the owner of CD Consulting. She has more than 25 years of 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 online training videos.
Date:
September 29, 2021
Location:
1000 Waverley St, Winnipeg
Time:
8:30am to 4:00pm
Food:
Lunch and coffee provided
Member Pricing:
$100
Student Pricing :
$75 - please email info@biomb.ca for discount code
Non-member Pricing :
$200
COVID-19 Protocols
Required by attendees:
- Practice social distancing with 6 ft separation
- All training attendees are required to wear masks
- Upon entry into the building, hands must be sanitized before signing in
- When gathering food, attendees are instructed to go one at a time to allow for social distancing
- Frequent hand-washing
- If you are feeling ill, please do not attend and let BAM know as soon as possible