Focused Skills Lab: Connect to Live Data with Hyperlinks and Get/Transform Data in Excel
One video course to improve your Excel skills
How many times have you had to look up a stock price to determine a prospect’s giving capacity? What if, instead of having to type in the stock price, its day-to-day valuation, and historical pricing data, you could pull all that info right into a report? Even better…what if you could link that report right to the stock’s Web page so you never have to look it up again?
Hyperlinks aren’t just for Web pages anymore. In this one-lecture course, Greg Duke will show you how not just to pull data tables into a report from just about anywhere on the Internet, but how to link to those tables so that if it changes, your report changes, too!
Dr. Duke will also demonstrate how to get and transform data from different online formats into Excel…even from your organization’s Facebook page. Whether you’re looking to pull an events schedule from a website into a fundraising report, or you want to get information from an online list, this Excel for Fundraisers Live class is for you!
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.