Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Dedications
Acknowledgements
Foreword
Introduction
Chapter 1: Dashboard Tricks and Visualization Techniques
Adding a “Last Refreshed Date” Readout
Normalizing Your Measures to First/Average/Max Values for Charts
Bubbling Up Exceptions with “Sarah Problem”
Ranks and Exceptions That Bubble Up to Subtotals
Chapter 2: Slicers: The Gateway to Interactivity
“Initializing” Slicers That Contain Too Many Values to Scroll
Wingdings and Other Symbolic Fonts in Slicers
Using Macros to Change Slicer Fonts
A Simple Trick for Combatting “Stale” Slicers
User-Friendly Report Sorting with Slicers
Adding State Alpha Sorting to the Sort-by-Slicer Trick
Conditional Formatting Controlled via Slicers
Catching Slicer Selections in a Formula
Chapter 3: Conquering Common Calculated Column Conundrums
An Excel Pro’s Primer on Calculated Columns
Subtotaling Calc Columns and the EARLIER() Function
Referencing the Previous Row and Similar Calcs
Referencing Rows “Within Range” of the Current Row
Totaling Data Table Values in Lookup Tables
CONTAINSX: Finding Matching Values in Two Tables
CONTAINSX Revisited: What Is the Match?
Common Calendar Conundrums
Custom Calendar Conundrums
Chapter 4: Modeling and Portable Formulas
Integrating Data of Different “Grains”
A Mystifying and Awesome Solution for the Many-to-Many Problem
Calculating Same-Store Sales in Power Pivot
Same-Store Sales Continued: Using Store Open/Close Dates
Campaign Analysis: Seasonally Adjusted Measures
A/B Campaign Analysis with Start and End Date Slicers
Customers and Website Visitors: Percentage Who Return
Calculating Average Customer Age
Moving Averages, Sums, etc.
Moving Averages Controlled by a Slicer
Chapter 5: Power Query
Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table
Using Power Query to Merge CSV Files
Using Power Query to “Unpivot” a Table
Using Power Query to Create a Lookup Table from a Data Table
Creating a Calendar Table: Advanced Usage of Power Query
Chapter 6: Power View
How to Use Power View
Chapter 7: Power Map
← Prev
Back
Next →
← Prev
Back
Next →