HOME
 

Excel Advanced

STL
Course summary
1 day
English
Nationwide
Company-Specific / In-House

Excel Advanced



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... At the end of this 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.

Suitability - Who should attend?



Our Microsoft Excel 2013 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

Naming ranges
- Creating named ranges
- Using named ranges in formulas
The IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions

Working with lookups

The VLOOKUP function
The HLOOKUP function

Advanced list management

Using data validation
- Setting criteria for entry of text, values and dates
- Creating a dropdown list
Using database functions
- Setting up criteria
- DSUM
- DAVERAGE
- DCOUNT

PivotTables and PivotCharts

Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables

Using analytical options

Using Goal Seek
Using the Solver add-in
Working with scenarios
- Creating and saving scenarios
- Viewing scenarios

Macros

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

Expenses



Prices from £480. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

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

  Contact the provider

  Get more information

  Register your interest

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.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Excel Advanced course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here