Focused Skills Lab: COUNT(), SUM(), and all their friends in Excel

One video course to improve your Excel skills

It’s always useful to know how many donors are in a list, or how much money the donors in that list have given to your organization. But what if you need to know how many donors from Texas gave $1,000 or more in fiscal year 2018, or how much on average your trustees gave to the annual fund? You might be surprised that there’s a way to find out the answers to either of those questions with one simple formula.

In COUNT, SUM, and all their friends:Excel for Fundraisers, Greg Duke will unpack the many formulas Excel has hidden behind its common COUNT and SUM functions, including ways to determine averages and maximum or minimum amounts, and how to include conditional criteria for each of them. Dr. Duke will also show you how to leverage these functions to create incredibly detailed reports and gift pyramids that can be refreshed any time your data changes! Join Dr. Duke as he demonstrates how you can count on Excel to sum up your work faster and more efficiently.

Your Instructor

Dr. Gregory E. Duke
Dr. Gregory E. Duke

For over 20 years, Greg Duke has worked in fundraising organizations in the United States and the United Kingdom, working primarily in database management and prospect research.

Duke helps Raiser’s Edge clients to optimize their database by implementing data clean-up techniques and creating reporting structures, including dashboards and SQL queries. He also facilitates data imports into Raiser’s Edge and database administration.

Duke has worked at the University of Oxford, Niagara University, Florida International University, and the Rochester Institute of Technology. He has lectured at several APRA International and regional conferences, and previously taught a fundraising course at Niagara University. Duke earned a D.Phil in modern history from Jesus College, University of Oxford.

Course Curriculum

  Excel for Fundraisers Live: COUNT(), SUM(), and all their friends
Available in days
days after you enroll

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!