Microsoft® Excel Classroom Training Courses

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, 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 Stage 1 course at a greatly discounted price. Courses are run at one of the 10 official Sage training centres in Birmingham , Bristol , Croydon , Glasgow , Leeds , Manchester , Newcastle , Norfolk , 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 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 Stage 2 course at a greatly discounted price. Courses are run at one of the 10 official Sage training centres in Birmingham , Bristol , Croydon , Glasgow , Leeds , Manchester , Newcastle , Norfolk , 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.