Excel Intermediate, Llandrindod Wells, 19th April 2023 - FULLY BOOKED
The Excel Intermediate level covers more complex formulas and functions, data analysis, next generation functions, improved conditional formatting features, advanced analysis tools, lookup functions and filtering options.
Course Content:-
Absolute cell references
Naming cells and ranges
Referring to named cells and ranges
Editing named cells and ranges
Datatypes
Setting up workbooks with group editing
Using VLOOKUP & HLOOKUP statements
Editing lookups and ensuring accuracy
Linking spreadsheets and workbooks
Utilising 'If' statements
XLOOKUP
If statements and calculations
Analysing data with conditional formatting
Content Databases in Excel
Sorting data numerically and alphabetically
Filtering data for range & precision analysis
Setting up data validation
Attaching security to a spreadsheet
Selective protection
Setting up and utilising templates
Creating and formatting charts
Adding trend lines to the chart
Utilising custom chart types
Cost: Free to attend
Date: Wednesday 19th April 2023
Venue: Llandrindod Wells
Course Delivery: This course will be delivered by Computer Training Wales
Book online using the booking form below, call 01686 628778 or email sam@mwmg.org