Mastering Lookup Functions in MS Excel 2013 - Online Self Learning

Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial, models or designing complex dashboards. The Mastering Lookup Functions using Excel 2013 course opens up avenues to crunch data using some of the nifty tools that Excel provides.

USD 199

Enroll Download Course Brochure
1 Year Access
Practice Exercises
Simulated Exams
Datasets

Course Description

This training would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.

This course focusses on specific business situations, and then demonstrates how to create spreadsheets for those problem areas. Attend these extraordinary, information-packed, powerful sessions to increase your productivity, improve the quality, accuracy & make a better report.

This course is recommended for end users seeking proficiency in the use of Microsoft Excel 2013 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2013.

Course Inclusion

  • 1 Year E-learning Access

  • 2+ hours of Video lectures

  • Simulated Exams

  • Exercises for your practice

  • Additional Material

  • Datasets  

  • High impact, proven training – 30000+ professionals trained globally

  • Experienced, expert instructors – Our Instructors come with a rich, 10+ years of industry experience.

  • Classroom Training programs delivered across 50+ locations globally

  • Content is developed in-house in GreyCampus by highly experienced industry experts

Course Objectives

After the completion of the course, participants will be able to

  1. Understand how to navigate on worksheets

  2. Execute different formulas and functions

  3. Understand cell references

  4. Explain best practices for spreadsheet models

  5. Understand different formula auditing tools to avoid errors

  6. Create Mega formula using multiple functions

  7. Using Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP, INDEX and MATCH

Curriculum

  • Module 1: Navigating worksheets
  • Module 2: Understanding Cell References
  • Module 3: The Backstage view - Analysis Perspective
  • Module 4: Tabs, Toolbars and Ribbons
  • Module 5: Entering Formulas - Thumb Rules
  • Module 6: Best Practices for Spreadsheet Models
  • Module 7: Frequently used Functions in Excel
  • Module 8: Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP
  • Module 9: Reverse Lookup techniques – using INDEX and MATCH
  • Module 10: Effective Error handling – using ISERROR
  • Module 11: Tracing formula dependents and precedents
  • Module 12: Using formula auditing tools to avoid errors
  • Module 13: Creating Mega-Formula using multiple functions

FAQs

Q: What are the pre-requisites for this course

A: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality