�� | Microsoft Office Excel Level 3

COURSE DETAILS

COST: $150 + HST

DURATION: FULL DAY

COURSE TYPE: SHORT COURSE

DELIVERY METHOD: IN-PERSON

LOCATION: CHARLOTTETOWN

START DATE: OCTOBER 30, 2024

AVAILABILITY: OPEN

CONTACT

To discuss your training needs, please send us an email or call: 902-566-9669.

Explore the functionality of Excel using several advanced features to analyze business data and to solve business problems from simple to complex. Develop the skills necessary to use one of Excel’s most powerful tools, Pivot Tables to quickly summarize and analyze data in many ways. Create scenarios using What-If Analysis to look at several different inputs and compare outputs. Learn how to integrate Excel with other Microsoft products to enhance workplace documents.

LEARNING OUTCOMES

After successfully completing the course, students will be able to:

Develop spreadsheets that use advanced workplace functions.
Use keyboard shortcuts for many different formatting commands.
Managing multiple spreadsheets and integrating data with other Microsoft products.
Organize, sort and Analyze data for specific purposes.
Format worksheets for advanced workplace requirements.
Summarize and analyze data in many ways using Pivot Tables.
Use relative, Absolute and Mixed referencing to create new and modify worksheets.
Create scenarios and troubleshoot data in spreadsheets.
Manage and validate data to answer questions.
Use What-If Analysis and other Scenarios to understand different inputs and compare outputs.