Focused Skills Lab: Conditional Formatting, Making Information Stand Out in Excel
One video course to improve your Excel skills
How to use Excel's conditional formatting tools to create dynamic, stand-out reports.
You’ve just put together a report for a committee meeting, and you’re sure that you’ve included everything the committee needs to make the right decisions. The head of the committee squints at a copy of the report, frowns, and asks “What am I supposed to be looking at here?”
Sometimes you need data points to stand out in a list or a report so that everyone knows exactly what they should be looking for. Microsoft Excel’s Conditional Formatting tools can draw eyes to information like top donors and prospects, increased fund activity, or anything else you want to highlight.Make your data stand out with Conditional Formatting, Greg Duke will demonstrate how to make your lists and reports visually appealing with boldface, color, and even custom icons. Excel for Fundraisers Live! will help you make all your lists and reports actionable and dynamic!
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.