Excel

Microsoft Excel is more than a popular spreadsheet program - it's a powerful data analysis and visualizaton tool. Learn everything from basic formulas to VBA macros and advanced statistical analysis techniques in our range of hands-on Excel classes.

Custom training is also available - email training@ualberta.ca for details.


Courses

Note: If no classes are visible when you click the "View Upcoming Classes" button, no sessions are scheduled at this time. Please contact training@ualberta.ca if you are interested in a particular course or require a specific date - we're happy to help!

Excel Level 1

This course is designed for new users. The course provides beginner concepts required to produce basic spreadsheets. Participants will learn how to create, save, open and close files, enter data, and complete basic edits using insert, delete, move and copy functions. This course presents simple formula creation concepts including the use of built-in functions. Relative formulas will also be covered. On completion of this course students will be familiar with formatting features such as: row heights, column width, alignment, merge cells and number styles. Participants will also work with margins, headers and footers to enhance page layout in different views to prepare for printing.

Course Details

Prerequisites:

  • Basic computer skills and knowledge of Windows

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Excel Level 2

This course is designed for users with a good understanding of Excel fundamentals. The course will provide more advanced concepts required to consolidate and navigate data across multiple worksheets and workbooks. Participants will work with built-in functions such as "if statements" "vlookup", "pmt", "dates", "stats". We will analyze and organize data using charts, some functions and security. Some advanced features covered include: creating templates, styles, conditional formatting and protecting your data.

Course Details

Prerequisites:

  • Excel Level 1 or equivalent knowledge/experience

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Excel Data List Management

This course provides an introduction to Excel features and functions by demonstrating how to add, edit, search for, and delete records in a data list using a form. Other topics covered include how to sort data in a data list, creating and working with text to columns, using various database functions to summarize data as well as creating and working with pivot tables and pivot charts.

Course Details

Prerequisites:

  • Excel Level 1 or a good working knowledge of Excel
  • Extensive knowledge of Excel, especially the use of named ranges

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Excel Spreadsheet Analysis

This course is designed for users of Excel who need to analyze spreadsheet data. Concepts covered include using goal seek, creating and managing what-if scenarios, and analysing spreadsheets using auditing concepts such as tracing, evaluating formulas and watch window.

Course Details

Prerequisites:

  • Excel Level 1 or a good working knowledge of Excel

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Excel VBA

Students will learn key concepts used to build custom solutions with Microsoft Excel VBA Macros. Topics covered in this class will help the participant become familiar with basic macro techniques for recording, writing, running, and maintaining a macro. Particular attention is paid to the design and layout of a user form and controls in order to create a customized dialog box to simplify data entry, as well as learning to enhance source code with variables, constants, and logical operators.

Course Details

Prerequisites:

  • Excel Level 2
  • Extensive knowledge of Excel, especially the use of named ranges

Duration: 2 days

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Statistical Analysis Using Excel

This course will introduce students to both descriptive and uni-variate inferential statistical procedures used commonly in social science research. The emphasis for this course, however, will be on the application of these procedures in the spreadsheet environment of Microsoft Excel. Three different aspects of statistical reasoning will be emphasized: (1.) computational formulas and assumptions, (2.) spreadsheet applications using Excel, and (3.) appropriate uses of these statistics. The topics we will cover include descriptive summary statistics, correlation, regression, t-tests, and analysis of variance (ANOVA).

Course Details

Prerequisites:

  • Excel Level 1 or a good working knowledge of Excel
  • Extensive knowledge of Excel, especially the use of named ranges

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes
Excel Dashboards

This course will introduce students to Dashboards in Excel. The emphasis is on applying tools and skills in Excel charting, Pivot Tables, interactive controls, and simple macros to build dashboards to automate tasks and create functional data visualization tools.

Course Details

Prerequisites:

  • Good understanding of Windows and Microsoft software
  • Intermediate Excel skills. Basic Knowledge of Pivot tables.

Duration: 2 days

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes

Excel PowerPivot

Learn how to use PowerPivot, a free Microsoft Excel add-on, to analyze large data sets in this new 1-day course! We will cover how to use PowerPivot to set up and analyze relationships using data from various sources, including Excel, Access, .csv and other text based formats, filtering using SQL Assistant, DAX (Data Analysis Expressions) functions and more.

Course Details

Prerequisites:

  • Good understanding of Windows and Microsoft software
  • Participants should have basic knowledge of pivot tables.
  • Intermediate Excel skills.

Duration: 1 day

Multiple course sections are open to registration. Click the link below to view all available dates.

Registering at least one week before the deadline is recommended as this class may fill up or be cancelled due to low enrolment.

View Upcoming Classes