Course description
Microsoft Excel Training Courses
Keys Training® specialises in delivering focused instructor-led courses in Microsoft Excel.
Discover day-to-day optimisation and Excel in data analysis & calculations through these one-day courses. Mastering Data Analysis and Calculations when working in the world’s most popular spreadsheet program,
Whether you are looking for training or you are looking at booking a group session, Keys Training® has a number of training solutions to meet your needs.
Excel courses at all levels
- Excel Introduction Training
- Excel Intermediate Training
- Excel Advanced Training
Suitability - Who should attend?
Basic IT skills required
Outcome / Qualification etc.
Certificate of Attendance
Training Course Content
Keys Training understands that every team is unique and have different requirements, and that's why they provide Excel training at multiple levels - beginner, intermediate, and advanced.
Below is a short description of what each course includes, for a full course outline please fill out the form below and mention the level you are interested in, a training advisor will then email you our in-depth course outline. Along with trainer availability and price.
EXCEL INTRODUCTION
This one-day instructor-led course is designed to give a thorough introduction to the basic skills needed to use Excel effectively. By the end of the course, delegates will be able to create, modify and format Excel spreadsheets including designing basic formulas and charts.
- Understand the terminology used in Excel
- Open, close, save and print Excel worksheets
- Enter, edit, and format data
- Use formulas and functions to calculate in Excel
- Create and format a simple chart
EXCEL INTERMEDIATE
This one-day instructor-led course is designed to develop the practical skills of Excel users. By the end of the course, delegates will be able to use to full advantage a greater range of available Excel functions in order to produce more effective spreadsheets.
- Use advanced formulas and functions (IF, VLOOKUP)
- Define names for individual cells and ranges
- Use the database tools in Excel
- Work effectively with large spreadsheets
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 understand and use the macro facility of Excel.
- Analyse data using pivot tables and charts
- Develop solutions to “What if?” scenarios
- Verify calculations and trace errors using the auditing facility
- Automate routine tasks with macros
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.
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...