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: Tuesday 7th May 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.’