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 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

This session focuses on the workaround to do batch updating of event participants' information using profiles. We will be working on the PowerBase solution during the development of Phase II.

Category