Webinar: Vlook-up and Data Sorting

 Registration is closed for this event

This session will look at practical government finance uses of the lookup tables.  We will 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.  

 

 

 

When
February 5th, 2019 1:00 PM   through   2:00 PM
Location
The Comfort of Your Office
Online Webinar, NY
United States
Webinar Fee
Live Webinar Fee
Member $ 55.00
Non-Member $ 85.00