Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Mastering Excel
Follow Along Workbooks
Introduction
What is Power Query?
Installing Power Query
Connecting to Data Sources
Workbook Queries
Query Editor
CSV Files
Append Queries
Merging Queries
Transform Tab
Add Column Tab
More Power Query Tricks
Summary
Mastering Excel
Introduction
What is PowerPivot?
Installing PowerPivot
Connecting to Data Sources
Managing Data
Hierarchies
Calculated Columns
Calculated Fields
KPI
Calendar Table
Dashboards
Mastering Excel
Introduction
What is PowerView?
Installing Power View
Excel 2016
Tables
Power View Sheets
Matrix Tables
Drill Down
Cards
Basic Power View Charts
Power View Fields (for Charts)
Data Filters
View Filter
Object Level Filters
Adding Text Boxes
Slicers
Filter and Slicer Interaction
Advanced Charts
Play Axis
Tile
Using Charts as Slicers
Cross Chart Interactions
Images
Data Bound Images
An Important Note about Images
Mapping Data
Conclusion
Mastering Excel
What is Power Map?
Installing Power Map
Data Connectivity
Data Sources
Region Maps
Map Properties
Filters
Data Cards
Layers
Mapping Confidence
2D Charts
Timelines
Timeline Options
Power Map Movies
Create Video
Custom Maps
Other Lessons
← Prev
Back
Next →
← Prev
Back
Next →