HomeMicrosoft Excel stage 2 training course
Microsoft Excel stage 2 is a one-day course. Our price is £149.00 (Sage's RRP is £270.00).
» 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
- Creating a PivotTable
- Adding Fields to a Pivot Table
- Changing the PivotTable Layout
- Removing Fields from a PivotTable
- Updating a PivotTable
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
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
Session 4 - Named Ranges
- Creating Individual Named Range
- Creating Adjacent Named Ranges
- Editing Named Ranges
- Deleting Named Ranges
Session 5 - Mathematical, Statistical, Logical and Time Functions
- The CountIf Function
- The SumIf Function
- The And Function
- The Or Function
- Nesting Functions
- Calculating Time
Session 6 - Lookup Functions, Data Validation and Auditing
- The VLookup Function
- The HLookup Function
- Data Validation
- Auditing the Workbook
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
No courses found to match your criteria
Microsoft Excel stage 2 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
