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






Reviews (0)

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. Proactive, Hardworking, Efficient, Reliable & Ability to work Independently or as a Team Member. 

Technical Proficiency:
★ CITM: Certified Information Technology IT Manager.
★ OCE/OCA: Oracle Certified Expert & Oracle Certified Associate for Oracle.
★ MCT/MCM: Microsoft Certified Trainer & Microsoft Certified Master for Office. 
★ MOE: Microsoft Office Expert for Word & Excel.
★ MOS: Microsoft Office Specialist for Outlook & PowerPoint.
★ MCTS: Microsoft Certified Technology Specialist for .NET Framework, Web Applications Development & SQL Server Database Implementation & Maintenance.
★ Certified in How to Prepare, Give & Evaluate Training.
★ Certificate in Communicating for Success.
★ Certified in English & Arabic Language & Quality Management Skills. 
★ Certificate in Business Management & Leadership Skills. 
★ Workshops Attended on Microsoft Project 2013 & Excel 2013. 
★ Windows 7, 8, Unix and Linux Operating Systems,Office 2010/2013, C with Data Structures, OOPS with C++, JAVA, ORACLE 10g, 11g, 12C (SQL, PL/SQL and DBA),   MS .NET Framework 4.5 (ASP.NET, C#.NET, VB.NET), Visual Basic 6.0, SQL Server 2008/2012 (SQL, T-SQL and DBA), HTML/DHTML, JavaScript, VBScript, CSS, MS .NET Project Development Life Cycle, UNIX Administration, Computer Hardware & Networking Skills.