Cheltenham Tutorials

Excel 365 Intermediate Tutorial

Go beyond the basics with the Microsoft Excel 365 spreadsheet program.

Sample Video – Conditional Formatting

Excel 365 Intermediate Course Video Topics

  • Setup and Viewing Options
  • Functions and Formulas
  • Time & Date Functions
  • Mathematical Functions
  • Logical Functions
  • Mathematical Functions
  • Statistical Functions
  • Financial Functions
  • Lookup Functions
  • Database Functions
  • Named Ranges
  • Cell and Range Formatting
  • Advanced Worksheet Manipulation
  • Templates
  • Paste Special Options
  • Proofing and Printing

You will learn how to:

  • Customise Excel setup and viewing options
  • Use Excel Time and Date functions
  • Use Excel Mathematical functions
  • Use Excel Logical functions
  • Use Excel Statistical functions
  • Use Excel Financial functions
  • Use Excel Lookup functions
  • Use Excel Database functions
  • Manipulate named ranges
  • Create and apply templates
  • Use Paste Special options

Who will benefit from this course:

  • Small business owners.
  • Anyone wishing to learn about Excel in more detail.


  • A basic knowledge of using Excel is required.
  • You will need is a computer, Microsoft Office 365 and an internet connection.

Course duration and access

  • 22 Training videos
  • Total of 81 mins training
  • One year’s access to the training videos
  • View on a mobile phone, tablet or laptop

Scroll to Top