Slicers are the new visual filter in Excel 2010 Pivot Tables. Learn how to make them look good. Slice, Dice and Present your data using tips from Podcast #1241.
"Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Roll daily dates up to months and years using an Excel pivot table.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Filter by Selection? In Excel 2010? Really? Where is it!? Podcast #1239 shows you! Access this 'secret command' hidden behind a wrong label in Excel. Add it to your Excel Ribbon to enable faster, more accurate filtering of your data.
Need to sort your data with a bit of a twist? Podcast #1238 shows you how to sort Excel items into a sequence that is neither AZ nor ZA.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
When you have a defined table in Excel 2010 and add a formula next to it, the formula will automatically copy to all of the rows of the table - no more double-clicking the Fill Handle! Episodes #1237 shows this intuitive time saver in action.
What's in a name? Retroactively and easily make your newly created Range Names appear in prior formulas in Excel 2010.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Momentarily change the view setting, right-click and drag...Episode #1235 shows a cool way to set up a link between two workbooks simply by dragging.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen.
Need to convert values yet retain the original context of those values? You can convert English to Metric and a lot more with the versatile CONVERT function in Excel! Podcast #1234 examines this useful function..."Excel 2010 In Depth", by Bill Jelen
Use Excel 2010 to calculate your next car payment or loan payment; Episode #1233 shows the steps.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
