ALX Training / Excel / Excel – Formulas and Functions II

The Need:

Are you spending hours comparing multiple spreadsheets?
Do you have a requirement to pull data from one spreadsheet to another?

Both the above actions take large amounts of time and are at risk to human error.

VLookup and XLookup: By understanding the construction and power of these two functions, you can free up your time and feel confident that data is being pulled between spreadsheets and compared correctly.

Do you work with very large data sets?  Many organisations do. Learn why it is beneficial to use named cell ranges and how they can easily make your life easier when creating formulas and functions.

When using functions in Excel, what error messages appear? Do you understand how to overcome them? This course will explain what they mean and how to clear them.

Have you come across a spreadsheet where the formulas are no longer working? Did it need fixing by an “excel expert”? Avoid this scenario by learning to protect your formulas in worksheets so others cannot accidentally make changes to them

By the end of the course, you will be able to confidently combine, match & compare data across spreadsheets, troubleshoot formulas, and protect cells.

Course Objectives:

By the end of this program of learning, you will know:

How to name cell ranges
How to use the VLOOKUP & XLOOKUP functions
How to nest the IFERROR function
The meaning behind common error messages
How to troubleshoot common formula errors
How to protect cells & worksheets

Course Audience:

This course has been designed specifically for individuals who are confident in Microsoft Excel and need to learn core functions and formulas for their role, such as Vlookup and Xlookup, and deal with data related errors.  Roles include but are not limited to:  Finance & Accounting Professionals, Administrators, Office Managers, HR Specialists and Financial Analysts, etc.

Course Delivery Options:

   This course can be delivered online, or
   Face-to-face in our training centre, or
   At your place of work.

If you would like to have this class online, you will need access to two screens, a webcam, speakers, and a microphone.

Course Duration:

   This highly engaging program of learning is a 3-hour interactive workshop.

Course Prerequisites:

Ahead of booking onto this program of learning, you must ensure:

1. That you are familiar with the content covered in the Microsoft Excel Essentials course.

Course Includes:

All training spreadsheets for future practice
A full colour booklet to accompany the lesson

Course Cost:

In Depth (Band B)