Online Excel Training Course

Course Description: This virtual course is designed for people wish to learn how to create and work with advanced formulas and functions.  This course will include creating complex formulas by nesting multiple functions together, use VLOOKUP, XLOOKUP functions and also create and use Named Ranges to create formulas and assist with workbook navigation.

Prerequisites: Delegates attending this course should have a good knowledge of formulas and functions and/or have attended the Formulas and Functions Bite Size Course.

Course Content

• VLOOKUP, XLOOKUP:

• Applying LOOKUP Functions
• VLOOKUP
• XLOOKUP

• Nesting Multiple Functions together:

• Rules for Nesting multiple functions
• BODMAS
• Nesting simple multiple functions
• IF VLOOKUP nested functions
• IF AND NOT nested functions

• Named ranges

• Working with Named Ranges
• Rules for Naming Cells
• Defined Names Group of buttons
• Audit a Named Range
• Name a range of cells (long and short method)
• Name a range of cells based on cell values
• Navigate workbooks using Named Ranges
• Using Named Ranges with Formulas
• Delete Names Ranges

This course will run 3 hours with a 15-minute break.  Morning sessions will be 09:30 until 12:30.  Afternoon sessions will be from 13:00 until 16:00 with a 15-minute break.