# Excel Tutorial - Using VLOOKUP and HLOOKUP

This is an excerpt from "Excel: Advanced Formulas and Functions," a course on LinkedIn Learning taught by Dennis Taylor. Dennis is an Excel expert who has 25+ years of experience in spreadsheet authoring and training.

This is an excerpt from "Excel: Advanced Formulas and Functions," a course on LinkedIn Learning taught by Dennis Taylor. Dennis is an Excel expert who has 25+ years of experience in spreadsheet authoring and training.

Dennis has experience working as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the U.S. and Canada presenting over 300 seminars and classes.

• 00:00 - Introduction to VLOOKUP and HLOOKUP
• 03:40 - Finding matches with VLOOKUP and HLOOKUP
• 08:44 - Use VLOOKUP to find matches and search large tables

## Data Validation in Excel

What is Data Validation in Excel. Data validation is a feature in Excel used to control what a user can enter into a cell. Learn more about it with Examples.

Advanced Excel Online Training & Certification Courses by CETPA with Real time projects. Enroll now to get student offer of 50% on Online Course. Call us: 9212172602.

## Microsoft Excel Tutorial - Objects In Ms Excel- Excel Worksheet Objects

In this MS Excel tutorials, video we are going to see the differnce between tables and cell ranges in MS Excel. Also we are going to see that how can we create a Table from data given to us and what all changes we can apply to our tables.

## Microsoft Excel Tutorial - Slicers on Charts in MS Excel.

In this MS Excel tutorials, video we are going to apply the slicers in charts in MS Excel. However, there is no direct method of doing so, that is why we are going to use a simple trick over here. Also we are going to see that how can we connect same slicer with multiple charts in MS Excel. ​

## Excel VBA Tutorial for Beginners 19 - VBA Insert Cells in MS Excel

In this MS Excel VBA video, we are going to see the usage of the Insert Cells feature of MS Excel. Using this feature we can insert cells at some specified locations easily. In this video we will see the Overview of formulas in Excel.