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
Students
Projects
Reviews (0)
★ 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.
