Advantage Services (Europe) Ltd.
Click to view basket
You have nothing in your shopping basket
   » Home » Sage Training » Microsoft Excel Training » Excel 2007 Stage 1 Contact us  |  Bookmark this page   

Sage training: Microsoft Excel 2007 - Stage 1 Training course description

Microsoft Excel 2007 stage 1 is a one-day course. Our price is £195.00 (Sage's RRP is £270.00). Book today to save with us.Microsoft Excel 2007 stage 1

» Overview: Learn how to get to grips with the basics of Microsoft® Excel 2007

» What do I learn?

It will give you the skills to work more confidently and efficiently with Microsoft® Excel 2007, from data entry and worksheet manipulation to working with formulas and creating charts to analyze your data.

» By the end of this course you will:

  • Know quick methods of navigation and data entry
  • Be able to use the fill handle and create custom lists
  • Learn how to use the table management feature to quickly sort and filter data
  • Know how to simultaneously create, format and link multiple worksheets within the workbook
  • Find out how to attach notes to a spreadsheet using the comments feature
  • Understand how to construct and display formulae including logical functions
  • Understand how to open and navigate multiple files and dynamically link them to produce a consolidation workbook
  • Be able to use the chart wizard to represent your data graphically in your spreadsheet
  • Be familiar with applying page breaks and other print settings

» Detailed course content

Click to see the course content

MS Excel 2007 training course session 1 - Introduction and Navigation

  • Understanding the working environment
  • Worksheet manipulation
  • Custom lists
  • Inserting and formatting cell data
  • Filtering Data

MS Excel 2007 training course session 2 - Basic Table Mangement

  • Table management
  • Controlling worksheet views

MS Excel 2007 training course session 3 - Worksheet Management

  • Creating multiple worksheets
  • Worksheet options
  • Styles and themes
  • Cell comments

MS Excel 2007 training course session 4 - Basic and Conditional Formulas

  • Understanding formula basics
  • Functions
  • Cell referencing
  • Grand totals and outlines
  • Conditional functions

MS Excel 2007 training course session 5 - Consolidating Worksheets and Linking Workbooks

  • Consolidating worksheets
  • Arranging workbooks and worksheets
  • Linking workbooks

MS Excel 2007 training course session 6 - Creating Charts

  • Creating a chart
  • Chart customization
  • Advanced charting techniques

MS Excel 2007 training course session 7 - Printing your Work

  • Page views and page breaks
  • Page setup
  • Custom views

Book now

Select your preferred training centre:
include all training centres
select specific centres from this list:
Birmingham
Bristol
Croydon
Glasgow
Leeds
Manchester
N.London
Newcastle
Reading

Search for Sage training courses
Make big savings on the RRP by booking your Sage training with Advantage Services

If you are planning on booking several days of training, do contact us for even better discounts. Save hundreds off the RRP with us!

Course Centre Start date Duration Total places Available places Book
Microsoft Excel 2007 Stage 1Newcastle30/05/20121 day1211
Microsoft Excel 2007 Stage 1Bristol31/05/20121 day107
Microsoft Excel 2007 Stage 1Leeds11/07/20121 day1211
Microsoft Excel 2007 Stage 1N.London16/07/20121 day1212
Microsoft Excel 2007 Stage 1Birmingham30/07/20121 day1210

Microsoft Excel 2007 stage 1 is a one-day course. Our price is £195.00 (Sage's RRP is £270.00).

You can book your course in several ways:

See all courses on the Sage training home page. You can always contact a Sage training advisor on 0845 009 6566 or by email.

Important notes about booking your Sage classroom training course


  • When booking a course online, if the course is not for the paying cardholder, please enter the name it should be booked for in the notes section when paying.
  • If a vegetarian meal is required instead of the standard meal provided, please enter this in the notes section as well.
  • If a course is showing no availability it is still worth contacting us as there maybe cancellations or the possibility of switching the course to a bigger room.
  • Also note that the number of available places given is updated regularly, but it is not live, so it's always best to ask us for the latest availability if the number of available places is running low.
  • *for all courses except Instant Accounts, which is £215 and Payroll Year End, which is £190.


Other relevant links



   © Advantage Services (Europe) Limited 2012 About us  |  Contact us  |  Terms and conditions  |  Privacy policy  |  Site map