Focused Skills Lab: Basic Pivot Tables in Excel
Learn why pivot tables are so powerful, when to use them, and how to create and use one.
More Excel Tricks for Fundraisers
By Dr. Greg Duke During our Water Cooler Chat, I presented some powerful Excel techniques— Watch the replay video for tips on: Ranking prospects using =RANK.EQ(), Adding up gifts to a specific campaign or fund using =SUMIFs and related “ifs” functions, Bringing in fresh data from… Read More »More Excel Tricks for Fundraisers
March Comes in Like a Lion and Goes Out Like an Excel Guru Lion
March is normally a quiet time in fundraising, but June is coming up fast. Join Greg Duke to discover more ways to ease your administrivia load with Greg’s latest Excel tricks and tips.
How to Create Word Clouds from Your Contact Reports Using Excel
In our February Water Cooler Chat, we were asked if it were possible to do a word cloud from contact reports using Excel because it’s a tool that is familiar and used often.Although it is possible, the process is clunky. Since Excel wasn’t built to… Read More »How to Create Word Clouds from Your Contact Reports Using Excel
Three Uses of Monte Carlo Analysis in Fundraising
In our recent Water Cooler Chat, Greg Duke, Partner for Database Services, shared the Monte Carlo technique – a way of understanding what the likely range of results would be for a given scenario. In our blog post today, we expand on the concept of… Read More »Three Uses of Monte Carlo Analysis in Fundraising