Skip to content
Microsoft Excel Intermediate course background

Microsoft Excel training courses

Build confidence and save hours on spreadsheets with tailored Microsoft Excel training courses. Whether you are a complete beginner or an experienced user, our hands-on courses cover everything from essential functions to advanced formulas, pivot tables, financial analysis, and data visualisation.

Led by Microsoft Certified Trainers, our corporate Excel training fits flexibly around your team:

  • All Skill Levels Covered: Progress from Excel Introduction and Excel Intermediate to Excel Advanced and Excel Super User.
  • Flexible UK Delivery: Book bespoke onsite Excel training at your offices anywhere in the UK, or join interactive live online classes.
Microsoft Excel Intermediate course logo

Microsoft Excel Intermediate course

1 day

This Microsoft Excel Intermediate course looks at some of the more sophisticated features needed to simplify (and speed up) working with large amounts of data in terms of formatting, formulae and security.   You will also learn how to analyse data sets quickly with tools such as sort, filter and pivot tables.

Download PDF Book now

What will you learn?

At the end of this Microsoft Excel Intermediate course, delegates will be able to take advantage of Excel’s features to better manage and protect their spreadsheets and to analyse data quickly and efficiently.

Audience?

Anyone needing to move to the next stage of Excel mastery and save time by using features including 3d formulae, data handling and working with large sheets.

Course Contents

3d Worksheets

  • Copy, Move, Rename, Hide worksheets
  • Group editing and formatting
  • 3d calculations & 3d Autosum

Linking Workbooks

  • View multiple sheets, on screen, simultaneously
  • Creating & Managing links

Range Names

  • Why use them?
  • Assigning names
  • Using names (in formulae and Go To)
  • Named constants

Data Validation

  • Controlling data entry
  • Customising messages and Error alerts
  • Creating Drop-down Lists (with range names)

Protection

  • Adding passwords to files
  • Protecting cells from being altered
  • Go To function for cell selection

Working with Data

  • Highlighting data blocks quickly
  • Sorting – Quick sort, multi field sort, colour sort
  • Autofilter
    • Using logical parameters
  • Subtotals – to summarise data

Pivot Tables / Charts

  • Understanding how they work
  • Manual report v Quick report
  • Adding & Moving fields
  • Summary functions inc. %
  • Formatting fields and reports
  • Filtering data
  • Charts
  • Editing and changing data
  • Refreshing data
  • Slicers

Sparklines

Tick Boxes

Course Materials

Enliten IT will provide each delegate with a pdf workbook and other useful reference materials where applicable.

“"Excellent session made fun!"”

Liz, Cashflows, Excel Intermediate

Prerequisites

This course assumes attendance of our Microsoft Excel Introductory course (or equivalent knowledge).

Additional Information

To ensure our IT training stays up-to-date with the latest industry standards, Enliten IT may update course content and training materials at any time without prior notice.

The suggested course duration is a guideline.   Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.