Excel 2016 Advanced Lookup & Reference Functions | Dr. Syed Farhan | Skillshare

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 Lessons (24m)
    • 1. Using VLOOKUP with large tables

      4:21
    • 2. Using MATCH and INDEX functions together

      4:14
    • 3. Retrieving information by location

      2:53
    • 4. Nesting lookup functions

      4:12
    • 5. Looking up information with VLOOKUP and HLOOKUP

      4:30
    • 6. Locating data with the MATCH function

      3:43

About This Class

Excel 2016 Advanced Formulas and Functions with Syed Farhan

Lookup and Reference Functions

22

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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

Report class