Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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

1 of 1 students recommendSee All

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