1 Day Excel Advanced Course | 1 delegate £245.00 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information
Scheduled public courses are held at Preston, Liverpool, Manchester & London.
Closed tailored courses are available on your site if requested.
This one-day instructor led course is designed to give delegates the ability to analyse data in a variety of ways. By the end of the course delegates will be able to use the built in Excel tools to compare data and create projections and also to understand and use the macro facility of Excel.
Analyse data using pivot tables
Develop solutions to financial and budgeting questions
Control the output of printed work with report manager
Verify calculations and trace errors using auditing facility
Automate routine tasks with macros
This course is designed for experienced Excel users who have completed the Excel Intermediate course or have equivalent knowledge. Delegates should already be able to create detailed worksheets using complex formulas and should be familiar with conditional and nested functions.
Creating a pivot table
Rearranging pivot tables
Formatting pivot tables
Using Goal seek and Solver
Using Report Manager
Managing views and reports
Recording a simple macro
Editing a macro
Assigning a macro to keyboard or toolbar button
Checking for errors
Applying data validation to cells with input text and error messages