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 Excel for Fundraisers Live! -- Connect to Live Data with Hyperlinks and Get/Transform Data, 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

Dr. Gregory E. Duke
Dr. Gregory E. Duke

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

  Connect to Live Data with Hyperlinks and Get/Transform Data
Available in days
days after you enroll

Frequently Asked Questions

When does the course start and finish?
The course starts November 5 with our LIVE session, 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.

Get started now!