Microsoft Excel - Advanced
This advanced-level Excel workshop is designed for individuals who are already proficient in the basics of Microsoft Excel and want to take their skills to the next level.
Dates
There are no dates currently scheduled for this course.
Interested in this course?
Suggest a date/location
Description
This advanced-level Excel workshop is designed for individuals who are already proficient in the basics of Microsoft Excel and want to take their skills to the next level.
You will learn how to apply advanced formulas, customise the menu and automate the analysis of data. This workshop is ideal for anyone who uses Excel in their daily work or who wants to improve their data analysis skills.
Prerequisites
None
Content
Attending this course will help you to:
- Effectively apply v-lookups in your spreadsheets
- Use multiple nested formula within a single cell
- Customise the menu, even including your favourite functions under your own menu-name
- Create your own customised auto-fill lists
- Automate the analysis of data through advanced custom conditional-formatting rules
- Apply and define names to cells and ranges
Certification
College certificate of attendance