Mastering Lookup functions in MS Excel 2013

£40.00

Price is per online user of this course.

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.

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.

See below for further information.

Sold By: Grey Campus
Category: Tags: ,

Description

Course Components:

  1. One Year e-learning access with 3 to 5 hours of learning;
  2. Two hours of video lectures, exercises, data sets and additional material
  3. Simulated exams.

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

Entry Requirements

Some knowledge of the Microsoft Office work environment, spreadsheets, the internet and web page functionality.

Discounts

For multiple discounts, site licences, e-learning credits or to find out if discounts are available on mixed course purchases please phone a customer advisor on 0844 854 9218.

Payment Options

The most straight forward method of payment is to select the number of users you require and add the product to your shopping cart by selecting Add to Cart. You will then be able to make payment using most credit and debit cards or a Paypal account. If you would like to pay by BACs transfer or by invoice please contact a customer advisor on 0844 854 9218 or email [email protected]

Additional information

Subject

guided-learning-hours

level

resource-type

mobile-compatible

online-access-duration

Reviews

There are no reviews yet.

Be the first to review “Mastering Lookup functions in MS Excel 2013”

Your email address will not be published. Required fields are marked *

You may also like…

  • Microsoft Excel 2010 Advanced

    £60.00
    Sold By: FilteredAdd to cart
  • Excel 2013 - Online Course Bundle (7 courses)

    £40.00
    Sold By: Core Learning Services (009)Add to cart
  • Microsoft Excel 2010

    £60.00
    Sold By: FilteredAdd to cart

Keep up to date with what’s happening in the world of education, training and skills. Receive details of offers and newly launched courses, and tips on effective online and blended learning practise by signing up to our monthly newsletter. We guarantee not to sell or pass on your details and you can unsubscribe at any time.

Marketing permissions

eLearning Marketplace Ltd only use the information you provide on this form to send you a monthly e-newsletter.

You can change your mind at any time by clicking the unsubscribe link in the footer of any email you receive from us, or by contacting us at [email protected] We will treat your information with respect. For more information about our privacy practices please see our Privacy Policy. By clicking below, you agree that we may process your information in accordance with these terms.

We use MailChimp as our marketing automation platform. By clicking below to submit this form, you acknowledge that the information you provide will be transferred to MailChimp for processing in accordance with their Privacy Policy and Terms.