Mastering Lookup Functions in MS Excel 2013 Training
3.3 (6 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.
593 students enrolled
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 assists to crunch data using some of the nifty tools.
3.3 (6 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.
593 students enrolled
Created by GreyCampus Inc.
Last updated 12/2015
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
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
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
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
Curriculum For This Course
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
GreyCampus Inc.
4.0 Average rating
2,082 Reviews
26,052 Students
53 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.