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

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

Microsoft Excel 2007 stage 2 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 2

» Overview: Get much more from your spreadsheets with the advanced functionality of Microsoft® Excel.

» What do I learn?

It will give you the skills to work confidently with more complex features in Microsoft® Excel 2007. From advanced formulae and analysing large quantities of data with pivot tables, to creating templates and using macros.

» By the end of this course you will:

  • Know how to create and edit named ranges
  • Be able to use advanced formulae, such as SUMIF,VLOOKUP and INDEX, as well as nest different functions together
  • Learn about data validation and conditional formatting
  • Know how to spot errors in your workbooks using the auditing tool
  • Be able to create pivot tables from raw data and then edit and reformat
  • Learn about protecting your work and share your files with colleagues
  • Know how to automate tasks to ensure accuracy and save time using macros

» Detailed course content

Click to see the course content

MS Excel 2007 training course session 1 - Named Ranges

  • Advantages of named ranges
  • Creating named ranges
  • Navigating using named ranges
  • Managing named ranges
  • Displaying named ranges
  • Filtering Data

MS Excel 2007 training course session 2 - Conditional Functions

  • Function operators
  • Counting functions
  • Summing functions
  • Logical functions
  • Nesting functions

MS Excel 2007 training course session 3 - Lookup and Reference Functions

  • The VLOOKUP function
  • The HLOOKUP function
  • The MATCH and INDEX functions

MS Excel 2007 training course session 4 - Specialist Tools

  • Data validation
  • Conditional formatting
  • Go To Special
  • Workbook auditing

MS Excel 2007 training course session 5 - Using Pivot Tables

  • Creating and editing a pivot table
  • Advanced techniques
  • Pivot charts

MS Excel 2007 training course session 6 - Templates, Protection and workbook sharing

  • Templates
  • Protecting your work
  • Sharing workbooks

MS Excel 2007 training course session 7 - Macros

  • The Developer tab and macro security
  • Creating macros
  • Editing and deleting macros
  • Assigning macros

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 2N.London29/05/20121 day126
Microsoft Excel 2007 Stage 2Newcastle31/05/20121 day129
Microsoft Excel 2007 Stage 2Bristol01/06/20121 day107
Microsoft Excel 2007 Stage 2Leeds12/07/20121 day1211
Microsoft Excel 2007 Stage 2N.London17/07/20121 day1211
Microsoft Excel 2007 Stage 2Birmingham31/07/20121 day1211

Microsoft Excel 2007 stage 2 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