It’s time to explore our campus to find out about studying at Crawley College.
COURSE OVERVIEW
Excel Intermediate is a practical, interactive one-day course designed for users who want to build on their existing Microsoft Excel knowledge and make greater use of the software’;s powerful features. Delegates will learn how to work more effectively with data by creating range names, linking information between worksheets, calculating percentages and applying advanced functions such as IF and SUMIF. The course also introduces the use of Autofilter to manage and analyse larger datasets efficiently.
Participants will develop their skills in organising, presenting and protecting information by creating charts, working with grouped worksheets and carrying out calculations across multiple sheets and ranges. The course also covers worksheet protection and Object Linking and Embedding (OLE), enabling delegates to integrate information from different applications. By the end of the course, participants will be able to create more sophisticated spreadsheets, improve data management and produce professional Excel documents with greater confidence.
FURTHER INFORMATION
This course is suitable for users who already have a good working knowledge of Microsoft Excel and are looking to develop their skills further. Delegates should be comfortable creating and editing spreadsheets, using basic formulas and functions, and navigating Excel independently.
It is ideal for:
- Users who have completed an Excel Beginners course.
- Individuals with equivalent Excel experience who want to expand their skills.
- Employees who work regularly with spreadsheets and data.
- Anyone looking to improve their reporting, analysis and spreadsheet management capabilities.
By the end of the course, delegates will be able to:
- Use advanced formulas and functions to analyse data more effectively.
- Work confidently across multiple worksheets and ranges.
- Create charts and reports to present information clearly.
- Use filtering tools to gain insights from large datasets.
- Organise and protect spreadsheets to improve accuracy and security.
- Improve productivity and the overall quality of their work.
- Use Excel more effectively to support decision-making and business processes.
Learners who wish to continue developing their Excel expertise can progress to the Excel Advanced course.
There is no formal assessment for this course. Learning is delivered through practical, hands-on exercises that allow delegates to apply techniques and develop confidence using Excel in realistic workplace scenarios.
Delegates must attend the full day to receive a college certificate.
Course Fee: £185.00
Included in the course fee:
- Course manual
- Notepad and pen
- Morning and afternoon refreshments
This course can also be delivered at your premises for up to 12 delegates. Please contact the team to discuss bespoke in-house training options and pricing.
Commercial Course Coordinators
01273 112201 (Option 3)
train@chigroup.ac.uk
Please note that all courses are subject to demand and trainer availability. Course fees and information quoted are correct for the current academic year.