Excel Advanced - For Power Users

Course summary
1 day
Corporate Training for Teams
STL courses

Excel Advanced - For Power Users

Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... Build powerful projection models with data tables and Solver; Use Excel forms to improve data input, speed up data selection and navigation; Enhance the power of your formulas by using arrays; Functional macros that help you work faster and smarter; Retrieve dynamic data from websites; Discover new ways to analyse your data by using the Analysis ToolPak Add-In; ; This course constitutes a good introduction to our data analysis courses UK.

Suitability - Who should attend?

Advanced users of Excel with extensive knowledge and use of nesting functions. Those looking to explore and project with their data, whilst needing to present it to different audiences.

Training Course Content

Creating Forms

Creating interactive forms
Build dynamic charts with forms

Data Tables

Creating single input tables
Creating double input tables
Projecting with data tables

Array formulas

Why use an array formula?
Use the SUMPRODUCT function
Use an array to count unique entries in a range
Using Transpose to flip row/columns
More CSE formula tips


Inserting and editing hyperlinks
Using the HYPERLINK function

Creating Functional Macros

Recap of creating macros
Extend your knowledge of the use of macros
Adding a message box


Protect worksheets and Workbooks

Importing Data from the Web

Creating web queries
Formatting data
Enabling automatic refreshing


Creating models
Projecting scenarios with Solver

Analysing Data with the Analysis ToolPak

Installing the Analysis Toolpak
Generating statistical analysis


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

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 - For Power Users.

  Contact the provider

  Get more information

  Register your interest

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.

Contact information for STL


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

 Show phone number

Similar Courses

Request information

Find out more about this Excel Advanced - For Power Users 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!


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