Excel's size limits and manual data entry from multiple sources frustrate anyone who works with data. This 75-minute Excel Power Pivot training shows how Power Pivot and Power Query solve those problems inside Excel, without database access or IT help.
Power Query is the tool for finding, connecting to, importing and cleaning data, removing unwanted rows and columns, trimming spaces, and merging or splitting fields, with saved query definitions for reuse. Power Pivot then models that data, handling more than a million rows from almost any source.
You'll learn the Power Pivot interface, table relationships, PivotTables, PivotCharts and dashboard views, DAX basics and measures such as year to date, and sets.
WHY SHOULD YOU ATTEND?
Power Pivot lets you build PivotTables from multiple datasets without VLOOKUP or multiple consolidation ranges, and work with data far beyond normal worksheet limits. It can transform how you report and analyze.
The session suits business professionals and owners, controllers, accountants, CPAs, CFOs and financial consultants with intermediate Excel skills who know formulas and PivotTables.
AREA COVERED
- The Power Pivot interface and menu options
- Importing and cleaning data with Power Query and saving query definitions
- Loading data into Power Pivot for analysis
- Analyzing more than 1 million rows of data
- Creating relationships between tables
- Building dashboard views from Power Pivot
- Creating PivotTables and PivotCharts from Power Pivot
- DAX formula language principles
- DAX measures such as year to date, month to date and previous month
- Using sets to analyze data
LEARNING OBJECTIVES
- Navigate the Power Pivot interface and menu options
- Import and prepare data with Power Query
- Load and analyze more than a million rows in Power Pivot
- Create relationships between tables of data
- Build PivotTables, PivotCharts and dashboard views from the data model
- Write DAX measures such as year to date and previous month
- Use sets to analyze your data
WHO WILL BENEFIT?
This webinar is designed for Business professionals, Business owners, Financial Controllers, Accountants, and anyone who requires doing data analysis. This event is aimed at users of Excel (2010, 2013, and 2016 for Windows) who wish to learn about Power Pivot and Power Query. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot Tables.
- Business users who analyze data with Excel or create management reports
- Excel users who want to analyze large data sets and create relationships between tables
- Excel users who know how to Pivot Tables and Pivot Charts
- Excel users who wish to create interactive dashboards
- Accountants
- CPAs
- CFOs
- Financial Consultants
- Controllers
Power Pivot lets you build PivotTables from multiple datasets without VLOOKUP or multiple consolidation ranges, and work with data far beyond normal worksheet limits. It can transform how you report and analyze.
The session suits business professionals and owners, controllers, accountants, CPAs, CFOs and financial consultants with intermediate Excel skills who know formulas and PivotTables.
- The Power Pivot interface and menu options
- Importing and cleaning data with Power Query and saving query definitions
- Loading data into Power Pivot for analysis
- Analyzing more than 1 million rows of data
- Creating relationships between tables
- Building dashboard views from Power Pivot
- Creating PivotTables and PivotCharts from Power Pivot
- DAX formula language principles
- DAX measures such as year to date, month to date and previous month
- Using sets to analyze data
- Navigate the Power Pivot interface and menu options
- Import and prepare data with Power Query
- Load and analyze more than a million rows in Power Pivot
- Create relationships between tables of data
- Build PivotTables, PivotCharts and dashboard views from the data model
- Write DAX measures such as year to date and previous month
- Use sets to analyze your data
This webinar is designed for Business professionals, Business owners, Financial Controllers, Accountants, and anyone who requires doing data analysis. This event is aimed at users of Excel (2010, 2013, and 2016 for Windows) who wish to learn about Power Pivot and Power Query. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot Tables.
- Business users who analyze data with Excel or create management reports
- Excel users who want to analyze large data sets and create relationships between tables
- Excel users who know how to Pivot Tables and Pivot Charts
- Excel users who wish to create interactive dashboards
- Accountants
- CPAs
- CFOs
- Financial Consultants
- Controllers
Speaker Profile
Tom Fragale
Tom Fragale is a computer professional with over 30 years of professional experience. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training …
Upcoming Webinars
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…
Human Error Reduction Techniques for Floor Supervisors
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Your AI Advantage: How HR Professionals Can Use Claude to S…
The Anti-Kickback Statute: Enforcement and Recent Updates
Empowering Conflict Resolution: Letting Go to Gain Control
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Using Copilot to Format Legal Documents in Microsoft Word
Dealing With Difficult People: At Work & In Life
Using Stay Interviews To Improve Employee Retention & Engag…
AI in Word - Smarter Writing and Document Creation with Cha…
FDA Current Trends in Compliance and Enforcement for FDA-Re…
Zero Acceptance Sampling to Reduce Inspection Costs
Why EBITDA Doesn't Spell Cash Flow and What Does?
Mastering Tough Conversations: Turn Conflict into Clarity, …
Enhancing Pivot Tables with Images: Visualize Your Data Lik…
Discover how Emotional Intelligence turns AI from a technic…
Understanding Financial Statements for Non-Financial Profes…
SOPs - How to Write Them to Satisfy those Inspectors
Managing Projects When AI Joins the Team: Human Judgment, A…