by Nate Moore | Sep 7, 2015 | Business Intelligence, Excel 2013
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...
by Nate Moore | Aug 31, 2015 | Business Intelligence, Excel 2013
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 the standalone version of...
by Nate Moore | Aug 3, 2015 | Charts, Excel 2013
There a couple of ways to change chart plot order, the order that Excel plots data in a chart. I’ll show you two examples in Excel Video 471. As we’ve discussed in previous Excel Videos, having your chart data in a Table makes life easier. It’s easy to sort data in a...
by Nate Moore | Jul 27, 2015 | Charts, Excel 2013
Excel Video 470 is an easy video with three ways to delete data from a chart. Before we get to the three tips, please note that Excel 2013 makes it so easy to filter data from a chart that I only delete chart data that I never ever plan to chart again. Another tip is...
by Nate Moore | Jul 20, 2015 | Charts, Excel 2013
I have a tip in Excel Video 469 that I hope will save you some trouble when you’re creating charts with years. Watch how I chart the same set of data with one slight difference that makes a huge impact on how Excel sees years. If we set the chart data up correctly,...
by Nate Moore | Jul 13, 2015 | Charts, Excel 2013
The trick in Excel Video 468 is to use Tables as a chart data source. If you haven’t seen Tables in Excel, there’s a section with several playlists about Tables on my website that’s absolutely worth watching. Tables are a great way to organize detailed data. Watch how...
