COURSE
Getting Results w/Excel Pivot Tables, PowerQuery &PowerPivot
How to use Excel Pivot Table, PowerQuery and Power Pivot to get great results from your data.
schedule 2 hours4.4(59 ratings)
starstar
starstar
starstar
starstar
star_halfstar
CA$79
![Course image](/_next/image?url=https%3A%2F%2Fdbtkvjd5m619u.cloudfront.net%2Fimages%2Fcourses%2F3130%2F850e73a793c10eee77b8f347a3cf6255.jpeg&w=640&q=75)
auto_storiesINSTRUCTOR(S)
![](/_next/image?url=https%3A%2F%2Fdbtkvjd5m619u.cloudfront.net%2Faccounts%2F275%2Fusers%2F9198%2Fd51f255d2ff0c02ebf47efd645af1335.jpeg&w=96&q=75)
Tom Fragale
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
About this course
CPA Alberta
CPA British Columbia
CPA Manitoba
CPA New Brunswick
CPA Nova Scotia
CPA Ontario
These days, there is tons of data coming in from many sources. You are expected to import all of that data, and then get meaningful results from that data.
This course will help you do that.
Topics include:
Normal Pivot Table Formulas
Sorting & Filtering the Pivot Table
Calculated Items
Calculated Fields
Conditional Formatting in the Pivot Table
Consolidated Pivot Tables
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
Merge 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
This course includes:
schedule2 hours on-demand video
signal_cellular_altIntermediate level
task_altNo preparation required
calendar_todayPublished At Nov 25, 2020
workspace_premiumCertificate of completion
errorNo prerequisites
lock1 year access
calendar_todayUpdated At Jul 27, 2024
HomepageBecome an InstructorLatest IntelligenceLearnFormula BusinessTerms of useContact usPrivacy policyReport AbuseHelp Center
Copyright @ 2024 CPDFormula LearnFormula | Professional Development Course Marketplace