Module 1: Formula tools and techniques
- Quick Analysis
- Absolute and mixed referencing
- Working with range names
- Linking to other worksheets
- Linking to external workbooks
Module 2: Popular Excel functions
- Understanding functions
- Criteria-based functions
- Logical functions
- Lookup and reference functions
- Dynamic array functions
Module 3: Working with data lists
- Flash fill
- Checkboxes*
- Advanced sorting
- The FILTER function*
Module 4: Mastering Excel tables
- Introducing tables
- Creating and managing tables
- Calculation and totals in tables
- Formatting a table
- Further table tools
Module 5: Creating Visuals
- Understanding charts
- Creating a chart
- Resizing and moving
- Managing a chart
- Working with chart elements
- Formatting charts
- Working with chart templates
- Creating maps from Geographic data
- Creating Infographics with Excel add-ins**
- Analyze data with sparklines
Module 6: Conditional formatting
- Applying and managing conditional formatting
- Creating custom conditional formatting
- Sorting and filtering by color
Exams and assessments
There is no formal exam or certification associated with this course. Learner progress is assessed through instructor-guided activities, practical exercises, and independent tasks completed during the course. These activities allow delegates to apply the techniques covered and check their understanding in realistic Excel scenarios.
Hands-on learning
This course includes hands-on practice throughout, with a mix of trainer-led demonstrations, guided exercises, and independent tasks. Delegates will work with realistic Excel scenarios and can apply their learning to one of seven sector-based contexts: Retail, Education, Local Government, Legal, Policing, Healthcare, or Finance.
