What's a Webinar?

Webinar Dates and Times for Oct - Dec 2009

Excel 2007 – Formulae and Functions
Apr 27, noon Eastern Standard Time	Jun 16, noon Eastern Standard Time
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. Learn how to use Excel’s fabulous math features to calculate payroll items, keep track of your spending, average students’ school marks, count the number of items in a list, etc.

Excel 2007– Great Graphing
May 5, noon Eastern Standard Time	Jul 6, noon Eastern Standard Time
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. Learn how to create very professional bar, column, line and pie charts to help your audience to see comparisons, patterns, and trends in data

Excel 2007- If Functions
Apr 29, 2 p.m. Eastern Standard Time	Jun 17, 2 p.m. Eastern Standard Time
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. Name Mark Comment M. Newman 75 Pass J. Alimar 48 Fail M. Rodman 81 Pass
Excel 2007 - Pivot Tables
May 17, 2 p.m. Eastern Standard Time		Jul 12, 2 p.m. Eastern Standard Time
Level: Intermediate – you should understand Excel’s  sum, average, max, min and count functions before registering for this webinar. A Pivot Table is 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: Student’s Name School Name Mark Gender From this data you can create a pivot table that summarizes your information in a variety of ways. A sample pivot table appears below.                 Average  Mark School Name           Gender Albany Beal Clarkson Grand Total     F 64 83 83 75     M 65 79 83 72     Grand Total 65 82 83 74                 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 2007- Scenario Manager
May 31, noon Eastern Standard Time	Jul 13, noon Eastern Standard Time
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 2007 - Vertical Lookups
May 3, 11 a.m. Eastern Standard time	Jun 28, 11 a.m. Eastern Standard time
Level: Intermediate – you should understand Excel’s  sum, average, max, min and count functions before registering for this webinar. Vertical lookup tables 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. Name Mark Comment M. Newman 75 Pass J. Alimar 48 Fail M. Rodman 81 Pass

Word 2007– Tabs and Indents
Oct 16, 10 a.m. Eastern Standard Time	Nov 20, 2 p.m. Eastern Standard Time
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  2007 - Styles and Tables of Contents
Nov 3, 10 a.m. Eastern Standard Time	Dec 18, 10 a.m. Eastern Standard Time
Level: Intermediate – you should understand tabs, indents and page numbering before registering for this webinar. When you're working with long documents and want to make your headings, subheadings, sub-subheadings, etc. look consistent throughout the document, Word's styles feature is a godsend.  Using styles in a document also helps you to create an automatic table of contents that you can update in the blink of an eye.

Word  2007- Headers and Footers
Oct 20, 2 p.m. Eastern Standard Time	Nov 13, 2 p.m. Eastern Standard Time
Level: Intermediate – you should understand tabs and indents before registering for this webinar. Learn the ins and outs of page numbering within headers and footers.  This webinar covers simple headers and footers as well as more complex ones that allow you to create documents where there are, for example, two pages ones or where a header or footer must start on an even or odd page.

Word 2007 - Mass Mailings

Nov 4, 2 p.m. Eastern Standard Time

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 2007 - Adding Sound and Video to a Presentation

Nov 9, 3 p.m. Eastern Standard Time

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 2007 – Animations and Transitions

Dec 11, 10 a.m. Eastern Standard Time

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 2007 - Working With Masters

Dec 15, 10 a.m. Eastern Standard time

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.