Excel - Plain and Simple Lookups
- 0.25 Course
- Language: English
Introduction:
This course is an introduction to lookup functions. Learn different types of lookup functions, when to use them, and how to quickly find answers within a dataset. Lookup functions are one of the most frequently used advanced features and this is a great place to start.
Objectives:
Course Outline:
1 – Outline
- Make functions and formulas easier to read with named and data easier to access by defining and using range names.
- Find and return specific values in a dataset with the power of VLOOKUP. One of the most used tools in higher levels of excel
- Find values from differently structured datasets where VLOOKUP might not work.
- Use VLOOKUP and HLOOKUP functions with true to find an approximate match.
- Index and match – learn how to set up and use the powerful lookup function index and learn about the differences from VLOOKUP.
Enroll in this course
$49.00
Abee, Alcomdale, Alpen, Athabasca, Atmore, Beamer, Bon Accord, Bondiss, Boyle, Busby, Calahoo, Calling Lake, Carbondale, Cardiff, Chisolm, Clyde, Colinton, Coronado, County of Athabasca, County of Thorhild, Dapp, Duagh, Egremont, Ellscott, Fawcett, Flatbush, Gibbons, Grassland, Halasa, Hondo, Island Lake, Island Lake South, Jarvie, Kerensky, Lamoureux, Lancaster Park, Larkspur, Legal, Sturgeon County, Westlock County, Meanook, Mearns, Mewatha Beach, Morinville, Namao, Nesto, Newbrook, Opal, Perryvale, Pibroch, Pickardville, Pine Sands, Radway, Red Water, Riviere Qui Barre, Rochester, Smith, South Baptiste, Sunset Beach, Tawatinaw, Thorhild, Villeneuve, Vimy, Westlock, Whispering Hills, White Gull
