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.’