Microsoft Excel training by Sage stage 1

   » Home » Sage Training » Microsoft Excel Training » Excel Stage 1 Contact us  |  Bookmark this page   

Sage training: Microsoft Excel - Stage 1 Training course description


Microsoft Excel stage 1 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 1

» Overview: Getting to grips with the basics of Microsoft® Excel. NB the course is taken on Excel 2003 (version 11)

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

» By the end of this 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
  • Be familiar with applying page breaks and print settings

Who should attend? Anyone who wants to develop "self-taught" skills, to become efficient and highly effective users of the program. Although the course is aimed at anyone who uses Excel on a regular basis, it may be especially useful to Sage users who currently export data out of Sage software and into 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

MS Excel training course by Sage session 1 - Toolbars, Shortcuts and Arranging Data

  • Toolbar Manipulation
  • Worksheet and Data Manipulation
  • Inserting Ranges
  • Moving and Copying Cells
  • Finding and Populating Blank Cells
  • Controlling Worksheet Views
  • Sorting a Range
  • Filtering Data

MS Excel training course by Sage session 2 - Fill Handle and Custom Lists

  • Copying Data with the Fill Handle
  • Custom Lists

MS Excel training course by Sage session 3 - Formula Creation, Sub and Grand Totals, Match and Concatenate

  • Cell References
  • Functions
  • Auto Calculate

MS Excel training course by Sage session 4 - Absolute Cell Reference and IF Statement

  • Absolute Cell Reference
  • Working with Conditional Formulas

MS Excel training course by Sage session 5 - Effective Workbook Management

  • Selecting and Deselecting Worksheets
  • Changing Tab Colours
  • Renaming Worksheets
  • Creating a 3D Formula
  • Comments

MS Excel training course by Sage session 6 - Linking Workbooks

  • Multiple Workbooks
  • Opening Multiple Workbooks
  • Working in a Multi Workbook Environment
  • Updating Links

MS Excel training course by Sage session 7 - Creating and Editing Charts

  • To Create a Chart using the Chart Wizard
  • Enhancing a Chart
  • Removing Data Ranges

MS Excel training course by Sage session 8 - Applying Page Breaks and Print Settings

  • Setting and Clearing a Print Area
  • Page Break Preview
  • Applying Print Options

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 1Reading13/09/20101 day108
MS Excel Stage 1Glasgow20/09/20101 day1210
MS Excel Stage 1N.London20/09/20101 day120
MS Excel Stage 1Manchester27/09/20101 day126
MS Excel Stage 1Bristol29/09/20101 day100
MS Excel Stage 1Newcastle12/10/20101 day1212
MS Excel Stage 1Leeds14/10/20101 day1210
MS Excel Stage 1Croydon19/10/20101 day105

Microsoft Excel stage 1 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