Course description
Microsoft Excel Advanced - In Company
This in-house Excel Advanced 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.
- This Excel Advanced course is a great course for a group of individuals that are confident when using Excel but would benefit from understanding how they can use more advanced features to help them in the workplace.
Instructor-led
- Keys Training® courses are taught by our experienced Microsoft Certified Trainers. They will ensure that skills and techniques are at the correct pace for the attendees and will show how Excel features can be applied in their roles.
Customisation available
- For all our on-site excel courses, we include in our service reasonable course customisation, to ensure the participants learn the skills and features that will most benefit them in their roles within the workplace.
Upcoming start dates
Suitability - Who should attend?
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.
Outcome / Qualification etc.
By the end of this course, each attendee will be able to:
- Analyse data using pivot tables
- Develop solutions to financial and budgeting questions
- Control the output of printed work with the report manager
- Verify calculations and trace errors using an auditing facility
- Automate routine tasks with macros
Training Course Content
Pivot Tables
- Creating a pivot table
- Rearranging pivot tables
- Formatting pivot tables
- Creating charts
Analytical Tools
- Using Goal seek and Solver
- Creating Scenarios
Report Manager
- Using Report Manager
- Managing views and reports
Macros
- Recording a simple macro
- Editing a macro
- Assigning a macro to keyboard or toolbar button
Auditing Facility
- Tracing Precedents/Dependents
- Checking for errors
- Applying data validation to cells with input text and error messages
Why choose Keys Training
Over 25 years’ experience of delivering quality Microsoft & Business Skills training.
All Trainers are Microsoft Certified or equivalent.
Scheduled Public and Tailored In-house training throughout the UK.
Reviews
Average rating 4.9
Good presentation, well put together, great communication and easy to talk to
We had the opportunity to share what we needed specific support with in excel which was really helpful
Expenses
£645.00 PLUS VAT (MAXIMUM 8 ATTENDEES)
As this is an in-house course we include our service of reasonable tailoring of the topics to best meet your needs.
WE PROVIDE ALL ATTENDEES WITH:
A course completion certificate for their training records
Quality reference material for future use and recapping of topics practiced during the training day (PDF document)
Get Inspired! Watch the Video
Request info
Keys Training
Keys Training® provides a Business Skills Training Service throughout the UK. We specialise in delivering one-day instructor-led courses that cover Microsoft Office and Personal Development Skills. Our training courses can be delivered on your site, at one of our venues...
Nothing wrong with the course, I don’t use Excel to this level. Trainer is top notch.