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 - 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 – 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 - 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

  

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.

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 Power Pivot along with Excel to analyze data from a variety of sources.

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.

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.