In Chapter 2 of "PowerPivot For The Data Analyst", you will see how to import a 1.8 million row text file into the PowerPivot window.

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

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

One of the best features of Excel 2010's Backstage View is the Recently Used File List. This episode takes a look at the ins and outs of the Recently Used File list.

From October, 2005. 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.

Time Warp Wednesday is our "Thank You" to everyone who has emailed, called or posted at the MrExcel Message Board!! Enjoy!!

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
Download a new two minute video every workday to learn one of the 377 tips from the book!

PowerPivot is a free download that you can easily add to Excel 2010. It is the best product to come out of Microsoft in twenty years. Learn about the Five Main Benefits of PowerPivot with Excel 2010 from Bill Jelen a.k.a. "MrExcel".

...This episode is the video podcast companion to the book, "PowerPivot For Data Analysts: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

Tweet

An answer to the question from Podcast 1209; how do you prevent the F1 key from opening Excel help. This episode shows two methods.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

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.
Download a new two minute video every workday to learn one of the 377 tips from the book!