Excel is one of the most widely used tools – known for its ability to crunch numbers. Excel is also very powerful in its ability to manage large amounts of text and numerical data with ease. Keep lists of information, subtotal groups of numbers, pivot data for analysis and decision-making, chart information to illustrate your data.

Most users have a basic understanding of the software. With a few simple tips and tricks you can use Excel with more efficiency and power. Learn about the hidden strategies that will save you lots of time, ensure consistency and also ensure that your numbers and calculations are correct.

Correct calculations and the ability to represent the data – powerful reasons to use Excel!

Upcoming Sessions

(Descriptions below)

Excel Basics
Wed, 15 February 2017 - 4:00 PM – 6:00 PM EST

Excel Formulas 1
Tue, 21 February 2017 - 2:00 PM – 4:00 PM EST


Excel Quick Start

If you have never touched Excel before and always had an itch to learn, this is a great place to start. This session breaks down all the basic components of Excel and helps the user navigate through the program without getting stressed or overwhelmed.


Excel Basics

Whether you are new to Excel or have used it only a few times, this course provides the basic information you need to create spreadsheets.  You will be provided with a guided, hands-on tour through the basic features and will be introduced to the many tips and tricks (as well as some pitfalls!) along the way.


Next Level Excel Skills - Tips & Tricks

This session is for those who are familiar with Excel. Take the opportunity to ensure that you really know the key features and use them effectively. Many users are not aware of the hidden pitfall of issues such as incorrect rounding of answers; the ability to format cells to highlight data that requires attention; text rotation that enables additional formatting options; print multiple pages with column titles repeated on each page, and so many more tips and tricks.

Prerequisite: You should be fairly comfortable with most basic features of Excel. If you are fairly new to Excel, you should consider the Excel Basics course first.


Excel Formulas 1

Go beyond the basic sums. Learn how to create more complex formulas. What is the difference between relative and absolute cell references? Why do my numbers not add up? Why is it telling me I have a circular reference? We will dive into some built-in formulas such as average, round, date, time, len, and more.

Prerequisite: You should be fairly comfortable with most basic features of Excel. If you are fairly new to Excel, you should consider the 1.5 hour Excel Basics course first.


Excel Formulas 2

A continuation from Excel Formulas 1. More complex IF statements, date and time functions, text functions and more. Also, a look at how to combine functions. Formulas linking data from multiple worksheets will be included but are covered in-depth in the Excel Managing Worksheets session.

Prerequisite: You should be familiar with the basics of creating formulas. If you are fairly new to formulas, you should take the Formulas 1 course first.


Excel Database, Filtering, and Subtotals

Learn how to set up and use flat databases in Excel. Keep simple lists of data. Use them for tracking information, merging into letters and other documents (more in Word merging), and filter data to see subsets of your complete data. The subtotal function adds the ability to analyze your data and generate totals.

Prerequisite: You should be familiar with the basics of creating formulas. If you are fairly new to formulas, you should take the Formulas 1 course first.


Excel Formula Lookups & Database Functions

Learn the Excel lookup functions such as VLOOKUP and INDEX. These functions enable you to extract a value from a range of values based on a column and/or row reference. Database functions allow you to set up a set of criteria and extract a calculated value from a set of data based on the criteria.

Prerequisite: You should be familiar with the basics of creating formulas. If you are fairly new to formulas, you should take the Formulas 1 course first.


Excel Printing, Headers, & Footers

Stop printing those useless blank pages from Excel. Take control of your print jobs. Learn how to set your print area, print titles, headers and footers, pages numbers, page breaks, and more. Excel offers so many features related to printing!

Prerequisite: You should be fairly comfortable with most basic features of Excel. If you are fairly new to Excel, you should consider the 1.5 hour Excel Basics course first.


Excel Linking Worksheets & Files

Add up formulas across worksheets and across files. Bring data together from multiple sources. What happens if you change the original file? Learn how to manage these multiple sets of data.

Prerequisite: You should be fairly comfortable with most basic features of Excel. If you are fairly new to Excel, you should consider the 1.5 hour Excel Basics course first.


Excel Pivot Tables

Pivot tables and charts offer a variety of ways to slice up data and present it for analysis. Learn how to use this powerful feature of Excel.

Prerequisite: You should be familiar with the basics of creating formulas. If you are fairly new to formulas, you should take the Formulas 1 course first.


Excel Charts

Learn about the different charts available. Insert and edit the charts. Learn about the features such as legends, scaling, bar colours, data charts, etc.

Prerequisite: You should be fairly comfortable with most basic features of Excel. If you are fairly new to Excel, you should consider the 1.5 hour Excel Basics course first.


Make Excel Communicate

There are many features in Excel that you can use to make Excel communicate information to your viewers. From simple formatting options to complex conditional formatting statements, make those numbers more interesting and clear.

Prerequisite: You should be fairly comfortable with most basic features of Excel. If you are fairly new to Excel, you should consider the 1.5 hour Excel Basics course first.