Microsoft Excel training by Sage stage 2

   » Home » Sage Training » Classroom Training » Excel Stage 2 Contact us  |  Bookmark this page   

Sage training: Microsoft Excel - Stage 2 Training course description


Microsoft Excel stage 2 is a one-day course. Our price is £130.00 (Sage's RRP is £265.00). Book today to save with us.Microsoft Excel stage 2

» Overview: Get much more from your spreadsheets with the advanced functionality of Microsoft® Excel. NB the course is taken on Excel 2003 (version 11)

» 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.

» By the end of this course you will:

  • Know how to create and edit named ranges
  • Know how to create templates
  • 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 spreadsheets
  • Know how to automate tasks to ensure accuracy and save time using the macro feature
  • Be able to assign macros to buttons and graphics

Who should attend? Anyone who wants to utilise the more advanced features within Excel.

Important Note: although this course uses data which has been exported from Sage Line 50 into Microsoft Excel, it does not seek to show how to perform the export function (i.e. the linking process). Customers who wish to learn how to link the two software programs should attend the Linking Microsoft Office With Sage course.

Book now


Which training centres to include in the results? Either include all training centres, OR select specific centres from this list: (check the boxes as appropriate)   Birmingham     Bristol     Croydon     Glasgow     
Leeds     Manchester     N.London     Newcastle     Reading     

 Refresh search 

Course Centre Start date Duration Total places Available places Book
MS Excel Stage 2Manchester18/03/20101 day120
MS Excel Stage 2Reading24/03/20101 day121
MS Excel Stage 2Bristol31/03/20101 day100
MS Excel Stage 2Glasgow31/03/20101 day1210
MS Excel Stage 2Newcastle22/04/20101 day128
MS Excel Stage 2Croydon28/04/20101 day121
MS Excel Stage 2Leeds29/04/20101 day121
MS Excel Stage 2Reading06/05/20101 day127
MS Excel Stage 2Birmingham07/05/20101 day1210
MS Excel Stage 2Glasgow14/05/20101 day1212
MS Excel Stage 2Manchester19/05/20101 day124
MS Excel Stage 2N.London28/05/20101 day126
MS Excel Stage 2Bristol04/06/20101 day108

Microsoft Excel stage 2 is a one-day course. Our price is £130.00 (Sage's RRP is £265.00).

You can book your course in several ways:

  • Online: Just click the "Book now" button (your payment will only be processed after we have booked your course with Sage).
  • Phone: Just call 0845 641 0624 to pay by card or arrange BACS or cheque payments.
  • Use the contact form: Click here and fill out the contact form.
To review other courses see the classroom course list and you can always contact a Sage training advisor on 0845 641 0624 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.


Detailed course content


Click to see the course content


Microsoft Excel training course session 1 - Creating Pivot Tables

  • Creating a PivotTable
  • Adding Fields to a Pivot Table
  • Changing the PivotTable Layout
  • Removing Fields from a PivotTable
  • Updating a PivotTable

Microsoft Excel training course session 2 - Pivot Table Enhancements

  • Rearranging a PivotTable
  • Grouping and Hiding Data
  • Renaming Fields
  • Creating Calculations within a Pivot Table
  • Formatting Fields within a PivotTable Table
  • Formatting a Pivot Table

Microsoft Excel training course session 3 - Working with Templates, Passwrods and File Preview

  • Creating a Template based on a New Workbook
  • Creating a Template based on an Existing Workbook
  • Editing a Template
  • Working with Templates
  • Protecting Worksheet Elements

Microsoft Excel training course session 4 - Named Ranges

  • Creating Individual Named Range
  • Creating Adjacent Named Ranges
  • Editing Named Ranges
  • Deleting Named Ranges

Microsoft Excel training course session 5 - Mathematical, Statistical, Logical and Time Functions

  • The CountIf Function
  • The SumIf Function
  • The And Function
  • The Or Function
  • Nesting Functions
  • Calculating Time

Microsoft Excel training course session 6 - Lookup Functions, Data Validation and Auditing

  • The VLookup Function
  • The HLookup Function
  • Data Validation
  • Auditing the Workbook

Microsoft Excel training course session 7 - Creating and Assigning Basic Macros

  • Macro Security
  • Relative and Absolute Macros
  • Recording a Macro
  • Editing and Deleting a Macro
  • Creating a Toolbar
  • Adding a Macro to a Toolbar Button
  • Creating a Menu
  • Adding a Macro to a Menu Item


Other relevant links




Footnote: Your investment in Sage training


We are the number one Sage training partner in the UK. We provide quality training and can give you the most appropriate training programme. We'll get you where you want to be as soon as possible, and we get it right first time.

Click to see the footnote

Training is an incredibility important investment. Having the right job skills in the right areas of your business is key to success in today's competitive market. An investment with Advantage Services will actually save you money as well-trained employees are less likely to make costly mistakes. Not only will you be gaining fabulous skills for your CV, but it will help improve your business's productivity, profitability and competitive advantage.

Get ready to experience the UK's top tuition with Advantage Services and start working effectively and trouble-free. Contact an advisor for more information and make a booking today.



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