PowerPivot 3: Managing the Data Model
Analyzing ginormous files with Microsoft PowerPivot.
PowerPivot 2: What's the Deal with Delimiters?
Working with large flat files in PowerPivot.
Power to the Pivot Redux: Enter PowerPivot
Dipping into Microsoft's PowerPivot add-on for Excel.
Create an Iterative List in Excel Without Any Real Coding
Roll On Through: This isn't standard programming... THIS IS EXCEL! We get creative in Excel by making FOR loops without using VBA.
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel
Dynamically load data in smart pivot tables.
I Owe My Job to Mr. Robot
Entering the Dataverse.
Active-X Gonna Give it to Ya
Excel offers the ability to name a particular range (or collection of cells). Learn Named Ranges and the Active Xs who Love Them.
Your Invitation to the Excel Pivot Party
Becoming well-versed in pivot tables to the point where it’s a problem.
Slicing Excel: The Way of The Knife
Slicing your Excel data to be presentable for the less tech-savvy.
Yes...If(And)): Excel’s Mighty “IF” Statement
A deep dive into Excel’s implementation of IF statements and their significance.