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.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet

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.

Tweet

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 your DSUM function.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet

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.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet

From Chapter 9 of "Excel 2010 In Depth" by Bill Jelen, 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.

Tweet

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.

Tweet

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.

Tweet

Jump to the edge of a large data set by using the 'End' key to navigate in Excel. Episode #1227  shows you how!

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet

All work and no play makes for a long day - time for some fun!! Use the AutoCorrect options to pull a practical work on a co-worker; Episode #1226 will help you accomplish the task.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet

If you need to access the Excel 2003 dialog box for many commands, you can easily do this in Excel 2010. This episode [Episode #1225] of the MrExcel Podcast shows you how to use the dialog launchers.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet

In this episode [Episode #1224], learn how to have a loop hit every other row instead of every row using the Step command.

…This episode is the video podcast companion to the book, "VBA And Macros: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

Tweet

In this episode of the MrExcel Podcast series [Episode #1223], you will learn how to customize the Excel 2010 ribbon to suit your needs.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet

An explanation of how defined constants such as XLRight make life easier in VBA. Episode #1222 shows an example of the power and versatility of VBA in Microsoft Excel.

…This episode is the video podcast companion to the book, “VBA And Macros: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

Tweet

If you have data in Excel and want to get that data into PowerPivot, you could copy and paste, or you can use the method in this video [Episode #1221]; declare the data as a table, then create a Linked Table.

…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.

Tweet

One of the best features in Office 2010 is the new Paste Options flyout menu. Episode #1220 takes a look at how to leverage the Paste Options menu.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

Tweet