X

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.

Length: 1—day (8:30am – 4:00pm)

Course Cost: $310.00 + GST

Prerequisite: An introductory course to WIndows or a solid working knowledge of Windows

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.

Prerequisities: 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.

Length: 1—day (8:30am – 4:00pm)

Course Cost: $310.00 + GST

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.

Length: 1—day (8:30am – 4:00pm)

Course Cost: $310.00 + GST

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 - Formulas & Functions

Participants are at an intermediate level and have a working knowledge of developing basic functions in Excel. A strong interest to improve one’s understanding of formulas and to learn more complex functions.

Length: 1—day (8:30am – 4:00pm)

Course Cost: $290.00 + GST

Objectives:

  • Tips and tricks
  • How to type formulas in Excel
  • Introduction to Array formulas
  • Deciding which cell reference is needed when copying a formula
  • How to read and understand formulas; its simplicity and complexity
  • Creating and understanding functions

  

Microsoft Office Excel - PivotTables & Dashboards

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

Length: 1—day (8:30am – 4:00pm)

Course Cost: $310.00 + GST

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

  

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.

Register Online

Or

Download the Corporate Registration Form.

partnerships & accreditation

sign up for the SBC newsletter

If you are interested in our Full-Time programs please fill out the form below to join our Newsletter Mailing List.