Microsoft Excel 2010 Training (Intermediate Level)

Other levels, years and dates are available upon request


This course is designed to take current users of Excel and to look at additional functions, such as more advanced formulas, data analysis, charts and database options.

Key Topics

      Recap on Basics

  • Entering & Editing Text & Numbers

  • Basic Formulas



  • Absolute Cells

  • Average, Max, Min, Count

  • Count A, Count If, Sum If, If Statements, Nested If Statements, If And / If Or

  • Linking Calculations

  • VLookup and HLookup



  • Inserting, Deleting, Moving, Copying, Grouping Worksheets

  • Hiding Columns & Rows

  • Freeze Panes

  • Split Screen



  • Using Pre Set Templates

  • Designing Your Own Template


      Range Names

  • Creating/Using/Editing a Range Name



  • Printing Areas

  • Rows to Repeat at the Top

  • Page Breaks


      Data To/From Other Applications

  • Paste Linking/Special



  • Creating a Table

  • Table Styles

  • Sorting & Filtering Information

  • Advanced Filtering

  • Subtotals 

  • Price: £225.00
  • Duration: 1 Day
  • Start Time: 9.30am
  • End Time: 4.30pm

Book Your Place

Please choose one of the following date(s)/locations that you would like to attend.

Courses in Dudley

Day 1  
24th May 2018 Book