Corporate Training for Teams

Excel Advanced - For Power Users

STL, Nationwide
Length
1 day
Length
1 day
Leave your details so the provider can get in touch

Excel Advanced - For Power Users

STL courses

  • Learn how to fully automate tasks without complicated VBA coding
  • Learn how to connect live to external data sources
  • Get an understanding of how reports and dashboards in Excel can update automatically
  • Get knowledge about how Excel can handle huge data sets very efficiently
  • Learn how to create data models working with relationships in Excel to avoid memory issues with lookup and reference functions
  • Learn how Power Query can structure, clean, append and merge data efficiently
  • Use Excel forms to improve data input, speed up data selection and navigation
    Discover new ways to analyse your data using the Analysis ToolPak Add-In
  • Build powerful projection models with Data Tables and Solver

This course constitutes a good introduction to our data analysis courses UK data analysis courses UK.

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 205,772 people .
  • Over 14,097 organisations trained .
  • We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
  • Delivery UK wide and international (75+ countries delivered) .

Suitability - Who should attend?



Advanced users of Excel wishing to improve efficiency and productivity working with external data, large data sets, and to automate time-consuming Excel tasks without VBA coding knowledge.

Also suitable for advanced users who would like to understand how Excel Power tools can change the way they use Excel and bring their spreadsheets into the future, and data analysts who want to explore analysis tools from the Excel analysis Toolpak and who need to create projection models.

Training Course Content



The Table Tool

Reference ranges by table names and columns by headings
Understand how the table tool can be used to reduce time spent updating analysis, dashboards, or reports
Understand the importance of the table tool for power tools

Data Models

Create relationships between tables
Create PivotTables from multiple tables without using lookup and reference functions (Vlookup, Index, Match)

Intro to PowerPivot

Connect to huge data sets live
Relate tables and create PivotTables from a multiple table data model

Intro to PowerQuery

Connect live to an external data source
Structure internal and external data
Clean, merge, append, and group internal and external data
Automate tasks
Transfer data from the query connection to the Excel data model

Solver

Creating models
Projecting scenarios with Solver

Forms

Use form controls to create interactive reports and dashboards
Creating interactive forms
Building dynamic charts with forms

Analysis ToolPak

Exploring the data analysis tools in Analysis Toolpak

Expenses



Prices on application. Contact us for quote.

Request information - obligation free

Contact course provider

Fill out your details to find out more about Excel Advanced - For Power Users.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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.

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...

Read more and show all courses with this provider

Ads