by Nate Moore | Oct 26, 2015 | Business Intelligence, Excel 2013
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...
by Nate Moore | Oct 19, 2015 | Business Intelligence, Excel 2013
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...
by Nate Moore | Oct 12, 2015 | Business Intelligence, Excel 2013
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...
by Nate Moore | Oct 5, 2015 | Business Intelligence, Excel 2013
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...
