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
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- And more... .
Upcoming start dates
Choose between 64 start dates
Upcoming start dates
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
List price £330, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
Request information - obligation free
Reviews by course attendees
Average rating 4.8
Based on 11915 reviews.
Write a review!
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
Most useful topic: Macros; Xlookup