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.
-
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.
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.
Reaching way back to the archives, the DSUM function allows for some pretty amazing criteria. Episode #1232 discusses how to build smaller criteria ranges for DSUM.
This episode is the podcast companion to "Excel 2010 In Depth", by Bill Jelen.
Excel 2010 adds a new function called 'AGGREGATE'.
This function is similar to SUBTOTAL, but with several new tricks, including MEDIAN, LARGE, SMALL, and the ability to ignore error values. Episode #1231 explores this new Excel Function.
From Chapter 9 of "Excel 2010 In Depth", learn how to join text from column A with text from column B using the concatenation character.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Episode #1229 shows you how to manually define a relationship between two tables in PowerPivot.
...This episode is the video podcast companion to the book, "PowerPivot For The Data Analyst: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.
There is more than one way to enter a formula in Excel. Episode #1228 shows three (3) ways to successfully enter a formula in Excel.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
