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. ...

Sorting in the Excel Data Model can be different than what you’re used to in Excel, so Excel Video 480...

We’ll work on formatting in the Excel Data Model in Excel Video 479 today. If you’re a long time Pivot...

In Excel Video 478 we’ll start using PowerPivot and the Excel Data Model together. I’ll show you two...

Creating and managing relationships in the Excel Data Model, as we’ll do in Excel Video 477, adds...

Now that Excel Video 475 helped us load data, Excel Video 476 is about refreshing data loaded into the Excel...

Loading data into the Excel Data Model is the first step to taking advantage of the power of this new tool,...

I’m introducing the Excel Data Model in Excel Video 474. I’ll discuss a couple of cons (you can’t edit...

My objective in Excel Video 473 is configuring Excel 2013 BI tools so we can get started. The first hurdle...