This video tutorial shows you how to set up basic formulas in MS Excel. By using this method, you would be able find out your direct mail response rates and average gift. Also, I touch on how to "reverse engineer" your statistics if you only know the response rates and average gift, perhaps from a past mailer.
You can check out my other video tutorial on how to use Excel for fundraisers here.
If you enjoyed this video please subscribe to Real Deal Fundraising.
Jessica Cloud, CFRE
I've been called the Tasmanian Devil of fundraising and I'm here to talk shop with you.
What Folks Are Saying
Jessica has been a wonderful colleague and mentor over the years. In the beginning of my annual giving career, I found her expertise, experience and willingness to help, invaluable. Her advice and custom phonathon spreadsheets had a direct impact on our phonathon’s success and my ultimate promotion. As I progress in my career, I continue to value her insight and professionalism."