It’s time to explore our campus to find out about studying at Crawley College.
Why choose this course?
Excel Intermediate is a practical, interactive one-day course designed for users who want to build on their existing 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.
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.
- AutoFilter and data control.
- IF and SUMIF functions.
- Range names and linked sheets.
- Sheet protection and OLE.
- Using charts effectively.
Delegates may wish to continue developing their Excel expertise with our 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.
Included in the course fee: Course manual, Notepad and pen, Morning and afternoon refreshments.