Microsoft Excel remains one of the most popular tools for data analysis. It comes equipped with built-in “power tools” such as PivotTables, Power Query, and Power Pivot that allow for deep and flexible data manipulation.
This training is designed to explore both new and enhanced data tools available in Excel. It’s aimed at anyone who needs to work with Excel to connect, organize, prepare, process, analyze, and display data, producing actionable views and outputs for all organizational levels.
Attendees must be experienced Excel users who have either:
Attended the Excel Advanced course
Or possess equivalent knowledge and are comfortable with:
Creating, formatting, and saving worksheets and workbooks
Writing formulas using functions like SUM, AVERAGE, COUNT
Working with list tools such as sorting and filtering
Creating and modifying PivotTables
Note: This course is suitable for users of Excel 2016, 2019, 2021, and 365 only.
By the end of this training, you will have gained knowledge and skills in the following areas:
Understand data types and analysis concepts
Import and connect to external data
Prepare and clean data using Power Query Editor
Model data with Power Pivot
Use DAX formulas to perform advanced analysis
Visualize data using PivotTables, PivotCharts, and conditional formatting
Different types of data
Types of data analysis
Overview of Excel's data tools
The data analysis framework
Working with common data sources
Importing and connecting to external data
Managing queries and connections
Overview of Power Query Editor
Data types in Power Query
Combining multiple data sources
Cleaning and shaping data
Creating calculated columns
Introduction to Power Pivot
Loading data into the Data Model
Creating and managing data relationships
Fundamentals of DAX (Data Analysis Expressions)
Creating calculated columns
Creating measures
Working with date tables
PivotTable fundamentals
Creating PivotTables using the Data Model
Adding dynamic filters with Slicers and Timelines
Creating PivotCharts
Using hierarchies and drill-down techniques
Applying other visual tools
Conditional formatting
Key Performance Indicators (KPIs)
Experience live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Microsoft Excel Data Analysis using Power Tools Training. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.
Immerse yourself in our most sought-after learning style for Microsoft Excel Data Analysis using Power Tools Training. Our hand-picked classroom venues offer an invaluable human touch, providing a focused and interactive environment for professional growth.
Streamline your organization's training requirements with Bilginc IT Academy’s Onsite Microsoft Excel Data Analysis using Power Tools Training. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Our IT training and professional development services reach a global audience, transcending geographical boundaries through advanced digital learning platforms and strategic international hubs. We specialize in delivering world-class curriculum across continents, ensuring that no matter where you are located, you have access to the latest industry certifications and technical expertise. By partnering with global technology leaders and academic institutions, we provide a unified learning experience that meets the demands of a diverse, international workforce. Our commitment to global excellence ensures that professionals in every time zone can master the digital skills required to lead, innovate, and thrive in the ever-evolving global technology landscape.
