Focused Skills Lab: Blending Data using VLOOKUP in Excel
One video course to improve your Excel skills
Adding information into your Excel sheet to enhance your reporting and strategic planning.
Often, fundraisers buy new data and extract different tables of data from their CRMs. In this one-lecture course, Greg covers how to use the VLOOKUP() formula to blend data from different sources, even if the sources are from outside of your database.Greg will demonstrate how to use VLOOKUP() to blend data within a report to enhance your graphs, charts, and other business intelligence tools.
A variety of uses for this formula and a variety of ways to use its results -- from mailing lists to dashboards -- is demonstrated.
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.