Excel Advanced
- 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 204,432 people .
- Over 14,060 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.8% 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 functionThe HLOOKUP function
The XLOOKUP function (365)
INDEX and MATCH
Data Validation
Using data validationSetting criteria for entry of text, values and dates
Creating a dropdown list
PivotTables and PivotCharts
Creating and rearranging PivotTablesUsing the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables
Using analytical options
Using Goal SeekCreating, saving and viewing scenarios
Creating single input data tables
Creating double input data tables
Projecting with data tables
Macros
Creating macrosUsing the macro recorder
Viewing and editing macro VBA code
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
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...
Ads