One-Hour Webinars

What's a Webinar?

A webinar is an on-line seminar.  To participate in a webinar, you log on to a particular web site from your own computer. You will then be able to hear our instructor and see his/her computer screen.

Our webinars are like instructor-led classes where an instructor projects from a LCD panel.  Instead of projecting from a LCD panel, the instructor projects from her computer screen to yours. You'll see the instructor's screen and hear her instructions without leaving your desk.

Excel - Formulae and Functions

noon (Eastern Time) - Fourth Monday of Each Month

Level: Introductory – you should understand how to enter data into cells, how to change column width and how to save and open a spreadsheet before registering for this webinar.

Excel - If Functions

noon (Eastern Time) - Second Tuesday of Each Month

Level: Intermediate – you should understand Excel’s sum, average, max and min functions before registering for this webinar.

Excel's IF function enters text or a value in a particular cell depending on the contents of another cell. A very basic example is shown below.  For each row, Excel automatically adds a comment in the Comment cell depending on the mark in the Mark cell -- it adds the word Pass when the mark is greater than or equal to 50 and adds the word Fail when the mark is below 50. This webinar covers basic as well as very sophisticated IF functions.

Excel - PivotTables

3:30 p.m. (Eastern Time) - Third Monday of Each Month

Level: Intermediate – you should understand Excel’s  sum, average, max, min and count functions before registering for this webinar.

A Pivot Tableis a special kind of table that summarizes information from particular fields of a list or database. Assume you have a very large list of students. The list has the following column headings:

 From this data you can create a pivot table that summarizes your information in a variety of ways. A sample pivot table appears below.

This pivot table tells you the average mark for girls at Albany School is 64, while it is 83 for both Beal and Clarkson schools. This pivot table would alert you to the fact that Albany's marks for both boys and girls are much lower than the other two schools and, if you were the Superintendent of Schools, you would realize you need to investigate the cause of the low marks.

Excel - Scenario Manager

2 p.m. (Eastern Time) - Second Tuesday of Each Month

Level: Intermediate – you should be very comfortable with Excel formulae (e.g. =a4*d7) and the sum, average, max and min functions before registering for this webinar.

Excel's Scenario Manager allows you to compare several different scenarios.  You could, for instance, determine your profits under a best case scenario, most likely scenario, and worst case scenario.

Excel - Vertical Lookups

2 p.m. (Eastern Time) - Fourth Monday of Each Month

Level: Intermediate – you should understand Excel’s sum, average, max, min and count functions before registering for this webinar.

Vertical lookuptables are a popular alternative to using If functions. They enter text or values in an answer cell depending on the contents of other cells.  In the example below, Excel enters a comment in the rightmost column depending on the mark in the middle column.

Word - Tabs and indents

10 a.m. (Eastern Time) - First Friday of Each Month

Level: Introductory – you should have basic knowledge of word (saving, opening files, formatting text, how the Show-Hide button works).

If you're frustrated with trying to line up columns of numbers by spacing across the page, this is the webinar for you.  We'll cover all kinds of tabs that can make your life easier -- left, right, decimal and centre tabs -- as well as tabs with leaders.  Indenting will help you to create consistent looking indented paragraphs.

Word - Mass Mailings

2 p.m.. (Eastern Time) - First Friday of Each Month

Level: Intermediate – you should have a good grasp of Word’s basic features (saving, opening, formatting text) before registering for this webinar.

Want to send letters to dozens or hundreds of people quickly and easily?  This webinar covers creating mail merges for letters, envelopes, labels and more.

PowerPoint - Adding Sound and Video to a Presentation

2 p.m.. (Eastern Time) - First Friday of Each Month

Level: Intermediate – you should understand how to add clip art to a slide and how to make basic slides (bullet, pie, etc.) before registering for this webinar.

Liven up your presentations using sound from a CD or from MIDI, WAV and RMI files you have downloaded from the web. As well, learn how you can record your own voice on PowerPoint slides.

Add video from your video camera or from files you have saved to your computer

PowerPoint - Animations and Transitions

noon (Eastern Time) - Fourth Friday of Each Month

 Level: Intermediate – you should understand how to add clip art to a slide and how to make basic slides (bullet, pie, etc.) before registering for this webinar.

Learn how to add motion to clip art as well as to bullets and graphs as they enter a presentation.  Liven up your presentations with special effects that occur as slides appear or leave the screen.

PowerPoint - Working with Masters

2 p.m. (Eastern Time) - Fourth Wednesday of Each Month

 Level: Intermediate – you should understand how to add clip art to a slide and how to make basic slides (bullet, pie, etc.) before registering for this webinar.

PowerPoint ships with several different masters which control the appearance of your slides, notes and audience handouts. Assume you need to add a logo and change the background colour and font style on all of your slides.  Instead of making these changes individually on each slide, you change the master and it, in turn, changes all of the slides in your show. This is a great timesaver and ensures your slide show has a consistent look.