
Getting Started with Excel 2013 Power Tools
Excel Video 482 Building a Date Table
Excel Video 482 explains the rationale for building a date table in the Excel Data Model. Remember that...
Excel Video 481 Hiding Columns in the Excel Data Model
Excel Video 481 has two parts. First I’ll show why and how the Hide from Client Tools option is used. ...
Excel Video 480 Sorting in the Excel Data Model
Sorting in the Excel Data Model can be different than what you’re used to in Excel, so Excel Video 480...
Excel Video 479 Formatting in the Excel Data Model
We’ll work on formatting in the Excel Data Model in Excel Video 479 today. If you’re a long time Pivot...
Excel Video 478 PowerPivot and the Excel Data Model
In Excel Video 478 we’ll start using PowerPivot and the Excel Data Model together. I’ll show you two...
Excel Video 477 Relationships in the Excel Data Model
Creating and managing relationships in the Excel Data Model, as we’ll do in Excel Video 477, adds...
Excel Video 476 Refreshing Data Loaded into the Excel Data Model
Now that Excel Video 475 helped us load data, Excel Video 476 is about refreshing data loaded into the Excel...
Excel Video 475 Loading Data into the Excel Data Model
Loading data into the Excel Data Model is the first step to taking advantage of the power of this new tool,...
Excel Video 474 Introducing the Excel Data Model
I’m introducing the Excel Data Model in Excel Video 474. I’ll discuss a couple of cons (you can’t edit...