This remote 90-minute workshop is aimed at those who are looking to improve their Excel skills. It covers conditional formatting rules, sorting advanced data, advanced formulas and functions as well as additional tips and tricks. Attendees will leave feeling confident in using conditional formatting rules and using advanced functions in Excel, as well as using more advanced features such as pivot tables and data validation.
All staff in all roles are welcome to sign up.
The Excel Foundation Workshop is recommended as a prerequisite to this intermediate workshop.
Conditional formatting rules in Excel
• Colour Scales
• Highlight cells rules
Sorting more advanced data
• Creating and using tables
• Pivot Tables and Custom Lists
• Data validation/ VLOOKUP
Learn how to use advanced formulas and functions in Excel
• Percentages
• Total
• Average
• Highest
• Lowers
• Include date/time formula
• Compare cells (true/ false)
• Using the Formulas tab
• Using data from different sheets within a workbook formula
Formatting Cells
• Currency
• Accounting
• Numbers
• Text
• Date/ time
Tips and tricks
• COUNTA and Unique
• Absolute cell reference
• Named range F3 formulas create from selection
• Paste special formatting – Ctrl alt V
• Flash Fill – Ctrl + E
• Quick Access Toolbar
• Filter
• Freeze panes
• Search bar ‘Tell me what you want to do’
Questions will be taken throughout
Date: Weds 9th April 2025
Time: 10:00-10:30
Location: Virtual
To book your place, please complete the form below.
The protected characteristics monitoring form is separate to the booking button above; completion is optional & anonymous. We ask for information on your ‘protected characteristics’ in order to help us monitor our performance on equality.
If you have already completed this form since April 2024 & nothing has changed, there is no need to complete again.