-
Duration: 1 day
Price: £195 (exc. VAT)
Search
Contact
Apprenticeship Vacancies
Make an enquiry
Search
Contact
Apprenticeship Vacancies
Training participants will learn the essential skills needed to confidently navigate Excel, manage data, perform basic calculations, and format workbooks effectively for professional use. Higher level courses are ideal for individuals who use Excel as a powerful analysis tool, working with advanced functions, automation tools, and data validation techniques, all designed to improve data handling and analysis.
Module 1: Automating a workbook
• Linking sheets and workbooks using group functions
• Password-protecting sheets, specific sections, and entire workbooks
• Saving workbooks as templates.
Module 2: Working with data and formatting
• Using Paste Special and linking data into Word or PowerPoint
• Naming cells and ranges for improved formula management
• Implementing named ranges in formulae
• Editing array formulas
• Understanding spill error messages.
Module 3: Conditional Formatting
• Applying conditional formatting for cells and ranges
• Editing icon and colour scale formats
• Using formulae within conditional formatting.
Module 4: Excel Functions
• Logical functions: IF, IFS, IFERROR
• Lookup functions: LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP
• Mathematical functions: SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS
• Date functions: TODAY, NOW, DAY, MONTH, YEAR
• Advanced functions: FILTER and TAKE.
Module 5: Advanced Charts
• Creating charts with two axes
• Using map charts for geographical data
• Creating waterfall charts for financial analysis.
Learn how to:
This course is designed for professionals who have a basic understanding of Excel and want to develop their skills further. The course builds on foundational Excel knowledge, focusing on automation, data linking, advanced functions, and enhanced data visualisation techniques.