Microsoft Excel Advanced

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

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

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.