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.
Who can apply?
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.
What happens next?
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.
How will I be assessed?
No formal assessment, just practical, hands-on learning!
Course costs
Course cost – From £230.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.
Further Information
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.
Benefits of attending:
Learning to use Excel offers numerous benefits for both personal and professional life. It's a versatile tool that can help with organisation, data management, automation, and creating insightful dashboards.
Excel training courses are a great way to build these skills, providing hands-on experience in a business context. Given its widespread use in various industries, Excel proficiency is highly valued and can open many career opportunities.
Whether you're automating tasks, linking systems, or managing databases, Excel's formulas and macros make it a powerful tool for efficiency and productivity.
