Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Mastering Lookup Functions in MS Excel 2013 Training to your Wishlist.

Add to Wishlist

Mastering Lookup Functions in MS Excel 2013 Training

The Mastering Lookup Functions using Excel 2013 course opens up avenues to crunch data using some of the nifty tools.
3.1 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
587 students enrolled
Last updated 12/2015
English
$10 $30 67% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 6 Articles
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

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.

Who 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
Students Who Viewed This Course Also Viewed
What Will I Learn?
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
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
Curriculum For This Course
Expand All 27 Lectures Collapse All 27 Lectures 02:40:20
+
Introduction
1 Lecture 01:56
+
Navigating worksheets
1 Lecture 06:11
+
Understanding Cell References
1 Lecture 13:09
+
The Backstage view - Analysis Perspective
1 Lecture 10:38
The Backstage view - Analysis Perspective
10:38
+
Tabs, Toolbars and Ribbons
1 Lecture 06:31
Tabs, Toolbars and Ribbons
06:31
+
Entering Formulas - Thumb Rules
1 Lecture 12:23
Entering Formulas - Thumb Rules
12:23
+
Best Practices for Spreadsheet Models
1 Lecture 07:40
Best Practices for Spreadsheet Models
07:40
+
Frequently used Functions in Excel
1 Lecture 08:51
Frequently used Functions in Excel
08:51
+
Using Lookup functions
5 Lectures 28:27
Using lookup functions Part 1
03:18


Using lookup functions Part 3
09:21

Using lookup functions Part 4
01:32

Dataset
1 page
+
Reverse Lookup techniques – using INDEX and MATCH
1 Lecture 10:37
Reverse Lookup techniques – using INDEX and MATCH
10:37
8 More Sections
About the Instructor
4.2 Average rating
1,536 Reviews
17,675 Students
35 Courses
Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.

Report Abuse