Course description
Excel Birmingham | Instructor-led Training
Excel Advanced | 1 Day Excel Courses | Classroom or In House
Microsoft Excel Courses
Microsoft Excel is the world’s most popular spreadsheet program, learning how to use the software with Keys Training® shows that you’ve taken one of the best Excel training courses available. Comprehensive instructor-led excel courses available across Birmingham:
- Our 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 is perfect for those who attended our Excel Intermediate course or have equivalent knowledge and are looking to progress by learning features.
- Our experienced instructors will guide you through hands-on exercises and real-world examples, so you'll be able to apply what you've learned immediately into 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.
Excel Intermediate - Course Objectives:
- 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
Training Course Content
Excel Advanced
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.
- Review of Excel day-to-day features
Advanced Formulae
- Partial absolute cell references
- Applying data validation to cells with input text and error messages
- Nesting OR & AND functions within IFs
- Use of IFERROR function to remove #N/A from VLOOKUP results
Analytical Tools and Auditing
- Using Goal seek and Solver
- Creating Scenarios
- Tracing Precedents/Dependents
- Checking for errors
Pivot Tables & Charts
- Creating and rearranging pivot table
- Adding multiple data values
- Formatting pivot tables and creating Slicers
- Creating pivot charts
Macros
- Recording a simple macro
- Editing a macro
- Absolute/Relative macros
- Assigning a macro to keyboard shortcut or button
Course delivery details
Two Types of Training
- Excel Introduction Public Courses
- Group In House Excel Training (up to 8 attendees)
Public courses run from 9.30am to 4.30pm.
Our in-house courses are normally scheduled to start at 9.30am and finish at about 4.30pm (however, these times can be amended if requested).
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.
Expenses
Please get in touch by filling out the form or call to find out the course fees.
Public Course – Excel Advanced: £245.00 plus VAT per Person (quantity discounts apply)
In House Excel Advanced: £645.00 plus VAT (for up to 8 attendees)
As these are all inhouse courses, we can tailor the course content to meet the skill levels and requirements of the delegates.
Request info
Get Inspired! Watch the Video
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...