giving people the skills to succeed  
search our website
Courses > IT Courses > What's New in Microsoft Excel 2010
 
   
 
What's New in Microsoft Excel 2010
 
Target Audience:  

Current users of a previous version of Microsoft Excel who are upgrading to Microsoft Office 2010.

 
   
Objectives:  

By the end of the course users will be familiar with the layout of Excel 2010 and be able to use new and improved features to create, format and analyse data in a spreadsheet.

 
   
Prerequisites:  

Users should have a sound working knowledge of a previous version of Microsoft Excel and be able to perform commands such as calculating data using functions, sorting, filtering and formatting data.

 
   
 
       
     
  Duration: Half Day
  Cost: £125 + VAT
     
 
  Course Date Location
     
Demand led
Call to request dates
     
     
         

Microsoft Excel 2010

  • The Excel Screen & Views

  • Creating New Workbooks

  • Formatting Spreadsheets using Themes

  • Working with Conditional Formatting

  • Using Data Visualisations

  • New Formatting Rules

  • Working with the Rules Manager

 

Sorting and Filtering

  • Sorting by Single or Multiple Columns

  • Identifying & Creating Custom Filters

  • Filter By Colour

  • Removing Duplicate Entries

 

Formulae, Functions & Naming

  • Working with Formula

  • AutoComplete

  • Working with Functions

  • Naming Ranges

  • Working with the Range Manager

   

What’s new with Charts & Pivots?

  • Creating & Modifying Simple Charts

  • Inserting Sparklines

  • Building a PivotTable

  • Filter Slices

 

Headers, Footers & Page Layout

  • Headers & Footers

  • Page Layout View & Print Preview