Bill Jelen

Excel in Depth – Table Formulas: Podcast #1237

               

Excel 2010: Formulas automatically fill when you are using a table!

Excel In Depth – Linking Workbooks: Podcast #1235

               

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 a.k.a. MrExcel.

Excel In Depth – Get the Cool DSUM: Podcast #1232

               

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.

Excel In Depth – Joining Text: Podcast #1230

               

From Chapter 9 of “Excel 2010 In Depth” by Bill Jelen, Episode #1230 shows 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.

Excel In Depth – Formula Entry: Podcast #1228

               

Options to enter a formula in Excel 2010 . . .

Learn Excel from MrExcel