Microsoft Excel 2010 Training (Intermediate Level)

Other levels, years and dates are available upon request

Overview

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

 

      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

 

      Worksheets

  • Inserting, Deleting, Moving, Copying, Grouping Worksheets

  • Hiding Columns & Rows

  • Freeze Panes

  • Split Screen

 

      Templates

  • Using Pre Set Templates

  • Designing Your Own Template

     

      Range Names

  • Creating/Using/Editing a Range Name

 

      Printing

  • Printing Areas

  • Rows to Repeat at the Top

  • Page Breaks

 

      Data To/From Other Applications

  • Paste Linking/Special

 

      Tables

  • 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  
22nd November 2017 Book  
15th February 2018 Book  
24th May 2018 Book