Microsoft Excel Advanced

Course Duration is 1 Day

From: £295.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

Business Benefit

Spreadsheets are fundamental tools in business and data analysis, but their true power is unleashed when you can automate repetitive tasks and processes using macros.

Who Should Attend

Those who wish to use Excels advanced formulas and functions to manipulate their spreadsheets, create their own customised functions to perform calculations, specific or unique to a task and gain greater control of the Excel environment by learning the Excel programming language

Learning Outcomes

Dynamic Lists and Charts: Learn to create and manage dynamic lists and charts that can adapt to changes in data, enhancing the flexibility and relevance of your spreadsheets
Array Formulas: Gain a deep understanding of array formulas, a powerful tool for performing complex calculations and operations on sets of data
Text Function Mastery: Learn how to manipulate text effectively using text functions, making it easier to clean, format, and analyse textual data
Automation with Macros: Discover how to record and execute repetitive series of keystrokes and commands as macros, streamlining tasks and saving time.
Custom Functions: Create and customise functions tailored to your specific needs, allowing you to perform specialised calculations and operations within Excel
Excel Programming Basics: Understand the fundamentals of Excel’s programming language, enabling you to write custom scripts and automate tasks
Spreadsheet Automation and Interactivity: Learn how to automate spreadsheets and make them interactive for other users, enhancing collaboration and efficiency in data analysis

Course Content

Templates: Explore the use of templates, which are pre-designed spreadsheets or documents that can be customised for various purposes, streamlining your work and ensuring consistency in your projects.
Text Manipulation Functions: Learn about functions and techniques for manipulating text within Excel, such as cleaning and formatting textual data for analysis or reporting.
Array Formulas: Dive into the world of array formulas, a powerful feature that allows you to perform complex calculations on ranges of data with a single formula.
Dynamic Named Ranges: Understand how to create dynamic named ranges, which automatically adjust as your data changes, making your spreadsheets more flexible and efficient.
Automating Spreadsheets: Discover methods for automating repetitive tasks and processes within Excel, saving time and reducing the risk of errors.
Recording Macros: Learn how to record and create macros, which are sequences of actions that can be replayed to automate tasks and operations.
Macro Playback Shortcuts: Explore shortcuts and techniques for efficiently playing back macros, enhancing your productivity.
The Visual Basic Editor: Get familiar with the Visual Basic for Applications (VBA) editor, a powerful tool for writing and editing macros and scripts within Excel.
Troubleshooting Macro Code: Develop skills for identifying and resolving issues in macro code, ensuring your automation runs smoothly.
Programming Fundamentals: Gain an understanding of fundamental programming concepts, which form the basis for creating custom functions and automating tasks in Excel.
Interacting with the User: Learn how to create interactive elements within your spreadsheets, allowing users to input data or make choices that affect the calculations and outcomes.
Making Decisions: Explore decision-making processes within Excel, including conditional statements and logic, to control the flow of your macros and functions.
Custom Functions: Discover how to create custom functions tailored to your specific needs, extending Excel’s capabilities and enabling you to perform unique calculations and tasks.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.


These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.