Back to All Events

Excel Intermediate Level - Online

Excel Intermediate ONLINE, Thursday 21st January 2027

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: Thursday 21st January 2027

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

Previous
Previous
January 19

Cyber Resilience Training for Directors and Senior Leaders

Next
Next
February 16

Excel Advanced Level - Advanced Formulas & Database Functions - ONLINE