Training Catalogue / Automation and Productivity

Spreadsheet Skills

3 modules
6 sessions

Modules

Take single modules or the whole track. Two hour sessions, combined into half days where it suits your calendar.

Foundation · 2 sessions · multi-part

Spreadsheet Essentials

Confident everyday spreadsheets: structure, formatting and core formulas.

  • Structuring a spreadsheet well
  • Formatting for clarity
  • Core formulas and cell references
  • Sorting, filtering and basic charts
Practitioner · 2 sessions · multi-part

Formulas and Functions in Depth

Lookups, logic and text functions that turn a spreadsheet into a tool.

  • Logical functions: IF, IFS and nesting
  • Lookups: INDEX, MATCH and modern equivalents
  • Text and date functions
  • Named ranges and reducing errors
Practitioner · 2 sessions · multi-part

Analysing Data with PivotTables

Summarise and explore real datasets with PivotTables and clear dashboards.

  • Preparing data for analysis
  • Building and configuring PivotTables
  • Summarising, grouping and filtering
  • Simple dashboards that communicate

Teams Often Pair This With

Related modules other teams add alongside this track.

Automation and Productivity · Python Scripting for Automation

Data Wrangling with Python

Clean, reshape and combine messy spreadsheets and data files with Python.

View module

Enquire About This Training

Tell us which modules interest you and we will propose a plan within 24 hours. Choosing Enquire on a module above fills in the subject for you. Add more than one if you like.