Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Udemy – Mastering Lookup Functions in MS Excel 2013 Training

Posted By: naag
Udemy – Mastering Lookup Functions in MS Excel 2013 Training

Udemy – Mastering Lookup Functions in MS Excel 2013 Training
MP4 | Video: 1280x720 | 62 kbps | 44 KHz | Duration: 3 Hours | 404 MB
Genre: eLearning | Language: English

The Mastering Lookup Functions using Excel 2013 course opens up avenues to crunch data using some of the nifty tools.

Learn Excel's Lookup and References functions with easy examples. Explore the concepts of reverse lookup and missing data. The Mastering Lookup Functions using Excel 2013 course opens up avenues to crunch data using some of the nifty tools that Excel provides. This course also covers the techniques to handle errors while working with such functions.

Excel offers Lookup functions that help you to work with arrays of data. These are particularly useful when you need to cross reference between different data sets. The lookup functions perform tasks such as providing information about a range, returning the location of a given address or value, or looking up specific values. This course would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.

What are the requirements?

Some knowledge of basic word processing, computing, and spreadsheets
Familiarity with the Microsoft Office work environment
What am I going to get from this course?

Over 25 lectures and 2.5 hours of content!
Navigate worksheets
Execute different formulas and functions
Work with cell references
Cultivate best practices for spreadsheet models
Make use of different formula auditing tools to avoid errors
Create Mega formula using multiple functions
Use Lookup & reverse Lookup techniques – VLOOKUP, HLOOKUP, INDEX and MATCH
What is the target audience?

Anyone who uses MS Excel as part of their job or profession can choose this course to get a hold of Lookup functions and increase their productivity
There is no eligibility Criteria


Udemy – Mastering Lookup Functions in MS Excel 2013 Training