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
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 204,432 people .
- Over 14,060 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.8% 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 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
Prices on application. Contact us for quote.
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.
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