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. 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.
Description
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 favorite 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.