X

Microsoft Excel

Microsoft Office Excel – Level I

Learn to create and edit basic Excel worksheets. This course is designed for students who desire to gain the necessary skills to create, edit, format and print basic Excel worksheets.

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

Course Cost: $310.00 + GST

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

Use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

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.