Overview
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.
Note: Our advanced courses are regularly updated to include the latest AI releases and best practice.
Attending this intermediate-level Excel workshop will help you to:
- Effectively apply v-lookups and x-lookups in your spreadsheets.
- Work confidently with pivot tables, creating dynamic reports and graphs in minutes.
- Record macros to automate repetitive tasks.
- 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.
- Data forecasting: what-if and scenario manager.
- Use formula auditing tools for problem solving.
Prerequisites for attending:
- Learners should have attended a beginner or intermediate level course in Microsoft Excel.
- Working knowledge of Microsoft Excel is required.
Duration: 1 Day
Study Mode: Online via Teams
Time: 9.30am-4pm
Price: £90
Date:
For further information on this course, contact businesstraining@wcs.ac.uk or call 0141 468 4163.
