An intermediate/advanced tutorial on Excel 2007 for Windows. We covered these topics:

• Merging Data
• Paste Special
• Formulas, Including IF and VLOOKUP
• Creating a Chart
• Creating a Pivot table
• Using Named Ranges

This is a helpful site that gives more insight into the VLOOKUP formula related to dealing with member data.

An intermediate/advanced tutorial on Excel 2008 for Macs. We covered these topics:

• Understanding Clean Data
• Filtering & Sorting
• Address Parsing
• Formulas

The second installment of PTP's intermediate/advanced tutorial on Excel 2007 for Windows. We covered these topics:

• Merging Data
• Paste Special
• Formulas, Including IF and VLOOKUP
• Creating a Chart
• Creating a Pivot Table
• Using Named Ranges

An intermediate/advanced tutorial on Word 2008 for Macs. We covered these topics:

• Templates (custom and built-in)
• Customizing menus and toolbars in MS Word
• Using keyboard shortcuts
• Creating, saving and reusing styles
• Creating a table of contents from styles

In addition to what we covered in the recorded session, here are a few more handy keyboard shortcuts that work in most internet browsers and word processing programs:

Tab: lets you skip to the next field in an online form (i.e. subject line to email body)
Shift+Tab: lets you skip back to previous field in an online form

Mac-specific for folks who write in Spanish:
Option+e: accent for Spanish
Option+n: tilde for ñ
Option+1: upside-down !
Option+?: ¿

An intermediate/advanced tutorial on Word 2007 for Windows. We covered these topics:

• Templates (custom and built-in)
• Customizing menus and toolbars in MS Word
• Using keyboard shortcuts
• Creating, saving and reusing styles
• Collaborating and tracking changes
• Sections

An intermediate/advanced tutorial on Excel 2007 for Windows. We covered these topics:

• Filtering & Sorting
• Understanding Clean Data
• String Parsing
• Formulas

The session begins 2:00 minutes into the recording.