Our range of leisure and hobby courses keeps growing, with even more fun and exciting courses starting throughout 2025.
Level X
Microsoft Excel – Advanced
COURSE OVERVIEW
Get ready to elevate your Excel skills to new heights with our hands-on, interactive course! You’ll explore:
- Auditing: Ensure your data’s accuracy with powerful auditing tools.
- Look-Up Tables: Master VLOOKUP and HLOOKUP for efficient data retrieval.
- Macros and Assigning Code to Buttons: Automate repetitive tasks and boost your productivity.
- IF Revisited: Deepen your understanding of the IF function for complex logical tests.
- AND Function: Combine conditions to refine your data analysis.
- Text Functions: Manipulate text data with ease using advanced text functions.
- Goal Seeking: Find the input values needed to achieve your desired results.
- Scenarios: Compare different data scenarios to make informed decisions.
- Consolidation of Data: Combine data from multiple sources for comprehensive analysis.
- Working with Fractions: Handle fractional data accurately.
- Sub Totals: Summarise data with automatic subtotals.
- Pivot Tables: Transform your data into insightful, interactive reports.
This course runs on a Tuesday from 9.30am to 4.30pm.
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.
Upon successful completion, you’ll receive a College Certificate of Attendance. This certificate can be a valuable addition to your professional portfolio, showcasing your commitment to mastering Excel.
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!
Course cost – £190.00
All materials and equipment provided. Enjoy complimentary tea, coffee, and biscuits during breaks.
In-House Training: We can bring the course to you! Contact us for in-house training costs for up to 12 delegates.
To book or request further information please contact a Commercial Course Coordinator at 01293 442344 or train@ccgtraining.ac.uk
All courses are subject to demand and tutor availability. Fees and information are correct for the current academic year.
The College has a no refund policy except where the College closes a course. A full refund will be offered if the College closes a course prior to the start.