Excel Levels 2 and 3

Non-member Price: $350.00

Member Price: 300.00
Enter the "Member Code" at checkout to apply the discount.

Excel Level 2 (September 12)
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.

Excel Level 3 (September 19)
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
• Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data.
• Sort records in a data list using a variety of methods.
• Filter data in a list using a variety of methods, as well as work with filtered data.
• Create and work with subtotalled lists, as well as use various database functions to summarize data.
• Create, modify, and work with PivotTables, PivotCharts, and Slicers.
• Import external data from a variety of sources into Excel.

Date: September 12, 2019 - September 19, 2019

Time: 8:30 AM - 4:30 PM

Location: 1000 Waverley Street Winnipeg, Manitoba

Contact: Barry for the Member Code.

Category:

Reviews

There are no reviews yet.

Be the first to review “Excel Levels 2 and 3”

Your email address will not be published. Required fields are marked *