Explore
Explore
Contact us
01225 308979

Microsoft Excel Advanced Training

From £199 per person - businesses only

Enquire today we have face to face and live online training available

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.

Skills you will gain

Nesting Logical Functions If Function Pivot Tables Percentage Analyse Advanced Conditional Formatting Summing BY Criteria Lookup Macros VBA Microsoft Excel Tables
  • Shareable Certificate Earn a Cerfiticate upon completion
  • Face to Face or Live Online Start instantly and learn at your own schedule
  • Flexible Schedule Set and maintain flexible deadlines
  • Advanced Gain expert level skills to build on your intermediate knowledge  

This course consists of 11 lessons

Nesting Logical Functions. The principals of nesting formulas together.

Using the IF function with nested AND and OR functions to output results to multiple question.

Advanced Pivot Tables. Grouping dates and numerical values.

Running percentage analyse. Running an comparison analyses. Inserting Field calculations. Creating a user-friendly dashboard report including charts.

Advanced Conditional Formatting. Using conditional formatting to alert us of data variables.

Colour table rows based on criteria within it. Apply colour to approaching dates.

Summing by Criteria. Using a SUMIFS function to sum numbers by criteria within rows.

Lookup Functions. Using functions to retrieve data from the left or right of a column that’s being looked up by using the INDEX and MATCH functions.

Recording Macros. Macro security. Understanding a Relative References macro.

Recording, running and editing macros. Saving files as Macro Enabled Workbooks.

Introduction to VBA code. Add a macro button to the Quick Access toolbar.

Enquire today
Download course details as a PDF

Frequently asked questions

“I came over especially for the training with Go Courses. It was tailored perfectly – lots of hands on training in a great London facility just off Leadenhall Court. Thank you.”

Qamar Rathore, Hoffman La Roche

“Great course, with some great content. Lots to take away and review, as well as some interesting insights from a very knowledgeable trainer. Will definitely look to attend further AWS training in the future.”

Mark Conabeare, Landmark Property

“We’ve purchased a range of cloud-based training courses from Go Courses – very accommodating in terms of price and scheduling classes.”

Graham Riddall, Home Office

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

Registered office: Go Courses, 88B Walcot Street, Bath, United Kingdom, BA1 5BD

Company Registration Number: 4782472© 2024 All rights reserved