Excel for Fundraisers Live!
Excel for Fundraisers Live! presented by Greg Duke is a series of live 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. We do not yet have a schedule for the 2020 live sessions.
Topics include:
1. Blending Data with VLOOKUP (Recorded Oct 8, 2019)
2. Basic Pivot Tables (Recorded Oct 15, 2019)
2a. Advanced Pivot Tables (Recorded Oct 22, 2019)
3. Make Your Data Stand Out with Conditional Formatting (Recorded Oct 29, 2019)
4. Connect to Live Data with Hyperlinks and Get/Transform Data (Recorded Nov 5, 2019)
5. Basic Data Analysis in Excel Using Analysis TookPak (Recorded Nov 12, 2019)
5a. Additional Data Analysis in Excel Using Analysis TookPak (Recorded Nov 19, 2019)
6. =COUNT(), =SUM() and All Their Friends...how to identify many data points with one simple formula (Recorded Dec 3, 2019)
7. How to use =LEN() and related text formulas for data cleanup and much more (Recorded Dec 10, 2019)
8. Introduction to PowerPivot and PowerTables (Recorded Dec 17, 2019)
Sign up below for reminders for upcoming 2020 sessions.
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. We do not yet have a schedule for the 2020 live sessions.
Topics include:
1. Blending Data with VLOOKUP (Recorded Oct 8, 2019)
2. Basic Pivot Tables (Recorded Oct 15, 2019)
2a. Advanced Pivot Tables (Recorded Oct 22, 2019)
3. Make Your Data Stand Out with Conditional Formatting (Recorded Oct 29, 2019)
4. Connect to Live Data with Hyperlinks and Get/Transform Data (Recorded Nov 5, 2019)
5. Basic Data Analysis in Excel Using Analysis TookPak (Recorded Nov 12, 2019)
5a. Additional Data Analysis in Excel Using Analysis TookPak (Recorded Nov 19, 2019)
6. =COUNT(), =SUM() and All Their Friends...how to identify many data points with one simple formula (Recorded Dec 3, 2019)
7. How to use =LEN() and related text formulas for data cleanup and much more (Recorded Dec 10, 2019)
8. Introduction to PowerPivot and PowerTables (Recorded Dec 17, 2019)
Sign up below for reminders for upcoming 2020 sessions.