MrExcel Excel Videos

VBA & Macros 2010 - Defined Constants: #1222

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 is the podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen

View full article »

Linking Tables with PowerPivot - Podcast #1221

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 to declare the data as a table, then create a Linked Table.

View full article »

Time Warp Wednesday - Episode 107

Podcast #107 shows you how to change the direction of the cursor to match data keying - Move from cell to cell in the same direction as your data entry. Learn Excel 97-2007 from MrExcel.

View full article »

Make F1 be F2 - Episode #1213

An answer to the question from Podcast 1209; how do you prevent the F1 key from opening Excel help. This episode shows two to assign the F1 key to Edit. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.

View full article »

1Q 2010 -- Podcast #1212

Clive provides a great tip for filling years and quarters using the Fill Handle. Episode #1212 shows you how. ...This blog is the video podcast companion to the book,Learn Excel 97-2007 from MrExcel - learn one of the 377 tips from the book!

View full article »

Excel In Depth - Dwight to Diapers: Podcast #1226

Use the AutoCorrect options to pull a practical work on a co-worker.

View full article »

Excel In Depth 9 - Joining Text

Join text from column A with text from column B using the concatenation character. This video is from Chapter 9 of Excel 2010 In Depth

View full article »

Excel In Depth 33 - Sparkline Axis

Based on the examples in Professor Tufte's book, the Excel team decided that the min and max axis values in sparklines should vary from chart to chart. Two simple changes can dramatically improve your sparklines.

View full article »

Excel in Depth 32 - Charts Add Data

Add new data to an existing chart. Learn two easy ways.

View full article »