About the Course

This course builds on foundational Excel knowledge, focusing on automation, data linking, advanced functions, and enhanced data visualization techniques. Delegates will learn how to streamline workflows, apply powerful formulae, and utilize Excel’s advanced analytical tools for improved efficiency.

Course Content

Automating a Workbook

• Linking sheets and workbooks using group functions
• Password-protecting sheets, specific sections, and entire workbooks
• Saving workbooks as templates

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

Conditional Formatting

• Applying conditional formatting for cells and ranges
• Editing icon and colour scale formats
• Using formulae within conditional formatting

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

Advanced Charts

• Creating charts with two axes
• Using map charts for geographical data
• Creating waterfall charts for financial analysis

Audience Profile

This course is designed for professionals who have a basic understanding of Excel and want to develop their skills further. Ideal for individuals who need to automate workbooks, work with advanced formulas, and create complex visual reports to improve data handling and analysis.