Select Page

Excel Video 378 Timelines – Part 1

Excel Video 378 introduces Timelines, a new Pivot Table feature in Excel 2013. If you’re familiar with Slicers, you’ll pick up on Timelines quickly. Slicers were new in Excel 2010. If you haven’t seen Slicers, watch Excel Videos 289-290. Timelines are a way to...

Excel Video 376 Quick Analysis Totals

In Excel Video 376, the Quick Analysis button we’ve been discussing will enter a variety of totals for our data. The totals formulas are helpful, but if you’re familiar with Excel you may be able to recreate many of these totals on your own. If you aren’t as familiar...

Excel Video 375 Quick Analysis – Charts

Excel 2013’s trying to make your life a little easier with the Quick Analysis tool in Excel Video 375. The Quick Analysis tools uses built-in algorithms to look at your data and give you some ideas about how you might analyze it. Today we’ll look at the Charts section...

Excel Video 374 Quick Analysis – Formatting

Excel Video 374 showcases the Quick Analysis button, another easy shortcut in Excel 2013. If you highlight a group of data in Excel 2013, watch for the Quick Analysis button in the lower right-hand corner. The Quick Analysis button brings up a window with five...

Excel Video 373 Flash Fill

If you’re wondering whether Excel 2013 can you save you time, watch Excel Video 373. Flash Fill is a clever new feature in Excel 2013 that can quickly extract data or reformat data without complicated formulas or macros. Watch how quickly Excel can learn from an...