Mastering Microsoft Excel: Advanced

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 Zoom

Date: next date to be confirmed

Time: 9.30am-4pm

Price: £100

CLOSED AT PRESENT

Group pricing is also available - just ask!

For further information on this course and its start dates contact corporate@wcs.ac.uk or call 0141 581 2121