Cheltenham Tutorials

Excel 365 Advanced Tutorial

Take Excel to the next level with this advanced Excel course.

Sample Video – Using AutoFilter to perform multiple queries

Excel 365 Advanced Course Video Topics

  • One Input Tables
  • Two Input Tables
  • Charts
  • Hyperlinks
  • Linking Objects
  • Embedding Objects
  • Importing Text Files
  • Multi-Level Sorting
  • Custom Sorting
  • AutoFilter
  • Advanced Filters
  • Sub-Totalling
  • Tracking and Reviewing Changes
  • Scenarios
  • Validating
  • Auditing Techniques
  • Comments
  • Macros
  • Passwords and Security Issues
  • Hiding Formulas

You will learn how to:

  • Use input tables
  • Master charts
  • Links and embed objects
  • Import text files
  • Use advanced sorting and filtering
  • Use sub-totalling
  • Track and review changes
  • Use scenarios
  • Validate data
  • Use auditing techniques
  • Use comments
  • Use simple macros
  • Use passwords
  • Hide formulas

Who will benefit from this course:

  • Small business owners.
  • People wishing to master Excel 365 advanced techniques.

Requirements

  • Prior use of Excel.
  • You will need is a computer, Office 365 and an internet connection.

Course duration and access

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