On Demand Webinar: Excel Training Series: Vlook-up and Data Sorting

 Registration is closed for this event

Eligible for 1 GFI Elective Credit


This session looks at practical government finance uses of the lookup tables.  We begin by identifying the types of data (transactional) that is necessary for a “Vlookup” table to function and explore how to apply structure your “Vlookup” to purchase order management, parts ordering, employee records management and many other uses.  

We will also explore how to use a lookup as a simpler replacement for 'nested if' statements. Excel can also function as a database.  To facilitate this use we will explore how to sort data, by multiple variables, arranged in column tables and how to hide unnecessary columns to create highly readable reports.  

A template will be available to use along with the video. 


All OnDemand webinars are eligible for Government Finance Institute (GFI) credit. After watching the OnDemand webinar, you will need to complete a quiz and return it to receive credit.* The quiz will be accessible on the OnDemand Webinar link sent to you upon payment. 

If you choose to pay by check, a link to the OnDemand Webinar will be sent upon receipt of payment.

If you choose to pay online with a credit card, a link to the OnDemand Webinar will be sent by the end of the next business day. 

*You must be enrolled in the Government Finance Institute (GFI) program to earn GFI credit.  Not enrolled?  Click Here for more details!

September 1st, 2019 12:00 AM through June 17th, 2021 12:00 AM
The Comfort of Your Office
On-Demand Webinar, NY
OnDemand Webinar
Member $45.00
Non-Member $75.00