Microsoft Excel Onsite Courses

We can provide training on all versions of Microsoft Excel from Office 2003 onward. Below is an overview of each course level content; in most cases the topics covered will be the same irrespective of the version. However, at Advanced level there are a number of features & functions which are only available on newer versions as indicated.

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 advanced functions
    • Conditional Logic: using the IF function
    • Using Not, AND, OR functions
    • Nested IF functions
    • The IFERROR function
  • Using maths & statistical functions
    • The SUMIF function
    • The COUNTIF function
    • The AVERAGEIF function
    • The SUMIFS function (2010+ only)
    • The COUNTIFS function (2010+ only)
    • The AVERAGEIFS function (2010+ only)
  • 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 (Slicers 2010+ only)
  • Using Goal Seek
  • Creating & merging Scenarios

Blended Courses

If you have a number of employees at different levels, it is often possible to deliver a ‘blended’ course. Our free Training Needs Analysis service will enable us to advise on the correct level of training for each person and where appropriate recommend a blend of topics. Please call 0800 9055142 for more details, or complete the short enquiry form on our Contact page.