The theory is that when you use the Excel Data Model, all of the calculations and aggregations you need can be built into the model. That’s great when it works, but if you need to make calculations, Excel Video 491 shows you how easy it is to do aggregations in Power...

Excel Video 490 is an introduction to the basics of Power View tables. We’ll create and delete tables, resize and move tables, add and remove columns, and reorder columns. The idea is that Power View is a way to quickly visualize and understand data.

Happy 2016 Everybody! If you’re watching these videos as they’re released at mooresolutionsinc.com, this is the first Excel Video of 2016. We’ll hit 500 Excel Videos this year in not too many weeks. I have a celebration planned with a free giveaway, so stay tuned. In...

In Excel Video 488 I’ll show you a clever way to do Power View filtering using charts. Watch how I configure a chart to be used as a filter. It makes the filtering interactive and informative at the same time. You can select multiple chart elements to filter at a time...

I have 6 Power View filtering tips for you in Excel Video 487.  The first tips are easy ways to minimize and close the filters area.  You won’t necessarily make your visualization area bigger, but it does make it easier for your users to focus on the data they need to...

Power View filtering can add power and flexibility to your visualizations. There are a couple of ways to do power view filtering, so we’ll start with the basics in Excel Video 486. If you’ve filtered Tables or Pivot Tables in Excel, the filtering menus I’ll describe...

Sorting Power View visualizations is where we’ll start our review of Power View basics in Excel Video 485. Watch how easy it is to sort a table and a matrix by simply clicking on the column heading. Also note that a table can only be sorted by one column at a time,...

We’ll continue our discussion about getting started with Excel Power View in Excel Video 484. Watch for things that are easy to do in Power View but hard to do in a traditional Excel spreadsheet, and vice versa. We’ll chart our data a couple of different ways with...

Now that we have PowerPivot, Power View, Power Query and Power Map installed, set up and configured, we’re getting started with Power View in Excel Video 483. If you haven’t watched Excel Videos 472 to 482, this video will make a lot more sense once you have Excel...

Excel Video 482 explains the rationale for building a date table in the Excel Data Model. Remember that tools like PowerPivot and Power View don’t allow you to group date fields like you can group in a traditional Pivot Table. Our objective today is building a date...

Excel Video 481 has two parts. First I’ll show why and how the Hide from Client Tools option is used when hiding columns in the Excel Data Model.. Excel Video 480 showed how sorting columns work and why they’re important. Sorting columns are important, but once...

Sorting in the Excel Data Model can be different than what you’re used to in Excel, so Excel Video 480 walks through a solution. Dates like January and February or weekdays like Monday and Tuesday sort the way you expect in Excel. In some of the BI tools like Power...

We’ll work on formatting in the Excel Data Model in Excel Video 479 today. If you’re a long time Pivot Table user, you’re familiar with changing number formats using the Value Field Settings menu. Today we’ll change the formatting for numbers and dates in the Excel...

In Excel Video 478 we’ll start using PowerPivot and the Excel Data Model together. I’ll show you two ways to build a Pivot Table with the Excel Data Model we’ve created so far. We’ll cover more about PowerPivot and Pivot Tables in future Excel Videos. The goal for...

Creating and managing relationships in the Excel Data Model, as we’ll do in Excel Video 477, adds tremendous power and flexibility to our analysis. In a typical Pivot Table, you can only pivot data from one table. If you wanted to combine data from multiple tables,...

Now that Excel Video 475 helped us load data, Excel Video 476 is about refreshing data loaded into the Excel Data Model. Watch out for the yellow warning bar. I see that very frequently in practices I work with. By default, Microsoft blocks external content to protect...

Loading data into the Excel Data Model is the first step to taking advantage of the power of this new tool, and that’s the subject of Excel Video 475. Excel has a new tool called Power Query that can load data into the Excel Data Model and transform the data to meet...

I’m introducing the Excel Data Model in Excel Video 474. I’ll discuss a couple of cons (you can’t edit data, formulas will take some getting used to, and you may need 64 bit Excel) as well as several pros (the Excel Data Model holds way more than 1 million rows, is...

My objective in Excel Video 473 is configuring Excel 2013 BI tools so we can get started. The first hurdle is to get the right version of Excel. You either need the Pro Plus version of Office 365, the Professional version of Office 2013, or...