Blue Pecan Logo
Office Training
Excel Training Office 2010 Training Project Training Prices Client Feedback Contact
0800 612 4105 mail:
Onsite Microsoft Excel 2007 Training - we come to you!

Microsoft Office Training > Office 2007 Training > Excel 2007 Beginner's

Excel 2007

Excel 2007 Beginner's Course


This 1 day Microsoft Excel course is designed for those who have little or no experience with Microsoft Excel. The course covers training in the basics of formatting, navigation, data entry and calculations. Make sure you are comfortable with the course content before you move on to the intermediate level course. The outline is only a suggestion and can be tailored to your business needs.

To accompany the instructor lead training, each delegate will receive course notes which will provide an excellent source of information and on-going self study once the training has been completed.

To view the Office 2007 shared features topics click here.
To view Excel 2007 upgrade topics click here.

For pricing click here

To return to the application overview page click here

Course Outline
 Formulae Basics
  • Basic calculations
  • Copying formulae
  • Absolute referencing
  • Mixed referencing
  • Naming cells and ranges
  • The new Name Manager
  • Introduction to IF statements
  • Performing calculations with dates and times
  • Resize Formula Bar
  • The chart Ribbon tabs
  • Formatting chart elements
  • Changing the source data
  • Creating a secondary axis
  • Saving a custom chart template
  • Setting a default chart
  • Changing column widths and row heights
  • Formatting cells for different data types
  • Using the new table formatting options
  • Format painter
  • The New Conditional Formatting options
  • New draw border and grid options
  • Setting a print area
  • Getting data to fit the page
  • Headers and footers
  • Printing rows and/or column headers on every page
  • Printing gridlines
  • The New Page Layout View
 Basic List Management
  • Sorting on multiple columns
  • Hiding columns
  • Changing column order
  • Freezing rows and columns
  • Introduction to filters
  • New Total features for filters


Onsite Microsoft Office Training

Microsoft Office Computer Training Courses throughout Surrey, Sussex, Hampshire, Kent, Essex, Berkshire, Buckinghamshire, Dorset, Hertfordshire, Oxfordshire, Wiltshire and London including Crawley, Brighton, Portsmouth, Southampton, Winchester, Farnham, Guildford, Basingstoke, Salisbury, Bournemouth, Poole, Dorchester, Tunbridge Wells, Ashford, Canterbury, Maidstone, Gravesend, Croydon, Kingston-upon-Thames, Reading, Newbury, Oxford, Watford, Hemel Hempstead, Dartford, Stevenage, Milton Keynes, Basildon, Chelmsford, Southend on Sea and Colchester.



Copyright (c) 2013 Blue Pecan. All rights reserved. Sitemap