FULLY BOOKED - Email info@mwmg.org to express interest in more courses

Microsoft Excel Training - Level 2 Intermediate Course, Brecon

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: 24th September 2024

Venue: Brecon

Time: 9.30am - 4.30pm

Cost: Free to those living or working in Powys

Booking is essential as places are limited. You need to live or work in Powys to be eligible to attend. To reserve your place please book below.

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

‘This project is funded by the UK government through the UK Shared Prosperity Fund.’