Excel 2016 Advanced Lookup & Reference Functions

Dr. Syed Farhan, Training Manager / IT Coordinator / IT Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (24m)
    • Using VLOOKUP with large tables

    • Using MATCH and INDEX functions together

    • Retrieving information by location

    • Nesting lookup functions

    • Looking up information with VLOOKUP and HLOOKUP

    • Locating data with the MATCH function


About This Class

Excel 2016 Advanced Formulas and Functions with Syed Farhan

Lookup and Reference Functions

2 of 2 students recommendSee All

The instructor knows Excel intimately, which is obviously throughout. Stay focused on the lesson as he speaks fast, and if your mind wanders at all, you can get lost quickly.
Great crash course for advanced Excel functions





Dr. Syed Farhan

Training Manager / IT Coordinator / IT Trainer

? My Self Syed Farhan, I'm Skilled Experienced and Certified IT Manager with more than 10 years of Experience in Software & Programming, IT Training, Computer Education, Software Development, IT Coordination & Quality Assurance Management.

? Certified Trainer with hands on experience in Microsoft .NET, Software Programming, Office Suites, SQL Server & Oracle Technologies. Expertise knowledge in IT Education & Training with Excellent Instructional, Presentation & Managerial Skills. Pro...

See full profile