Corporate Training for Teams

Excel Advanced

STL, Nationwide
Length
1 day
Length
1 day
Leave your details so the provider can get in touch

Excel Advanced

STL courses

  • At the end of this advanced Excel course you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.

What to expect

  • 24 months post training support included .
  • Tailored and bespoke programme options .
  • Our experienced training and logistics team in the last 23 years have assisted 207,452 people .
  • Over 14,150 organisations trained .
  • We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
  • Delivery UK wide and international (75+ countries delivered) .

Suitability - Who should attend?



Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

Training Course Content



Using logical functions

The IF function (recap)
Creating nested IF functions
The IFS function
AND and OR functions
Combining logical functions

Working with Lookups

The VLOOKUP function
The HLOOKUP function
The XLOOKUP function (365)
INDEX and MATCH

Data Validation

Using data validation
Setting criteria for entry of text, values and dates
Creating a dropdown list

PivotTables and PivotCharts

Creating and rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables

Using analytical options

Using Goal Seek
Creating, saving and viewing scenarios
Creating single input data tables
Creating double input data tables
Projecting with data tables

Macros

Creating macros
Using the macro recorder
Viewing and editing macro VBA code

Expenses



Prices on application. Contact us for quote.

Request information - obligation free

Contact course provider

Fill out your details to find out more about Excel Advanced.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads