Join us for Excel Power Pivot and Power Query 2024 to level up your data analysis skills from the comfort of your own home!
About this Event

In today’s world, there are tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This webinar will show you how to take large amounts of data from many sources and processes into great reports.

In this course, you will learn how to take all of your raw data and quickly turn that data into easy-to-use flexible summary reports using PowerQuery and PowerPivot.

Areas Covered

Importing data from Excel into PowerQuery – normal data
Splitting & Merging Columns in the PowerQuery
Calculate age in the PowerQuery
Adding Custom Calculations in PowerQuery
Importing data from a website into the PowerQuery
Refreshing the data in PowerQuery
Importing data from Excel into PowerQuery – formatted tables
Importing Access, SQL Server, and text files into PowerQuery
Append Queries
GroupBy Queries
More Calculations including a conditional column in PowerQuery
Activating PowerPivot
Exploring the PowerPivot menus
Starting the Pivot Table from PowerPivot
Managing Table Relationships
Slicers & Timelines in PowerPivot
Using Sets in PowerPivot
Importing Data directly into the PowerPivot
Measures & KPI’s in PowerPivot

Who will benefit:

Business owners
CEO’s / CFO’s / CTO’s
Managers of all levels
Anybody who uses Excel on a regular basis, and want to be more efficient and productive
Administrators
Salespeople
Trainers
Bankers
Office workers

Target of Audience:

Banking
Finance
Manufacturing
Insurance
Pharmaceutical
Construction
Entertainment
Service
Business owners
CEO’s / CFO’s / CTO’s
Managers of all levels
Anybody who uses Excel on a regular basis, and want to be more efficient and productive
Administrators
Salespeople
Trainers
Bankers
Office workers