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.
LAPTOPS WILL BE REQUIRED FOR THIS COURSE ALONG WITH THE RELEVANT SOFTWARE INSTALLED AND ACCESSIBLE.
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.
Friday 12th December – 9:30am – 12:30pm
Free
You will learn how to:
Name cell ranges
Use the VLOOKUP & XLOOKUP functions
Know how to nest the IFERROR function
Understand the meaning behind common error messages
Troubleshoot common formula errors
Protect cells & worksheets
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.
LAPTOPS WILL BE REQUIRED FOR THIS COURSE ALONG WITH THE RELEVANT SOFTWARE INSTALLED AND ACCESSIBLE.
ALX Training
We are a team of experienced IT Trainers & Software Adoption Specialists who deliver creative design-led learning to private & public sector organisations.
Driven by our clients’ needs, we help organisations realise the full potential of their IT investment.
ALX Training is part of BDO Jersey, working closely with BDO Advisory and C5 Alliance to help businesses and people succeed