All Courses
Certificate
My Courses
Log In
Register
Menu
All Courses
Certificate
My Courses
Log In
Register
£
0.00
Cart
All Courses
Certificate
My Courses
Log In
Register
Menu
All Courses
Certificate
My Courses
Log In
Register
£
0.00
Cart
All Courses
Getting Results w/Excel Pivot Tables, PowerQuery &PowerPivot
Normal Pivot Table Formulas
1
Lecture
1.1
Normal Pivot Table Formulas
10 min
Sorting & Filtering the Pivot Table
1
Lecture
2.1
Sorting & Filtering the Pivot Table
06 min
Calculated Items
1
Lecture
3.1
Calculated Items
05 min
Calculated Fields
1
Lecture
4.1
Calculated Fields
05 min
Conditional Formatting in the Pivot Table
1
Lecture
5.1
Conditional Formatting in the Pivot Table
05 min
Consolidated Pivot Tables
1
Lecture
6.1
Consolidated Pivot Tables
05 min
Importing data from Excel into PowerQuery u2013 normal data
1
Lecture
7.1
Importing data from Excel into PowerQuery – normal data
10 min
Splitting & Merging Columns in the PowerQuery
1
Lecture
8.1
Splitting & Merging Columns in the PowerQuery
05 min
Calculate age in the PowerQuery
1
Lecture
9.1
Calculate age in the PowerQuery
05 min
Adding Custom Calculations in PowerQuery
1
Lecture
10.1
Adding Custom Calculations in PowerQuery
05 min
Importing data from a website into the PowerQuery
1
Lecture
11.1
Importing data from a website into the PowerQuery
05 min
Refreshing the data in PowerQuery
1
Lecture
12.1
Refreshing the data in PowerQuery
05 min
Importing data from Excel into PowerQuery u2013 formatted tables
1
Lecture
13.1
Importing data from Excel into PowerQuery – formatted tables
05 min
Importing Access, SQL Server, and text files into PowerQuery
1
Lecture
14.1
Importing Access, SQL Server, and text files into PowerQuery
10 min
Append Queries
1
Lecture
15.1
Append Queries
05 min
GroupBy Queries
1
Lecture
16.1
GroupBy Queries
05 min
Merge Queries
1
Lecture
17.1
Merge Queries
05 min
More Calculations including a conditional column in PowerQuery
1
Lecture
18.1
More Calculations including a conditional column in PowerQuery
10 min
Activating PowerPivot
1
Lecture
19.1
Activating PowerPivot
05 min
Exploring the PowerPivot menus
1
Lecture
20.1
Exploring the PowerPivot menus
05 min
Starting the Pivot Table from PowerPivot
1
Lecture
21.1
Starting the Pivot Table from PowerPivot
05 min
Managing Table Relationships
1
Lecture
22.1
Managing Table Relationships
10 min
Slicers & Timelines in PowerPivot
1
Lecture
23.1
Slicers & Timelines in PowerPivot
05 min
Using Sets in PowerPivot
1
Lecture
24.1
Using Sets in PowerPivot
05 min
Importing Data directly into the PowerPivot
1
Lecture
25.1
Importing Data directly into the PowerPivot
05 min
Measures & KPIu2019s in PowerPivot
1
Lecture
26.1
Measures & KPI’s in PowerPivot
10 min
GroupBy Queries
Lesson content is empty.
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
0
0
Your Cart
Your cart is empty
Return to Shop
Modal title
Main Content