Focused Skills Lab: Basic Pivot Tables in Excel
One video course to improve your Excel skills
Why pivot tables are so powerful, when to use them, and how to create and use one.
Summarizing giving and other data can be done in Excel, including get sums by campaign, fund, or other subtotals that your organization needs for good strategy.
Enjoy this recorded lecture on creating pivot tables -- Excel's tool for summarizing data, including using subtotals and making cubes.
To make the illustrations relevant to your work, the course content is focused on the nonprofit sector.
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.