Course description
Excel Advanced - Classroom
Microsoft Excel Training | 1 Day Excel Courses | Advanced Topics
This Excel Advanced training course is perfect for those looking to learn advanced features and data functions to completely transform the way they use Microsoft Excel.
This course has been created for those who attended our Excel Intermediate course or have equivalent knowledge and are looking to progress by learning advanced features.
By the end of this Excel course, delegates will be able to:
- 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
Excel Training With Keys Training®
- This course is a highly recognised excel course for individuals and companies,
- Over 20 years of experience in delivering excel training courses to thousands of individuals and companies.
- Keys Training® courses are taught by our experienced Microsoft Certified Trainers.
- Our excel training courses are delivered by our qualified trainers either on your site, at one of our venues, or remotely.
Suitability - Who should attend?
This Excel Advanced course is a great course for 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.
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
Raj, was great!
Really enjoyed this course. It was very engaging with real life examples of management in practice. I feel like I have learnt a lot and will take this away to put in to practice...
Expenses
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)
Price per Participant: £245.00
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...
Excellent and insightful course - so beneficial