Microsoft Excel Onsite Training Courses

Excel Course Levels and Duration

We can provide training on all versions of Microsoft Excel at Foundation, Intermediate & Advanced levels. All courses are 1 day in duration, delivered onsite at your own offices from 10am – 4pm.

Laptops Provided

Laptops can also be supplied where required for a small daily rate of £15 each, so you can use virtually any office for your Excel training.

Free Training Needs Analysis

We offer a complimentary Training Needs Analysis service to make it easy to select the right level of training for your staff. Please call 0800 9055142 for more details, or complete the short enquiry form on our Contact page.

Tailor Made Training

Please let us know if you don’t see the topics you require in the content overviews below. We will be happy to customise a course to meet your specific requirements. You can read what clients say about our training services on our Reviews page.

Microsoft Excel Foundation 1 Day Course

The Course Includes:

  • Introduction to spreadsheets
  • Overview of the Excel menus and toolbars
  • Entering & editing data and text
  • Saving workbooks
  • Formatting spreadsheet data & text
  • Calculating using AutoSum
  • Modifying spreadsheet (resizing & inserting columns, rows etc)
  • Constructing basic formulas
  • Copying formulas
  • Introduction to Graphs & Charts
  • Introduction to Excel functions
    • The SUM function
    • The MIN function
    • The MAX function
    • The Average function
    • The COUNT & COUNTA functions
  • Managing large workbooks (freezing rows, columns & panes etc)
  • Printing workbooks & selected spreadsheet data

Microsoft Excel Intermediate 1 Day Course

The Course Includes:

  • Excel overview refresher
  • Understanding Absolute Cell References
  • Linking workbook data with 3D formulas
  • Working with Tables and Named ranges
  • Protecting workbooks & cell ranges
  • Working with the date and time functions
  • Highlighting data with Conditional Formatting
  • Finding data records with VLookups & HLookups
  • Filtering data with the Auto & Advanced filters
  • Calculating Subtotals and working with Levels
  • Sorting data using Pivot Tables & Pivot Charts
  • Data validation & creating drop-down lists
  • Consolidating data in multiple spreadsheets
  • Using the Macro Recorder

Microsoft Excel Intermediate+ 1 Day Course

The Course Includes:

  • Working with Excel Tables to make filtering & analysing data easier
  • Developing PivotTable skills with more columns and bigger spreadsheets
  • How to achieve more by nesting functions such as IF, AND and OR
  • More on the use of Conditional Formatting, including the use of Icon Sets
  • Further methods of sorting data by values, cell colours, font colours and icons
  • How to consolidate and total data across multiple worksheets and workbooks
  • Visualising trends in data using graphs and charts, including PivotCharts
  • How to manipulate and rearrange text data in Excel
  • Rearranging spreadsheet data using the handy Transpose function
  • Searching databases more effectively using the Index and Match functions
  • How to easily perform  calculations on multiple values using the Array functions

Microsoft Excel Advanced 1 Day Course

The Course Includes:

  • Using the maths & statistical functions
    • The SUMIF function
    • The COUNTIF function
    • The AVERAGEIF function
    • The SUMIFS function
    • The COUNTIFS function
    • The AVERAGEIFS function
  • Working with text data
    • Tidying the database with the TRIM function
    • Extracting text using FIND and MID functions
    • Using the VALUE function
  • Working with advanced database functions
    • The DSUM function
    • The DAVERAGE function
    • The DCOUNT function
  • Creating a Dashboard with PivotCharts & Slicers
  • Using Goal Seek
  • Creating & merging Scenarios