Microsoft Excel Training Courses Essex

We are a National Microsoft training specialists and can deliver Excel courses at your offices anywhere in Essex.

excel2010-logoHosting Microsoft training at your own premises can work out considerably cheaper than attending public Excel courses. Our low group rates start from just £55 per person – please see our Onsite Training page for full details.

Onsite Excel training at your own offices has several advantages of public courses:

  • More cost effective
  • No wasted travelling time or associated expenses
  • Course content can be tailored to suit your staffs’ requirements
  • Typically smaller class sizes

All our courses are very practical in nature, with delegates using the software continually throughout the day. In this way they build a range of new skills designed to enhance their effectiveness in the office. We deliver Excel training at 3 levels: Foundation, Intermediate and Advanced. Here is a brief overview of each course content:

Foundation Excel

  • Introduction to spreadsheets
  • Overview of Excel menus and toolbars
  • Entering and editing data & text
  • Adjusting column & rows
  • Inserting and deleting columns & rows
  • Selecting & formatting data
  • Copy and pasting data & text
  • Using Auto sum for quick calculations
  • How to build formulas to perform calculations
  • Introduction to Excel functions
  • Printing Excel spreadsheets

Intermediate Excel

  • Excel overview refresher
  • Understanding absolute cell addresses
  • Linking data between workbooks
  • Using advanced formulas & functions
  • Highlighting values with conditional formatting
  • Understanding Conditional Logic: Using IF statements
  • Finding records using VLookup & HLookup functions
  • Creating subtotals & working with levels
  • Sorting data using advanced filters
  • Sorting data using pivot tables and charts
  • Creating and using macros
  • Protecting workbooks, worksheets & individual cells
  • Consolidating data in multiple worksheets & workbooks
  • Data validation: creating drop-down lists
  • Embedding spreadsheets in Word & PowerPoint documents
  • Using charts and graphs to display data

Advanced Excel

  • Advanced Conditional Logic: nested IF, AND, OR & NOT functions
  • The Maths Functions: using SUMIF, COUNTIF & AVERAGEIF
  • New Excel 2007 Functions: using SUMIFS, COUNTIFS & AVERAGEIFS
  • Working with Data: the TRIM, FIND, MID & VALUE functions
  • Finding Data Records: using the MATCH & INDEX functions
  • Advanced Database Functions: the DSUM, DAVERAGE & DCOUNT functions
  • Analytical Tools: using Goal Seek & Scenarios

All of our Microsoft courses can be tailored to suit your own requirements and we also offer a free training needs analysis service.

For more information about onsite Excel training courses in Essex, please contact us below.