Focused Skills Lab:
Conditional Formatting in Excel
Make your fundraising data stand out with Excel’s conditional formatting tools, using boldface, color, and custom icons to create clear, actionable reports.
Your report has all the right information. Can your audience see what matters?
You’ve put together a report for a committee meeting and included everything the committee needs to make informed decisions. But the committee chair squints at the page and asks, “What am I supposed to be looking at here?”
When important data gets lost in rows of numbers, even a thorough report can leave people unsure where to focus. Top donors, promising prospects, and increased fund activity need to stand out—not blend in.
In this Focused Skills Lab, Dr. Greg Duke demonstrates how to use Microsoft Excel’s conditional formatting tools to draw attention to the information your audience needs to see.
Learn how boldface, color, and custom icons can make your lists and reports more visually appealing while highlighting key fundraising data.
Whether you’re identifying top donors and prospects or calling attention to increased fund activity, conditional formatting helps turn a list of numbers into a report people can use.
Spot what matters with clear, dynamic reports in Excel.
Your Instructor
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: Conditional Formatting in Excel
- Using Excel’s conditional formatting tools to highlight important data
- Making lists and reports stand out with boldface, color, and custom icons
- Drawing attention to top donors and prospects, increaded fund activity, and other key fundraising information
Make your fundraising data easier to see and act on with conditional formatting in Excel.
$29.97
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.