Course description
Microsoft Excel Intermediate - Classroom
This Excel Intermediate course is designed to give delegates the ability to analyse data in a variety of ways.
Take your Excel skills to the next level with our Excel Intermediate classroom training course. Designed for those with a foundational understanding of Excel, this intermediate-level course delves into advanced formulas, data manipulation, and visualisation techniques.
- By the end of the course, delegates will be able to use full advantage of a greater range of available Excel functions in their roles in order to produce more effective spreadsheets for your organisation.
- This Excel Intermediate course is a great course for individuals that have the basic knowledge of Excel and can navigate around spreadsheets but would benefit from learning functions and tools such as IF Statements and VLOOKUPS to help them in their roles.
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.
Suitability - Who should attend?
This course is designed for participants who have completed the Excel Level 1 (Introduction to Excel) course or have equivalent knowledge.
Participants should already be able to create formulas, use basic functions such as SUM, MIN, MAX and COUNT and also be aware of the difference between relative and absolute references.
Outcome / Qualification etc.
By the end of this course, each attendee will be able to:
- Use more advanced formulas and functions
- Define names for individual cells and ranges
- Use the database tools in Excel
- Work effectively with large spreadsheets
Training Course Content
Functions
- IF functions
- VLOOKUP and HLOOKUP
- Function to combine data from multiple cells
- Data functions
- Nested functions
Tools
- Naming cells and ranges
- Protecting cells
- Linking workbooks
- Linking applications (Excel with Word or PowerPoint)
Database tools
- Sorting data – ascending, descending, left to right
- Sorting data in custom sequences
- Filtering data with AutoFilter
- Creating customised and advanced filters
- Using data forms to enter, delete and search for data
- Using subtotals to calculate sub sets of data
Formatting
- Hiding columns, rows and formulas
- Grouping columns and rows
- Applying conditional number formatting
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
Felt the training topics were delivered really clear and easy to follow
The course taught me how to use Excel's data analysis tools, such as sorting and filtering, which has made working with large data sets much easier.
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 delegate : £225.00 plus vat
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...
I appreciated how Rob went beyond the basics and introduced us to some more advanced features, such as conditional formatting and PivotTables.