Training & Events
Excel Level 2 Training
Microsoft Excel Level 2 - July 15, 2020
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, 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 & 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: July 15, 2020
Location: 1000 Waverley St. Winnipeg
Time: 8:30 am to 4:00 pm
Member Pricing: $75.00
Non-Member Pricing: $125.00