It’s time to explore our campus to find out about studying at Chichester College.
Why choose this course?
This interactive and practical course is designed for users who want to expand their Microsoft Excel skills and make greater use of the software’s powerful features. Delegates will learn how to create and use range names, link data between worksheets, calculate percentages, and apply functions such as IF and SUMIF to perform more advanced calculations and data analysis. The course also covers the use of Autofilter to manage and analyse large datasets efficiently.
Further information
This course is suitable for users who already have a good working knowledge of Microsoft Excel and want to build on their existing skills. Delegates should be confident in creating and editing spreadsheets, using basic formulas and functions, and navigating Excel independently. Completion of an Excel Beginners course, or equivalent experience, is recommended to ensure participants can fully benefit from the more advanced topics covered.
- More advanced formulas — using functions such as IF, AND, OR, SUMIF, COUNTIF and AVERAGEIF
- Lookup functions — using functions such as VLOOKUP, HLOOKUP and potentially XLOOKUP
- Working with multiple worksheets — linking information between different sheets
- Tables — creating and managing Excel tables and using structured references
- Sorting and filtering — applying more advanced filters to larger datasets.
- Conditional formatting — automatically highlighting values based on specific conditions
- Data validation — creating drop-down menus and controlling data entry
- Charts — creating and formatting different types of charts to present information clearly
- PivotTables — creating basic PivotTables to summarise and analyse data
- Named ranges — making formulas and spreadsheets easier to understand and manage
Continue your Excel journey with our Advanced course
No formal assessment – just practical, hands-on learning!
All delegates will receive a course manual, notepad and pen