Workshop Details
Title: Excel 2016: Large Data 3 - vLookups
Provider: AHC Training - Gainesville
Topic: Microsoft Excel 2016
Duration: 1.5hrs
Audience: Advanced
Handout Link: vLookup Handout
 
Detailed Description:

In this advanced math workshop, we will work with multipart functions such as IF() and VLOOKUP() statements.

An IF statement is a three-part function that allows you to change the result based on a logic statement, you can return one value if the answer is TRUE and another if the answer is FALSE.

A VLOOKUP() statement is a four-part function that allows you to search for a value in a large data set, and return a different value from that same row. For example, if you a large data set of Employee Numbers, Names, and Titles, you can have Excel search for the Employee Number through the VLOOKUP function and have it return the Employee's Name and Title. We will also use Data Validation to create drop-down lists that help with data entry. We'll use the results of the list in our functions.

Experience with building equations in Excel required.

  Click here to register in myTraining


Scheduled Dates:
DateLocationSeats Left 
7/31/2017 9:30 AM C3-013 Communicore0 Register
9/5/2017 1:00 PM C3-013 Communicore5 Register
8/1/2017 1:00 PM C3-013 Communicore5 Register
10/9/2017 9:30 AM C3-013 Communicore5 Register




Primary Navigation

  • Home
  • Schedule
  • Email Lists
  • Handouts
  • List All Workshops
  • UF Training Resources
  • Reserve Training Room
  • Directions
  • Contact Us