Premier Home Page

Home | Training | Solutions |Contact Us

t: +44(0)20 7729 1811

About Us | IT Training | Financial Training | Management Training |Delegate Information

This course provides an overview of the redesigned user interface and interactive features of Microsoft Office Excel 2007. This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Excel, ideally Microsoft Excel 2003, and who have or are planning to upgrade to Microsoft Excel 2007.


Access training courses in London & UK
Access Training in London

Next Scheduled Course Date

Module 1: The new look & Feel of Microsoft Excel 2007

  • Changes to the interface
  • Using the Office button
  • Working with the ribbon
  • Understanding tabs, groups and commands
  • Using contextual tabs
  • Using the quick access toolbar
  • Using the mini toolbar
  • Customising the environment
  • Using zoom
  • Creating new worksheets
  • New page layout view

Module 2: Working with Data

  • Increased capacity
  • Improved formula creation
  • Using tables
  • Improved sorting and filtering
  • Enhancements to PivotTables

Module 3: Formatting Spreadsheets

  • Live previews of formatting
  • Using themes
  • New conditional formatting

Module 4: Using the Enhanced Drawing Tools

  • Using SmartArt graphics
  • Using the new charts

Module 5: Saving Spreadsheets in Excel 2007

  • Different Excel file formats
  • Understanding compatibility between different versions
  • Using the document inspector to remove 'metadata'

Module 6: SharePoint Integration

  • Discussion of how Excel 2007 integrates with SharePoint

Microsoft Gold Partner

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412