Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|Section 2: Navigating worksheets|
|Section 3: Understanding Cell References|
Understanding cell referencesPreview
|Section 4: The Backstage view - Analysis Perspective|
The Backstage view - Analysis Perspective
|Section 5: Tabs, Toolbars and Ribbons|
Tabs, Toolbars and Ribbons
|Section 6: Entering Formulas - Thumb Rules|
Entering Formulas - Thumb Rules
|Section 7: Best Practices for Spreadsheet Models|
Best Practices for Spreadsheet Models
|Section 8: Frequently used Functions in Excel|
Frequently used Functions in Excel
|Section 9: Using Lookup functions|
Using lookup functions Part 1
Using lookup functions Part 2Preview
Using lookup functions Part 3
Using lookup functions Part 4
|Section 10: Reverse Lookup techniques – using INDEX and MATCH|
Reverse Lookup techniques – using INDEX and MATCH
|Section 11: Effective Error handling – using ISERROR/IFERROR|
Effective Error handling – using ISERROR/IFERROR
|Section 12: Tracing formula dependents and precedents|
Tracing formula dependents and precedents
|Section 13: Using formula auditing tools to avoid errors|
Using formula auditing tools to avoid errors
|Section 14: Creating Mega-Formula using multiple functions|
Creating Mega-Formula using multiple functions
|Section 15: Additional material|
What's new in Excel 2013
Create conditional formulas to find data or apply formatting
|Section 16: Practice Tests|
Practice Test 1
Practice Test 2
|Section 17: Exercises|
|Section 18: Course Conclusion|
Quick Bonus for You!
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.