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:

  • Filtering & Sorting
  • Understanding Clean Data/Paste Special
  • String Parsing (or, how to make messy data CLEAN!)
  • Merging Data
  • Formulas
  • Creating a Chart / Graph
  • Pivot Table

The sample document used to conduct this training is available to download below.

Category

A tutorial on how to:

  • Orient yourself in Excel and find the tools you need (menus, tools)
  • Enter data correctly and use the right lingo (sheets, columns, records, cells)
  • Format spreadsheets & data exactly how you want (data types, column headings, copy & paste, inserting/deleting rows or columns)
  • Make use of simple formulas (Sum, CountIf)
Category

In this webinar, we covered how to:

  • Work efficiently & never lose your work (customize toolbars & keyboard shortcuts)
  • Create beautiful, consistent documents (use templates & styles)
  • Divide & conquer your document (use sections & tables of contents)
  • Collaborate on editing & finalizing documents (track changes)
Category
File attachments:

A tutorial on how to:

  • Work efficiently & never lose your work (customize toolbars & keyboard shortcuts)
  • Create beautiful, consistent documents (use templates & styles)
  • Divide & conquer your document (use sections & tables of contents)
  • Collaborate on editing & finalizing documents (track changes)
Category
File attachments:

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