Skip to main content

Microsoft Excel

We can provide Microsoft Excel training programmes from beginner through to intermediate and advanced level. Please see below for an indication of what's included in each course and contact us for advice regarding your particular requirements.


Beginner: 4 hours

Who is it for: those who have very little or no knowledge of Microsoft Excel
  • Basics of data entry
  • Basics of formatting
  • Simple calculations and underlying concepts

Intermediate: 2 days

Who is it for: those who have some knowledge of Microsoft Excel but want to know how to use the application more effectively 
  • Basic formatting
  • Functions, eg MAX, MIN, AVERAGE, COUNT, COUNTIF, COUNTA, SUMIF, IF, LEFT, CONCATENATE
  • Importing .csv files
  • Applying conditional formatting
  • Use the Paste Special tool
  • Understand absolute cell references
  • Work between sheets
  • Lock and protect cells
  • Crating pivot tables
  • Creating and using validation rules
  • Creating charts

Advanced: 1 day

Who is it for: those who already use Microsoft Excel extensively in their work and want to be able to utilise more advanced functions
  • Pivot tables and pivot charts
  • Various functions to analyse and manipulate data
  • VLOOKUP and HLOOKUP
  • Nested functions
  • Subtotals
  • Data validation
  • Advanced filters
  • Goal seek and scenarios
  • Simple macros

For further details or to book a course, please contact us via our online form, call our team on 01432 383500 or email training@hoopleltd.co.uk. You may also search for upcoming open courses on CPD Online.