- 1x (Normal)
Using VLOOKUP with large tables4:21
Using MATCH and INDEX functions together4:14
Retrieving information by location2:53
Nesting lookup functions4:12
Looking up information with VLOOKUP and HLOOKUP4:30
Locating data with the MATCH function3:43
About This Class
Excel 2016 Advanced Formulas and Functions with Syed Farhan
Lookup and Reference 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. Proactive, Hardworking, Efficient, Reliable & Ability to work Independently or as a Team Member.
★ 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.