Microsoft Excel Training

Microsoft Excel

Take your Excel skills from basic to confident with our interactive online training series, designed for higher education professionals who need practical, everyday spreadsheet skills. Whether you’re just starting or want to work smarter with data, this hands-on course will guide you through essential formulas, tables, charts, and data analysis tools. Each one-hour session includes live demonstrations, practical exercises, and real-world examples. With a small group size (max 4 participants), you’ll receive personalized support, plus access to session recordings, workbooks, and a completion certificate. Join us and gain Excel skills you’ll actually use!

  • Remote/Online
  • 9 one hour sessions
  • Video recording of the sessions
  • Certificate of completion
  • Data packs for practice
  • Hands on learning
  • Groups of up to 4 per session

Price: £695 £620*

*Single Session pricing available – contact for details

Pre-Reading: Introduction to Excel (document)
  • Overview of Excel: What it is and why it’s useful
  • Basic terminology (workbook, worksheet, cell references, ranges, formulas)
Session 1: Data Entry and Formatting Basics
  • Entering and editing data efficiently
  • Formatting cells (font, alignment, number formats, colours)
  • Using basic formatting tools (bold, italics, borders, fill colours)
  • Adjusting column width and row height
  • Hands-on: Creating a well-formatted table from raw data
Session 2: Introduction to Formulas and Functions
  • Understanding formulas vs. functions
  • Basic arithmetic functions (+, -, *, /)
  • Commonly used functions: SUM, AVERAGE, MIN, MAX
  • Understanding and using AutoFill
  • Hands-on: Creating a small budget calculator using basic formulas
Session 3: Working with Data Tables and Sorting
  • Creating and modifying tables
  • Sorting and filtering data
  • Using Freeze Panes for easier navigation
  • Removing duplicates
  • Hands-on: Organizing a dataset and applying sorting and filtering
Session 4: Intermediate Formulas and Logical Functions
  • Understanding absolute vs. relative cell references ($A$1 vs. A1)
  • Introduction to logical functions: IF, AND, OR
  • Nested IF statements for decision-making
  • Hands-on: Using logical functions for conditional calculations
Session 5: Working with Charts and Visualizations
  • Understanding different chart types (bar, column, pie, line)
  • Creating a simple chart from data
  • Customizing charts (titles, labels, colours, axis adjustments)
  • Hands-on: Building a basic dashboard with charts
Session 6: PivotTables for Data Analysis
  • Introduction to PivotTables: What they are and why they’re useful
  • Creating a PivotTable from a dataset
  • Summarizing and grouping data
  • Using PivotCharts for visualisation
  • Hands-on: Creating and customizing a PivotTable
Session 7: Data Validation and Conditional Formatting
  • Setting up dropdown lists for structured data entry
  • Using conditional formatting for visual emphasis
  • Creating rules based on values (colour scales, icons)
  • Hands-on: Applying conditional formatting to highlight key data trends
Session 8: Working with Large Datasets and Lookup Functions
  • Using Freeze Panes, Split View, and Zoom for easier navigation
  • VLOOKUP and HLOOKUP functions for finding data
  • Introduction to XLOOKUP (if available)
  • Hands-on: Searching for data within a dataset using lookup functions
Session 9: Automation and Efficiency Tools
  • Introduction to named ranges
  • Understanding and using Macros (recording and running)
  • Basic introduction to Power Query for automating data imports
  • Hands-on: Automating a simple repetitive task in Excel

Scroll to Top