Excel for Fundraisers!
Excel for Fundraisers presented by Greg Duke is a series of training sessions that teaches you how to be a better fundraiser by using a tool you already own.
All classes are taught by Greg Duke, D.Phil, who has used Excel for innovative research and reporting for over 25 years, and has lectured and written extensively on the use of Excel and related tools in the nonprofit world. Greg will teach you how to use valuable tools in Microsoft Excel, but also will show you how to use those tools to improve your fundraising organization. These online training sessions aren't just static lectures: Greg will present these courses LIVE, and he will answer your questions before, during, and after the presentation.
Recordings of past live sessions are available now at a reduced rate.
Topics include:
1. Blending Data with VLOOKUP
2. Basic Pivot Tables
2a. Advanced Pivot Tables
3. Make Your Data Stand Out with Conditional Formatting
4. Connect to Live Data with Hyperlinks and Get/Transform Data
5. Basic Data Analysis in Excel Using Analysis TookPak
5a. Additional Data Analysis in Excel Using Analysis TookPak
6. =COUNT(), =SUM() and All Their Friends...how to identify many data points with one simple formula
7. How to use =LEN() and related text formulas for data cleanup and much more
8. Introduction to PowerPivot and PowerTables
All classes are taught by Greg Duke, D.Phil, who has used Excel for innovative research and reporting for over 25 years, and has lectured and written extensively on the use of Excel and related tools in the nonprofit world. Greg will teach you how to use valuable tools in Microsoft Excel, but also will show you how to use those tools to improve your fundraising organization. These online training sessions aren't just static lectures: Greg will present these courses LIVE, and he will answer your questions before, during, and after the presentation.
Recordings of past live sessions are available now at a reduced rate.
Topics include:
1. Blending Data with VLOOKUP
2. Basic Pivot Tables
2a. Advanced Pivot Tables
3. Make Your Data Stand Out with Conditional Formatting
4. Connect to Live Data with Hyperlinks and Get/Transform Data
5. Basic Data Analysis in Excel Using Analysis TookPak
5a. Additional Data Analysis in Excel Using Analysis TookPak
6. =COUNT(), =SUM() and All Their Friends...how to identify many data points with one simple formula
7. How to use =LEN() and related text formulas for data cleanup and much more
8. Introduction to PowerPivot and PowerTables