Excel Intermediate Level

Cost: Am ddim

he 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: Thursday 21st May 2026

Cost: Free to attend - Digital & Employment skills bitesize training fully funded

Venue: Welshpool

For Employees and self employed in Mid Wales

We reserve the right to cancel or amend the timings of these sessions at any point up to the stated start time of the session.

Delegates may also cancel their booking at any time by following the link in their confirmation email.

Delegates are responsible for ensuring that they can access the web site where the training is delivered and for any all and any charges incurred during attendance at the session.

The delegate acknowledges that all course material, program material or copies thereof are and will remain the property of the training provider and are subject to copyright. It is expressly agreed that neither the delegate nor their sponsoring organisation will copy the whole or any part of those materials without the written consent of the training provider.

The training provider accepts no responsibility whatsoever for the subsequent use of the EMS by the delegate or their sponsoring organisation as a result of their participation in the training and shall not be liable for any loss or damage arising to the delegate, their sponsoring organisation or any third parties howsoever that loss or damage arises (save that this provision will not exclude liability for death or personal injury arising from the negligence of the training provider).

No variation to these conditions shall be binding unless agreed in writing between the authorised representatives of the training provider and the delegate and/or their sponsoring organisation. The delegate and their sponsoring organisation acknowledge that these terms and conditions supersede any written or verbal communication.