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.

  • Duration: 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.

  • Duration: 1 - day (8:30am – 4:00pm)
  • 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 - 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.

  • Duration: 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.

  • Duration: 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

  • Duration: 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.

  • Duration: 1 - day (8:30am – 4:00pm)
  • Course Cost: $310.00 + GST

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.