by Nate Moore | Jan 5, 2015 | Charts, Excel 2013
Happy 2015 everybody! We’re kicking off the new year with a new series about Excel 2013 Charts. We’ll start with a new feature in Excel 2013, Recommended Charts. Watch how Excel reviews our data and provides recommendations for how to chart the data. It’s easy to see...
by Nate Moore | Mar 3, 2014 | Excel 2013, Tables
My friend John O’Connor in Missoula, Montana taught me the formatting trick I’ll show you in Excel Video 401. Last time we added a Table Style that made our data look better. If you want to customize that Table Style, here’s how to do it. Notice in the video that you...
by Nate Moore | Nov 25, 2013 | Excel 2013, Tables
Our advanced filters get a little more complicated in Excel Video 389. Today we’ll add more criteria so that our filters look for a AND b OR c AND d. Notice how everything on the same row of my advanced filter criteria is an AND filter and that each separate row is an...
by Nate Moore | Nov 11, 2013 | Excel 2013, Tables
Excel Video 387 has more tricks with Table Slicers in Excel 2013. We’ll start by showing how easy it is to delete a Slicer when you’re done with it. We’ll align and group Slicers to make them appear as you’d like on the screen. Also watch for how to use the Selection...
by Nate Moore | Nov 4, 2013 | Excel 2013, Tables
If you like Slicers, you’ll be happy to watch Excel Video 386 and see that they’ve been added to Tables in Excel 2013. If you haven’t seen Slicers, they’ve been available in Pivot Tables since Excel 2010. You can see Slicers in Pivot Tables by watch Excel Videos 289...
by Nate Moore | Oct 28, 2013 | Excel 2013, Tables
The Search Box is another way to filter your data in Excel Video 385. The Search Box lets you look for text anywhere inside your data. That’s helpful, but the Add current selection to filter check box is even more helpful because it allows you to do an “or” filter....
