It’s time to explore our campus to find out about studying at Crawley College.
Why choose this course?
Excel Advanced is an interactive one-day course designed for experienced Excel users who want to unlock the full potential of Excel and make greater use of its advanced features. Delegates will develop their skills in auditing and validating data, using look-up functions such as VLOOKUP and HLOOKUP, and applying logical functions including IF and AND to perform complex calculations and analysis.
Further information
This course is ideal for users who are already confident using Excel and would like to develop their knowledge of advanced spreadsheet functions and tools. It is particularly suitable for those who regularly work with data, reporting and analysis and want to improve efficiency and productivity.
- Auditing and error checking.
- IF, AND and logical structures.
- Macros and automation tools.
- PivotTables, subtotals and scenarios.
- VLOOKUP, HLOOKUP and lookup tables.
Delegates wishing to broaden their professional development can continue with training in other Microsoft Office applications, Adobe software and a range of Management and Business courses.
There is no formal assessment for this course. Learning is delivered through practical, hands-on activities that allow delegates to apply advanced Excel techniques in realistic workplace scenarios. Delegates must attend the full day to receive a college certificate.
Included in the course fee: Course manual, Notepad, Pen, Morning and afternoon refreshments.