These are the Presenters' outlines written by Josue and used in the PowerBase for Organizers training in Minnesota. They are saved in PDF and ms word format so that they can be used by PowerBase groups in their own training.
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.
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)
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)
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)
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
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
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
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
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