Back to All Events

Microsoft Excel Training – Level 3 Advanced Course Brecon

Microsoft Excel Training - Level 3 Advanced Course, Brecon

Join us for this free 1 day Level 3 Advanced course on Excel.

Course Content:-

Review of Intermediate Topics

Recap on topics covered in Intermediate level.

Subtotals

Create single and multiple Subtotals.

Conditional Formatting

Use conditional formatting to compare data ranges Use functions within conditional formatting Format entire rows of data rather than single cells.

IF revisited

Using AND and OR functions The IFS function

Database Functions

DSUM, DAVERAGE, DMAX, DMIN, DCOUNT

Using Criteria Range with AND/OR conditions.

Text Functions

Joining Strings (CONCAT, TEXTJOIN, &)

String Manipulation (LEFT, RIGHT, MID, PROPER, UPPER, LOWER, CLEAN, TRIM)

Extracting Strings (FIND, SEARCH, TEXT, ISNUMBER)

Date Functions

Date Calculations (NOW, TODAY, DATE, MONTH, YEAR, EOMONTH, WORKDAY)

Advanced Lookup Functions

Error handling (IFERROR, ISERROR, ISNA) Using the MATCH function

Two-way Lookup. Three-way Lookup INDEX and MATCH

Data Validation

Validate using Number and Text restrictions. Lists using Dynamic Arrays

Custom Validation – Advanced Formulae to validate entries.

Create Dependent drop-down lists (one list depends on another list for its source)

Date validation rules

Scenario Manager

Create one or more Scenarios to give ‘What If’ analysis.

Protecting a Workbook/Worksheet

Prevent changes to the structure of a workbook Prevent changes to cells in a worksheet

Tables

Structured Referencing.

Dynamic Array Functions

FREQUENCY, UNIQUE, SEQUENCE, TRANSPOSE

Use SUMIFS with Dynamic Arrays Dynamic Array Operators (AND/OR)

Recording a Macro

Introduction to Recording an Excel Macro.

Date: Tuesday 29th October 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.’

Previous
Previous
October 29

Effective Purchasing Skills - Newtown

Next
Next
October 30

Effective Storekeeping/Warehouse Training course - Newtown