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

  • 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

Frequently asked questions

Shareable on LinkedIn

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

Are you ready to begin learning exceptional new skills?

Call:
01225 308979

Email:
info@go.courses

Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL

View on a map