Microsoft Excel Training Courses in Yorkshire

Microsoft Excel Training Courses in Yorkshire.We are delivering Microsoft Excel Training Courses in Yorkshire at Foundation, Intermediate & Advanced levels and in all versions from 2000 – 2010. The training is delivered at your own offices anywhere in Yorkshire and we provide all the equipment required to quickly convert any room into an IT training suite for a day. This includes a projector, screen and also laptops if you don’t already have your own. You may wish to take a look at what some of our clients have to say about our training services on the Testimonials page.

Here is a brief overview of the three levels of  Microsoft Excel training courses. Please keep in mind that we can tailor any course to fit your personal training requirements:

Foundation Excel Overview

  • 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
  • Understanding absolute cell references
  • Introduction to Excel functions
    • The SUM function
    • The MIN function
    • The MAX function
    • The Average function
    • The COUNT & COUNTA functions
  • Working with the date and time functions
  • Highlighting data with Conditional Formatting
  • Managing large workbooks (freezing rows, columns & panes etc)
  • Printing workbooks & selected spreadsheet data
  • s

Intermediate Excel Overview

  • Excel overview refresher
  • Linking workbook data
  • Protecting workbooks & cell ranges
  • Advanced conditional formatting techniques
  • Finding data records with VLookups & HLookups
  • Filtering data with the Auto & Advanced filters
  • Macros and their uses
  • Calculating Subtotals and working with Levels
  • Sorting data using Pivot Tables & Pivot Charts
  • Consolidating data in multiple spreadsheets
  • Linking worksheets with 3D formulas
  • Using the Watch Window
  • Data validation & creating drop-down lists
  • Creating and applying custom styles
  • Creating spreadsheet templates
  • Embedding & linking spreadsheets in Word documents & PowerPoint slides

Advanced Excel Overview

  • 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
  • Introduction to the new 2007 Excel functions: SUMIFS, COUNTIFS, AVERAGEIFS
  • Working with data
    • Speeding Data Entry with Excel Forms
    • Tidying the database with the TRIM function
    • Extracting text & data 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

Excel Training Course Prices

Our current onsite training rates are as follows:

  • 1 – 3 learners – £400
  • 4 – 6 learners – £450
  • 7 – 10 learners – £500

These rates are per group, not per person. All prices are + VAT, we do not charge extra for travelling expenses or any other hidden costs. Included in the price are personal Microsoft Excel training manuals, which learners keep as a reference after the course, along with a course certificate.

If you would like further information regarding Microsoft Excel Training Courses in Yorkshire, or indeed anywhere in the UK, please call or phone using the details below.