Excel Bite Size ½ day Sessions – Advanced Formulas and Functions
- Designed for advanced Excel users to create complex formulas and functions.
- Prerequisites include a good knowledge of formulas and functions.
- Covers VLOOKUP, XLOOKUP, nesting multiple functions, and Named Ranges.
- Participants will learn to navigate workbooks using Named Ranges.
- Course runs for 3 hours with morning and afternoon sessions.
Overview
This online Excel training course focuses on teaching advanced formulas and functions. Participants will learn to create complex formulas by nesting functions, use VLOOKUP and XLOOKUP, and work with Named Ranges for formula creation and workbook navigation. Prerequisites include a good understanding of formulas or attendance at a previous course. The course runs for 3 hours with morning and afternoon sessions, including a 15-minute break.
Who should attend
Excel Users
Course Content
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.
