Microsoft® Excel Classroom Training Courses

Get to grips with the basics of Microsoft® Excel 2007 with this classroom training course.

Course Duration: 1 Day Course

What do I learn?
Work more confidently and efficiently with Microsoft® Excel 2007, from data entry and worksheet manipulation to working with formulas and chart creation.

Course Objectives
By the end of this Microsoft® Excel 2007 Stage 1 training 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 an Excel 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 Excel spreadsheet
Be familiar with applying page breaks and other print settings

How do I book?
Site4 can book you onto any of the wide range of Sage training courses provided by Sage experts including the Microsoft® Excel 2007 Stage 1 course at a greatly discounted price. Courses are run at one of the 9 official Sage training centres in Birmingham , Bristol , Croydon , Glasgow , Leeds , Manchester , Newcastle , North London and Reading. *

If you want to book a place (s) on a course please remember to tell us the name of the course, Sage training centre and course date you would like. Once we have received your phone or email booking request we will first check the availability with Sage and then contact you to process the order.

Delivery Format: Classroom Training Course at one of Sage's regional training centres.
* Not all Sage courses are available at every training centre.

Make the most of your Microsoft ® Excel software - This Microsoft ® Excel 2007 Stage 2 classroom training course will enable you to get much more from your spreadsheets with the advanced functionality in Microsoft® Excel.

If you're new to Microsoft® Excel 2007 we recommend you take the Microsoft® Excel 2007 Stage 1 course for before attending this course.

Course Duration: 1 Day Course

What do I learn?
Work more confidently with more complex features in Microsoft® Excel, from advanced formulae and analysing large quantities of data with pivot tables, to creating templates and using macros.

Course Objectives
By the end of this Microsoft® Excel 2007 Stage 2 training course you will:
- Know how to create and edit named ranges
- Know how to use advanced formulae, such as Nested IF, SUMIF and VLOOKUP, 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

How do I book?
Site4 can book you onto any of the wide range of Sage training courses provided by Sage experts including the Microsoft® Excel 2007 Stage 2 course at a greatly discounted price. Courses are run at one of the 9 official Sage training centres in Birmingham , Bristol , Croydon , Glasgow , Leeds , Manchester , Newcastle , North London and Reading. *

If you want to book a place (s) on a course please remember to tell us the name of the course, Sage training centre and course date you would like. Once we have received your phone or email booking request we will first check the availability with Sage and then contact you to process the order.

Delivery Format: Classroom Training Course at one of Sage's regional training centres.
* Not all Sage courses are available at every training centre.

Get to grips with the basics of Microsoft® Excel with this classroom training course.

Course Duration: 1 Day Course

What do I learn?
Work more confidently and efficiently with Microsoft® Excel 2003, from basic formulae and chart creation to sorting data, filtering data and linking worksheets.

Course Objectives
By the end of this Microsoft® Excel Stage 1 training course you will:
- Know quick methods of navigation and data entry
- Be able to use the fill handle and create custom lists
- Understand how to construct and display formulae
- Know how to attach notes to a spreadsheet using the comments feature
- Be able to use the chart wizard to represent your data graphically in your spreadsheet
- Know how to simultaneously create, format and link multiple worksheets within the workbook
- Understand how to open and navigate multiple files and dynamically link them to produce a consolidation workbook
- Know how to sort and filter data
- Know how to apply page breaks and print settings

How do I book?
Site4 can book you onto any of the wide range of Sage training courses provided by Sage experts including the Microsoft® Excel 2003 Stage 1 course at a greatly discounted price. Courses are run at one of the 9 official Sage training centres in Birmingham , Bristol , Croydon , Glasgow , Leeds , Manchester , Newcastle , North London and Reading. *

If you want to book a place (s) on a course please remember to tell us the name of the course, Sage training centre and course date you would like. Once we have received your phone or email booking request we will first check the availability with Sage and then contact you to process the order.

Delivery Format: Classroom Training Course at one of Sage's regional training centres.
* Not all Sage courses are available at every training centre.

Make the most of your Microsoft ® Excel software - This Microsoft ® Excel 2003 Stage 2 classroom training course will enable you to get much more from your spreadsheets with the advanced functionality in Microsoft® Excel.

If you're new to Microsoft® Excel we recommend you take the Microsoft® Excel Stage 1 course for before attending this course.

Course Duration: 1 Day Course

What do I learn?
Work more confidently with more complex features in Microsoft® Excel, from advanced formulae and analysing large quantities of data with pivot tables, to creating templates and using macros.

Course Objectives
By the end of this Microsoft® Excel Stage 2 training course you will:
- Know how to create and edit named ranges
- Know how to use advanced formulae, such as Nested IF, SUMIF and VLOOKUP
- Be able to create pivot tables from raw data and then edit and reformat
- Know how to locate and fix errors in spreadsheet
- Be able to use the chart wizard to modify existing charts and add trend lines
- Know how to automate tasks to ensure accuracy and save time using the macro feature
- Be able to assign macros to buttons and graphics

How do I book?
Site4 can book you onto any of the wide range of Sage training courses provided by Sage experts including the Microsoft® Excel 2003 Stage 2 course at a greatly discounted price. Courses are run at one of the 9 official Sage training centres in Birmingham , Bristol , Croydon , Glasgow , Leeds , Manchester , Newcastle , North London and Reading. *

If you want to book a place (s) on a course please remember to tell us the name of the course, Sage training centre and course date you would like. Once we have received your phone or email booking request we will first check the availability with Sage and then contact you to process the order.

Delivery Format: Classroom Training Course at one of Sage's regional training centres.
* Not all Sage courses are available at every training centre.