• OUR COURSES
  • CASE STUDIES
  • ABOUT
  • GO FRONTIA
What software do you need training in?
  • OUR COURSES
  • CASE STUDIES
  • ABOUT
  • GO FRONTIA
What software do you need training in?

Microsoft Excel

Advanced Training

Microsoft Excel is an extremely handy tool, whether you’re completing admin, financial or sales tasks. But without the right training, your team won’t be using Excel effectively.

From £199
Per person
Onsite
Live online
1 Day

We offer a wide range of Microsoft Excel training courses to suit all skill levels, from introductory to advanced and specialist topics. Our courses are available online and on-demand, with options for group training. Whether you’re part of a small team or a larger group, our flexible onsite and live online sessions can accommodate anywhere from 2 to 20 participants.

What you will learn

Find out how to further utilise nested formulas to extract data base on multiple criteria.

Get results to complex questions.

Further user’s knowledge of Pivot Tables by incorporating groupings and calculations.

Use what-if analyses to meet targets and generate forecasts.

Learn how to quickly automate repetitive or tedious tasks by using macros.

6 lessons covers:

Nesting Formulas and Conditional Formatting
Learn to nest multiple formulas, using AND and OR functions within IF statements. This module includes applying Conditional Formatting to format table rows based on criteria and dates using the TODAY function.

Advanced Pivot Tables
Explore advanced Pivot Table reporting tools, including grouping numeric and date fields, running percentage analyses, and writing field calculations. Learn how to create Pivot Tables from multiple tables.  

Array Formulas and LOOKUP Functions
Discover the advantages of array formulas for formula protection, and use LOOKUP functions like INDEX and MATCH for versatile data retrieval. Participants will also learn to write SUMIFS, AVERAGEIFS, and COUNTIFS for calculations based on multiple criteria.  

What-If Analysis and Macros
Utilise Goal Seek and Scenario Manager for forecasting reports. This module covers macro security, recording, running, and editing macros, as well as managing the Personal Workbook and an introduction to VBA code editing.

Customising the Quick Access Toolbar and Ribbon
Learn to add macro buttons to the Quick Access Toolbar (QAT) and customise the Ribbon by adding groups and buttons to enhance your Excel experience.

Text Functions and Data Integration
Gain proficiency in text functions such as CONCATENATE, UPPER, LOWER, and PROPER, along with MID, LEFT, RIGHT, REPT, and FIND. Learn to integrate various Excel features effectively for streamlined workflows and improved data management.

Microsoft Excel

Advanced Training

Enquire now
Please enter a number from 2 to 50.
This field is for validation purposes and should be left unchanged.

"Go have really helped us to drive adoption and enablement and effectively changed the way we run our education function."


"The courses they offer are outstanding. The instructors are knowledgeable and deeply committed to their students' success. They engage with participants, making the learning experience both enjoyable and impactful. Overall, Go Courses excels in delivering high-quality education while fostering a supportive workplace culture. If you're considering a course or looking for a rewarding job, this is the place to be!"


"GO courses have been great at managing our training project; we have multiple sites and wanted training on the same day at all locations and GO had no problem organising everything."


Contact us team@go.courses
Contact us team@go.courses
  • OUR COURSES
  • CASE STUDIES
  • ABOUT
  • GO FRONTIA