What You Will Pay
Please select a course to see pricing information.
Advanced Functions and Formulae
Level XCourse Overview
Part Time
Certificate
Certificate
Build on your existing Excel knowledge with this practical evening workshop, designed for professionals who want to develop more advanced spreadsheet skills and become more confident using Excel in the workplace. Delivered outside of standard working hours, it's ideal for fitting around your existing work commitments.
If you've previously completed our Excel – Functions & Formulae workshop, or you already have a good understanding of creating formulas and functions, this session will help you take your skills to the next level. You'll learn how to work more efficiently with complex data, automate calculations and make the most of Excel's advanced features.
During the workshop, you'll cover:
• A refresher on basic functions, absolute cell references and named ranges.
• Using SUMIF and COUNTIF to calculate or count values that meet specific criteria.
• Using HLOOKUP and VLOOKUP to retrieve information from other tables within a workbook.
• Creating formulas that link across worksheets and multiple Excel workbooks.
• Using Consolidation to combine and summarise data from related worksheets and workbooks.
Advanced Excel skills are highly valued across a wide range of industries. Whether you're looking to improve your performance in your current role, prepare for new responsibilities or enhance your CV, this workshop will help you work more efficiently and confidently with data.
-
You will need to have previously attended the Excel – Functions & Formulae workshop or already have a good understanding of creating basic functions and formulas.
This course is designed for adults aged 19 and over (as of 31 August in the academic year you are applying for) who are looking to develop their Excel skills, refresh their existing knowledge or enhance their professional development.
In some circumstances, you may be eligible to access this course free of charge.
-
Your tutor will be able to advise of any further training opportunities.
Shortlist and Apply
Please select the specific course you would like to apply for.
Your future in tech starts here
Every game you play, every cyber attack stopped and every system that keeps the world online was built by someone like you. Now it's your turn. Whether you want to create the next big game, stop hackers in their tracks or track down digital evidence, this is where you'll turn your passion for tech into a career. Think AI means fewer tech jobs? Think again. It's changing what the jobs look like, and you'll be trained for what's next.
You'll choose from a range of tech courses, all taught by industry-experienced lecturers who'll give you the practical, job-ready skills employers are looking for. It's an ideal route into work, or on to higher-level study at GC or university.
As a Technical Excellence College for DigiTEC, we're one of just five colleges in the UK selected to deliver specialist Digital & Technologies training. Backed by £175 million of investment in the workforce of tomorrow, you'll build the skills, knowledge and experience to succeed, learning from industry experts every step of the way.
And it all happens in ADA...
our £3 million digital academy, packed with the latest technology, specialist spaces and a dedicated computing network, to hone your passion and spark your career.
Proud To Be Working With
View Courses
Next Steps
Find out more
Check the progress of your application and find out everything you need to know about the application and enrolment process at GC.