Trainings

Please find below a list of many of the trainings that the Progressive Technology Project has conducted over the years. Each training contains links to materials used in the trainings.

A tutorial on how to create compelling presentations using (and not abusing) PowerPoint 2008 for Mac. We covered these topics:

  • Changing a Presentation Look (working with master slides)
  • Slide Animation
  • Adding Sounds and Movies to a Slide
  • Printing Presentations, Notes, and Handouts
  • PowerPoint Best Practices
Category
File attachments:

A tutorial on how to create compelling presentations using (and not abusing) PowerPoint 2007 for Windows. We covered these topics:

  • Changing a Presentation Look (working with master slides)
  • Slide Animation
  • Adding Sounds and Movies to a Slide
  • Printing Presentations, Notes, and Handouts
  • PowerPoint Best Practices
Category

A tutorial on how to do a mail merge (or data merge, more generally) using Word & Excel 2008 for Macs. We covered these topics:

  • Preparing Excel sheet for mail merge
  • Creating a merge document in Microsoft Word
  • Outputting your mail merge
  • Reusing your merge document
  • Merging data for labels
  • Call list example
Category

A tutorial on how to do a mail merge (or data merge, more generally) using Word & Excel 2007 for Windows. We covered these topics:

  • Preparing Excel sheet for mail merge
  • Creating a merge document in Microsoft Word
  • Outputting your mail merge
  • Reusing your merge document
  • Merging data for labels
  • Call list example
Category

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
Category

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

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

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
Category

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
Category
File attachments:

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
Category
File attachments:

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.

Category