Microsoft Excel

Microsoft Office Excel – Level I

Learn to create and edit basic Excel worksheets. This course is intended for participants who want to get up to speed with Microsoft Excel and gain a strong foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. It is recommended that participants review the course outline.

Objectives:

Create a basic worksheet by using Excel.
Perform calculations in an Excel worksheet.
Modify an Excel worksheet.
Modify the appearance of data within a worksheet.
Manage Excel workbooks.
Print the content of an Excel worksheet.

Microsoft Office Excel – Level II

This course is designed for students who already have a foundational knowledge and skills in Excel, who wish to begin taking advantage of some higher-level functionality in Excel to analyze and present data. It is recommended that participants review the course outline.

Duration: 1 - day (8:30am – 4:30pm) - Check calendar for availability.
Course Cost: $310.00 + GST
Prerequisites: Participants should have a basic working knowledge of formulas and functions, as well as being comfortable with the use of shortcuts, and is aware of the difference between a relative and an absolute reference.

Objectives:

Work with functions and learn formula auditing
Protect workbooks and create a template
Work with lists
Analyze data
Visualize data with charts

Microsoft Office Excel – Level III

Automate some common Excel tasks, apply advanced analysis techniques to more complex data set, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Objectives:

Work with multiple worksheels and workbooks
Use Lookup functions
Automate workbook functionality
Forecast data
Introduction to Pivot Tables and Pivot Charts

Microsoft Office Excel - PivotTables & Dashboards

Participants are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables

Objectives:

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will:

Prepare data for PivotTable reporting and create PivotTables from various data sources
Analyze data by using PivotTables
Work with PivotCharts
Design a Dashboard

Microsoft Office Excel - Data Analysis with Power Pivot

Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

Objectives:

You will:

Get Started with Power Pivot
Visualize Power Pivot data
Work with advanced functionality in Power Pivot

Ready to Register?

If you are ready to register you may do so online by clicking the link the below, downloading the PDF application, or calling 306-244-6340.

Corporate Training

Microsoft Excel

Microsoft Office Excel – Level I

Objectives:

Microsoft Office Excel – Level II

Objectives:

Microsoft Office Excel – Level III

Objectives:

Microsoft Office Excel - PivotTables & Dashboards

Objectives:

Microsoft Office Excel - Data Analysis with Power Pivot

Objectives:

Ready to Register?

Fill out this form to contact us

Fill out this form to contact us

Sign up for the sbc newsletter