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.
4.1 (7 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.
582 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 27
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course 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.

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?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
01:56
Section 2: Navigating worksheets
Navigating worksheets
Preview
06:11
Section 3: Understanding Cell References
Understanding cell references
Preview
13:09
Section 4: The Backstage view - Analysis Perspective
The Backstage view - Analysis Perspective
10:38
Section 5: Tabs, Toolbars and Ribbons
Tabs, Toolbars and Ribbons
06:31
Section 6: Entering Formulas - Thumb Rules
Entering Formulas - Thumb Rules
12:23
Section 7: Best Practices for Spreadsheet Models
Best Practices for Spreadsheet Models
07:40
Section 8: Frequently used Functions in Excel
Frequently used Functions in Excel
08:51
Section 9: Using Lookup functions
Using lookup functions Part 1
03:18
Using lookup functions Part 2
Preview
14:16
Using lookup functions Part 3
09:21
Using lookup functions Part 4
01:32
Dataset
1 page
Section 10: Reverse Lookup techniques – using INDEX and MATCH
Reverse Lookup techniques – using INDEX and MATCH
10:37
Section 11: Effective Error handling – using ISERROR/IFERROR
Effective Error handling – using ISERROR/IFERROR
06:01
Section 12: Tracing formula dependents and precedents
Tracing formula dependents and precedents
08:52
Section 13: Using formula auditing tools to avoid errors
Using formula auditing tools to avoid errors
04:15
Section 14: Creating Mega-Formula using multiple functions
Creating Mega-Formula using multiple functions
09:17
Dataset
1 page
Section 15: Additional material
Keyboard Shortcuts
21 pages
What's new in Excel 2013
Article
LOOKUP Function
Article
IF Function
Article
Create conditional formulas to find data or apply formatting
Article
Section 16: Practice Tests
Practice Test 1
30 questions
Practice Test 2
25 questions
Section 17: Exercises
Exercises
1 page
Section 18: Course Conclusion
Review Appreciated
Article
Quick Bonus for You!
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., 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.

Ready to start learning?
Take This Course