Microsoft Excel training by Sage stage 1

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

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 1Manchester17/03/20101 day122
MS Excel Stage 1Reading23/03/20101 day121
MS Excel Stage 1Bristol30/03/20101 day101
MS Excel Stage 1Glasgow30/03/20101 day1210
MS Excel Stage 1Newcastle21/04/20101 day127
MS Excel Stage 1Croydon27/04/20101 day120
MS Excel Stage 1Leeds28/04/20101 day123
MS Excel Stage 1Reading05/05/20101 day1211
MS Excel Stage 1Birmingham06/05/20101 day1210
MS Excel Stage 1Glasgow13/05/20101 day1212
MS Excel Stage 1Manchester18/05/20101 day127
MS Excel Stage 1N.London27/05/20101 day124
MS Excel Stage 1Bristol03/06/20101 day108

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


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


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