Excel Intermediate ONLINE, Monday 20th July 2026
The Excel Intermediate level covers the following 2 modules.
Module 3 - Creating Formulas
Using the AutoSum feature to automatically add values
Understanding Formulas and their rules
Creating Basic Formulas
Copying and Pasting Formulas
Ensuring formulas update automatically
Using and Creating Absolute Formulas to enable a specific value to be used many times, i.e. VAT rate
Finding Minimum, Maximum and Average values of a list of data
Using the Audit Feature to display cells used with Formulas
Using named ranges within a formula
Using the Function Library
Inserting and Formatting Dates and Times
Using Dates within Formulas
Module 4 - Links, Graphs & Basic Conditional Logic
Working with Hyperlinks
Removing Duplicate Values for line of data
Using AutoFilter to view a specific set of data
Sorting a spreadsheet
Use of the Transpose feature to flip the orientations of data
Inserting Automatic Subtotals
Linking Workbooks
Protecting Formulas and Worksheets
Working with Multiple Worksheets within a Single Workbook, Renaming, Inserting, Copying Information
Creating Summary Worksheets using 3D formulas
Creating and formatting Charts
Duration: 1 day
Date: Monday 20th July 2026
Cost: Free to attend - Digital & Employment skills bitesize training fully funded by Welsh Government
Venue: Online
Course Delivery: This course will be delivered by Pat Jones, PS Training.
Delegates should join the training in a quiet space, with minimal risk of disruption, and not to be called away during the session.
Book online using the booking “Sign Up” button below, call 01686 628778 or email sam@mwmg.org
If there are no spots available and you wish to be added to the reserve list in case of cancellation please email sam@mwmg.org