Excel 2016 Advanced Lookup & Reference Functions
Dr. Syed Farhan, Training Manager / IT Coordinator / IT Trainer
-
-
Using VLOOKUP with large tables
4:21 -
Using MATCH and INDEX functions together
4:14 -
Retrieving information by location
2:53 -
Nesting lookup functions
4:12 -
Looking up information with VLOOKUP and HLOOKUP
4:30 -
Locating data with the MATCH function
3:43
-
About This Class
Excel 2016 Advanced Formulas and Functions with Syed Farhan
Lookup and Reference Functions
Class Projects See All
No projects have
been added yet
No projects have
been added yet
No projects have
been added yet
No projects have
been added yet
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
? 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...
