Chamber Business Training Academy are thrilled to announce the release of its 2025 Microsoft Excel Training Calendar.
Whether you’re a beginner, looking to improve your existing skills, or ready to tackle advanced Excel techniques, our training bundles provide the perfect opportunity to enhance your proficiency.
Why Choose Training Bundles?
- Flexible Scheduling: More dates throughout the year provide greater flexibility for when you can train.
- Streamlined Business Planning: Plan staff cover with ease while ensuring their professional development.
- Clear Progression: Training is designed to support growth between Introduction, Intermediate, and Advanced levels.
- Comprehensive Understanding: By attending multiple courses, you’ll get a complete and clear understanding of the subject matter.
Click HERE to view the 2025 Microsoft Excel Training Calendar and pricing
What to expect from each course
Microsoft Excel Introduction
Perfect for beginners, this course introduces the essentials of Excel. Learn how to manage data, perform basic calculations, and create simple charts.
Agenda
Getting Started with Excel
- Overview of the Excel screen, menus, and icons.
- Basic text and number entry, moving and copying data.
Formatting Basics
- Cell formatting using icons and shortcuts.
- Inserting and deleting rows, columns, and cells.
- Using the autofill shortcut for quick data entry.
- Applying decimals and percentages effectively.
Structuring and Formatting Spreadsheets
- Designing clean, professional-looking spreadsheets.
- Setting up basic formulas to perform calculations.
- Understanding and applying cell references.
Essential Functions
- The Sum function for quick totals.
- Basic statistical functions for averages, counts, and more.
Managing Data Lists
- Setting up simple lists or databases.
- Sorting lists alphabetically.
- Filtering data using the auto filter tool.
Visualising Data with Charts
- Introduction to creating simple column, line, and pie charts.
Printing with Ease
- Adjusting printing options for short and long spreadsheets.
Microsoft Excel Intermediate
Ideal for those who are familiar with the basics, this course takes your skills to the next level, focusing on advanced data management and analysis techniques.
Agenda
Mastering Cell References
- Absolute vs. Relative cell references.
- Naming cells and ranges for efficiency.
Enhancing Functionality
- Recap and use of Excel functions.
- Leveraging conditional functions for dynamic calculations.
- Applying validation to improve data accuracy.
Managing Long Data Sets
- Correct setup for managing extended databases.
- Formatting lists as ‘Dynamic Tables’.
Working with Dates and Text
- Understanding date functions and calculations.
- Combining text and numbers using the Concatenation formula.
Advanced Functions and Formatting
- Introduction to nested functions.
- Highlighting critical data with Conditional Formatting.
Pivot Tables and Dashboards
- Setting up and customising Pivot Tables.
- Exploring layout options and adding Charts/Slicers.
- Creating business dashboards to visualise insights.
Microsoft Excel Advanced
For experienced Excel users, this course helps you master advanced functions, manage complex datasets, and automate tasks using macros.
Agenda
Preparing for Data Analysis
- Organising and formatting large datasets for efficient analysis.
Advanced Lookup Functions
- Mastering VLOOKUP, XLOOKUP, and other multiple lookup combinations.
- Using INDEX/MATCH/OFFSET for added flexibility in data retrieval.
Dynamic Arrays and Logical Functions
- Utilising dynamic array functions and managing spill ranges.
- Understanding and applying ‘If’ statements.
- Building multiple and nested ‘If’ statements and logical combinations.
Enhancing Formula Efficiency
- Creating nested and multiple nested functions.
- Preventing and resolving errors in advanced functions.
- Replacing standard cell references with structured references for clarity.
Power Query for Data Management
- Importing data from multiple sources.
- Combining datasets and manipulating data efficiently.
Advanced Filtering Techniques
- Using Advanced Filters to extract data under complex conditions.
Automating Tasks with Macros
- Recording and running macros to streamline repetitive tasks.
- Attaching macros to buttons for quick execution.
Ready to Book?
Contact Mark Greenhalgh at m.greenhalgh@chamberelancs.co.uk to secure your spot or learn more about our training options.