Unlock the full potential of Microsoft Excel with our immersive three-day course.
Join us on a journey to master the Excel Power Tools, including Power Query, Power Pivot, and Data Modeling.
Discover how to seamlessly integrate these powerful tools into your Excel workflow and supercharge your data analysis.
Gain the skills to create dynamic PivotTables and captivating PivotCharts that will transform the way you work with data.
Get ready to excel like never before!
Data Analysts:
Data analysts who want to enhance their data manipulation and modeling skills in Excel will find this course invaluable. They’ll learn how to efficiently clean, transform, and analyze data using Power Query and Power Pivot.
Business Intelligence Professionals:
Professionals involved in business intelligence and reporting will benefit from this course by acquiring the tools and techniques to create interactive reports and dashboards using Excel.
Financial Analysts:
Financial analysts can leverage Power Pivot for complex financial modeling and analysis. They’ll learn how to create robust financial models and perform scenario analysis.
Business Managers:
Managers looking to make data-driven decisions will find this course helpful in understanding how to extract valuable insights from data using Excel’s Power Tools.
Excel Enthusiasts:
Anyone passionate about Excel and interested in exploring advanced features and capabilities will find this course exciting and enriching.
Small Business Owners:
Small business owners who handle their own data analysis and reporting can benefit from learning how to streamline data processes and create insightful reports.
Basic Excel Proficiency:
Participants should have a fundamental understanding of Excel, including familiarity with worksheets, basic functions, and formulas.
Windows Operating System:
As Power Query and Power Pivot are primarily available on the Windows version of Excel, attendees should have access to a Windows-based computer.
Excel Version:
It’s recommended that participants use a version of Excel that supports Power Query and Power Pivot, such as Excel 2013 or later.
This course has no certification.
Info to come…
Topics Day 1: Excel Data Analysis Fundamentals
Module 1: Data Analysis in Excel
Module 2: The Excel Data Model
Day 2: Data Import and Transformation
Module 3: Importing Data from Files
Module 4: Importing Data from Databases
Module 5: Importing Data from Excel Reports
Day 3: Advanced Data Modeling and Visualization
Module 6: Creating and Formatting Measures
Module 7: Visualizing Data in Excel o Creating PivotTables and PivotCharts
Module 8: Using Excel with Power BI
Course Overview
20 450 kr
3 days
Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to find a suitable opportunity.
Customized Courses
The course can be adapted from several perspectives:
In interaction with the course leader, we ensure that the course meets your needs.
Stockholm
Göteborg
Skicka intresseanmälan för utbildningen
Send an expression of interest for the training