Excel Intermediate Level - Welshpool

Excel Intermediate, Tuesday 27th January 2026

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