HomeMicrosoft Excel stage 1 training course
Microsoft Excel stage 1 is a one-day course. Our price is £149.00 (Sage's RRP is £270.00).
» 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
- 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
Session 2 - Fill Handle and Custom Lists
- Copying Data with the Fill Handle
- Custom Lists
Session 3 - Formula Creation, Sub and Grand Totals, Match and Concatenate
- Cell References
- Functions
- Auto Calculate
Session 4 - Absolute Cell Reference and IF Statement
- Absolute Cell Reference
- Working with Conditional Formulas
Session 5 - Effective Workbook Management
- Selecting and Deselecting Worksheets
- Changing Tab Colours
- Renaming Worksheets
- Creating a 3D Formula
- Comments
Session 6 - Linking Workbooks
- Multiple Workbooks
- Opening Multiple Workbooks
- Working in a Multi Workbook Environment
- Updating Links
Session 7 - Creating and Editing Charts
- To Create a Chart using the Chart Wizard
- Enhancing a Chart
- Removing Data Ranges
Session 8 - Applying Page Breaks and Print Settings
- Setting and Clearing a Print Area
- Page Break Preview
- Applying Print Options
Book now
No courses found to match your criteria
Microsoft Excel stage 1 is a one-day course. Our price is £149.00 (Sage's RRP is £270.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 009 3990 to pay by card or arrange BACS or cheque payments.
- Use the contact form: Click here and fill out the contact form.
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
