Microsoft Excel Training – Intermediate Course

Cost: Free

Microsoft Excel Training - Level 2 Intermediate Course, Aberystwyth

Join us for this free 1 day Level 2 Intermediate course on Excel.

Course Content:-

Review of Introduction Topics

Recap on topics covered in Introduction.

Custom Formatting

Using Custom Format codes

Positive, Negative, Zero and Text formats

Mixed Referencing

Fixing Rows, Columns or Both when copying formulae

Array Formulae

No more dollar signs!

Array and Dynamic Array Formulae

Grouping and Linking Sheets

Work on multiple sheets at the same time Printing multiple sheets at the same time Link worksheets using formulae.

Link workbooks using formulae. 3D Formulae

Consolidating Data

Naming Cells and Ranges

Correctly create named cells and use names in formulas accurately.

Apply and Manage Named cells

The IF Function

How to correctly construct an IF function and enter data into cells based on a test’s result

How to use nested IF

LOOKUP

How to use VLOOKUP, HLOOKUP and XLOOKUP to find approximate and exact matches

Concatenation

In a single cell, join cell values, text, and formulas into a single value.

Tables

Create and Format Tables Sorting and Filtering Converting to a Range

Analysis

How to use the Quick Analysis feature Turning off this feature.

COUNTIF(S) and SUMIF(S) Functions

Correctly construct the COUNTIF(S) function to COUNT specific values in a range of values.

Correctly construct the SUMIF(S) function to add up specific values in a range of values.

Pivot Tables

Construct and work with a Pivot Table to analysis data. Drilldown on the Data Area.

Use the Layout Options. Use Group and Outline.

Change the Subtotal Function.

Use different functions in the Data Area. Use the “Show Data As” Option.

Using Filters, Slicers, Timelines Pivot Charts

Data Validation

Prevent invalid data being entered into a cell using a “dropdown” list.

Date: Wednesday 1st July 2026

Venue: Aberystwyth

Time: 9.30am - 4.30pm

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

Booking is essential as places are limited.

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.