Lesson 11 of 14 • 26 upvotes • 6:46mins
This lesson discusses a very important function of Microsoft Excel, i.e. VLOOKUP. It elaborates on what is actually VLOOKUP and ion which all scenarios VLOOKUP can be used. This lesson explains the entire feature with the help of the example. Another feature of 'Error handling' is also discussed along with the real-time Excel Images.
14 lessons • 1h 35m
Overview Of The Course: Microsoft Excel - From Beginner To Becoming A Pro
5:55mins
Introduction To Microsoft Excel
5:36mins
Creating Your First Worksheet
7:20mins
Changing The Layout Of A Worksheet
6:14mins
Formatting Data In A Worksheet
7:07mins
Sorting And Filtering Data In A Worksheet
7:13mins
Inserting Elements In A Worksheet
9:05mins
Working With Charts And Graphs
7:59mins
Inserting A Formulae In Worksheets
9:38mins
Exploring Functions In MS Excel
8:47mins
Exploring VLOOKUP With An Example
6:46mins
Learn How To Create Pivot Tables
4:48mins
How To Create Macros In MS Excel
3:52mins
Beyond Data In MS Excel
5:17mins