Excel Advanced - For Power Users
- 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
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- And more... .
Upcoming start dates
Choose between 50 start dates
Upcoming start dates
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 headingsUnderstand 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 tablesCreate PivotTables from multiple tables without using lookup and reference functions (Vlookup, Index, Match)
Intro to PowerPivot
Connect to huge data sets liveRelate tables and create PivotTables from a multiple table data model
Solver
Creating modelsProjecting scenarios with Solver
Intro to PowerQuery
Connect live to an external data sourceStructure 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
Forms
Use form controls to create interactive reports and dashboardsCreating interactive forms
Building dynamic charts with forms
Analysis ToolPak
Exploring the data analysis tools in Analysis ToolpakExpenses
List price £350, 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
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.
Reviews by course attendees
Average rating 4.8
Based on 164 reviews.
Write a review!
5/5
Tom
16 Aug 2023
5/5
Aline
03 Jul 2023
5/5
Anton
03 Jul 2023
Most useful topic: Power Pivots
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: Power Query