Training Catalogue / Automation and Productivity

Spreadsheet Skills

Spreadsheet Skills

3 modules 12 hours taught

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 Open the form. We will propose a plan within 24 hours.

The subject is filled in for you. Choosing Enquire on a module above sets it to that module. Add more than one if you like.