HOME
 

Excel Advanced

STL
Course summary
1 day
195 - 240 GBP excl. VAT
English
Open / Scheduled
Next available date: 14/04/2020 09:30 - Distance
Course Dates
Distance
14/04/2020 09:30  (English)
230 GBP
28/04/2020 09:30  (English)
240 GBP
15/05/2020 09:30  (English)
240 GBP
London
04/09/2020 09:30  (English)
195 GBP
17/09/2020 09:30  (English)
195 GBP
28/09/2020 09:30  (English)
195 GBP
STL courses

Excel Advanced

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... 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.; ;


STL virtual classroom training

We all have to accept our preferred face-to-face method just isn't an option right now. However, virtual classroom training that we have developed offers some benefits which can make it seem less of a compromise and more of a viable interim training solution. 

Our virtual classroom training is delivered by the same team responsible for achieving industry leading customer satisfaction ratings with face-to-face training, so rest assured you are in safe hands.

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 functionsNaming ranges- Creating named ranges- Using named ranges in formulasThe IF function (recap)Creating nested IF functionsAND and OR functionsCombining logical functionsWorking with lookupsThe VLOOKUP functionThe HLOOKUP functionAdvanced list managementUsing data validation- Setting criteria for entry of text, values and dates- Creating a dropdown listUsing database functions- Setting up criteria- DSUM- DAVERAGE- DCOUNTPivotTables and PivotChartsUsing the PivotTable WizardRearranging PivotTablesUsing the PivotTable toolbarCreating PivotChartsUsing Slicers to manipulate PivotTablesUsing analytical optionsUsing Goal SeekUsing the Solver add-inWorking with scenarios- Creating and saving scenarios- Viewing scenariosMacrosCreating macrosUsing the macro recorderViewing and editing macro VBA code

Expenses

List price £330 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video

   

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....


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

Contact information for STL

STL

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

 Show phone number
www.stl-training.co.uk Course homepage


Reviews by course attendees

Average rating 4.7

Based on 7797 reviews

Estelle Marsh; Integration Solutions Manager
(5)
maybe more examples we do ourselves
Nicole Davies; Financial Controller
(5)
the links in the initial email did not work; so I was unsure of where venue was and which venue I was attending
Owen Evans; Category Manger
(5)
Course was great; hopefully various ideas to take back to the workplace. Will also spread the word at work; as I'm sure this course can also aid many of my colleagues.
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 second annual U.K. L&D Report!

uk-ld-report-2019

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