Microsoft Excel training by Sage stage 2

   » Home » Sage Training » Microsoft Excel 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.

» 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

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 2Reading14/09/20101 day103
MS Excel Stage 2Glasgow21/09/20101 day128
MS Excel Stage 2N.London21/09/20101 day123
MS Excel Stage 2Manchester28/09/20101 day126
MS Excel Stage 2Bristol30/09/20101 day100
MS Excel Stage 2Newcastle13/10/20101 day129
MS Excel Stage 2Leeds15/10/20101 day1212
MS Excel Stage 2Croydon20/10/20101 day100

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.
See all courses on the Sage training home page. 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.


Other relevant links




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