Microsoft Excel training by Sage stage 2

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

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 

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