giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Excel 2010 Intermediate
 
   
 
Microsoft Excel 2010 Intermediate
 
Target Audience:  

Users who already have some experience of using Excel who need to create spreadsheets which include calculations, multiple sheets and charts.

 
   
Objectives:  

By the end of the course users will be able to create multiple sheet Workbooks, use logical functions, sort, filter and subtotal data.  Users will also be able to present data in a graphical format.

 
   
Prerequisites:  

Users need to be able to design and create simple spreadsheets which include basic formulae and the use of AutoSum.  They should also be able to use simple formatting tools and use cut, copy and paste effectively

 
   
 
       
     
  Duration: 1 Day
  Cost: £150 + VAT
     
 
  Course Date Location
  01/12/2017 Bradford
  11/12/2017 Liverpool
  17/01/2018 Bradford
  18/01/2018 Barnsley
  09/02/2018 Bradford
  26/02/2018 Liverpool
  05/03/2018 Doncaster
  06/03/2018 Bradford
  22/03/2018 Barnsley
  16/04/2018 Bradford
  18/04/2018 Liverpool
  04/05/2018 Barnsley
  21/05/2018 Bradford
  06/06/2018 Liverpool
  11/06/2018 Doncaster
  22/06/2018 Bradford
More Formulae & Functions Charting Essentials  
  • Logical 'IF' Functions

  • Using Dates in Calculations

  • Calculating Percentages

  • Naming Cells & Ranges
  • Creating Charts & Graphs

  • Formatting Charts

  • Modifying the Chart Layout

  • Adding & Removing Chart Elements

  • Working with Pie Charts

  • Previewing & Printing Charts

 
Working with Multiple Worksheets        
  • Moving Between Worksheets

  • Inserting, Deleting & Renaming Worksheets

  • Moving & Copying Worksheets

  • Using Group Editing

  • Entering Formula Across Worksheets

 
Worksheet Customisation
  • Conditional Formatting
  • Password Protecting a File
  • Protecting Sheets & Cells
 
   
Data List Essentials
  • Introducing Data Lists
  • Splitting a Worksheet into Panes
  • Freezing Worksheet Titles
  • Sorting a List of Data
  • Filtering Data Using Autofilter
  • Using Automatic Subtotals
  • Working with Excel Tables