TechCamp Online: Intermediate Advanced Excel 2008 (Mac) Part II August 19th 2010

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.

TechCamp Online: Intermediate Advanced Excel 2008 (Mac) Part I August 19th 2010

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

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

TechCamp Online: Intermediate Advanced Excel 2007 (Windows) Part II

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

TechCamp Online: Intermediate Advanced Word 2008 (Macs)

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+?: ¿

TechCamp Online: Intermediate Advanced Word 2007 (Windows)

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

TechCamp Online: Intermediate Advanced Excel 2007 (Windows) Part I

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.

Behind the Curtain: What non-profits can learn from the Obama Campaign’s online strategy - February 17th, 2010

Katherine Mackenzie, a consultant for M+R Strategic Services will take us behind the scenes of the Obama Campaign’s new media strategy. She will be presenting key findings from the report Online Tactics and Success: An Examination of the Obama for American New Media Campaign that M+R Strategic Services prepared for the Wilburforce and Brainerd Foundations.

The report documents the results of M+R’s quantitative and qualitative analysis of the Obama for America’s New Media Campaign. The goal was to attempt to understand which strategies and tactics drove a true return on investment for the campaign and which did not, and how the winning strategies can be replicated by nonprofit advocacy organizations.

Here are links to additional materials:

  • Click here for the 2009 Benchmark study that analyzes online messaging, fundraising, and advocacy data from 32 leading nonprofit organizations
  • Click here for other articles and best practices in the publication section of the M+R website

PowerBase Pilot Project Training - Batch Update with Participant profile

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.

PowerBase Pilot Project Training - Day 5

Here's the recording for Day 5 on:

  • working with profiles and groups

PowerBase Pilot Project Training - Day 4

Here's the recording for Day 4 on:

  • working with the email salutation field and token for email message templates
  • Understanding Profiles
  • Creating Profiles for Search views [to be revisited on Day 5]
  • Creating Profiles for Batch updates
  • Creating Profiles for use with online Event Registration