It’s time to explore our campus to find out about studying at Chichester College.
Why choose this course?
This interactive Excel course is designed to help participants build confidence and efficiency when working with advanced spreadsheet functions and tools. Learners will explore auditing techniques to improve data accuracy, master look-up functions such as VLOOKUP and HLOOKUP for effective data retrieval, and deepen their understanding of logical functions including IF and AND. The course also covers advanced text functions, enabling users to manipulate and analyse text-based data more effectively, as well as working with fractions to ensure accurate handling of numerical information.
Further information
This course is perfect for those who want to unlock the full potential of Microsoft Excel. If you’re already comfortable with Excel and eager to dive into its advanced features, this course is for you! Ideally, you should have completed the Excel Intermediate course at the college.
- Advanced formulas and functions — such as XLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, IF, nested formulas and error handling.
- Advanced lookups — finding and combining information from different tables or worksheets
- PivotTables — summarising and analysing large amounts of data quickly.
- PivotCharts — turning PivotTable data into useful visual reports.
- Advanced data analysis — identifying trends, comparing figures and extracting insights.
- Conditional formatting — using rules to automatically highlight important data
- Data validation — creating drop-down lists and controlling what users can enter
- Advanced charts — creating more professional and interactive visualisations
- What-if analysis — using tools such as Goal Seek, scenarios and data tables
- Advanced sorting and filtering — analysing complex datasets efficiently
Expand your skills further with our training in other Microsoft Office packages, Adobe programs, and various Management & Business courses.
No formal assessment – just practical, hands-on learning!
All delegates will receive a course manual, notepad and pen