MrExcel Excel Videos

Chapter 3 of the book is full of rants telling you why you wouldn't run every future data set through PowerPivot. PowerPivot's inability to automatically sort by custom lists is my number one complaint. PowerPivot will not automatically sort your months into custom list sequence, which means that you will get month names arranged in alphabetical sequence of April, August, and so on. This video shows the eight-click workaround.

In Chapter 2 of PowerPivot for the Excel Data Analyst, you will see how to import a 1.8 million row text file into the PowerPivot window. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

Learn about the five benefits of PowerPivot in this introductory video from MrExcel. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

Eric writes in with a frustrating question; "Why can't the macro recorder record the action of creating a pivot table? No matter what I do, it hardcodes that the original pivot data is 469 rows tall." Eric doesn't want to learn VBA, but needs enough to be able to generalize the recorded code. Episode 1211 shows you a solution.

Denise from Orlando checks in with a cool trick for converting text to numbers using the minus minus trick. Episode 1210 shows you how. Learn Excel 97-2007 from MrExcel!

Double the Power of the Recently Used File List. Episode 105 will teach you an easy customization to improve the recently used file list in Excel. Learn Excel 97-2007 from MrExcel.

Alternate shortcut keys....other ways to undo. Other ways to copy and paste. How to edit a cell comment. How to insert a new worksheet. And, a quest...how to assign F1 to do F2. Episode 1209 shows you how. Learn Excel 97-2007 from MrExcel.

Patrick asks how Excel chooses to assign icons to values when you use the icon set feature. Episode 1208 explains how the icon sets work and how to change the default behavior. Learn Excel 97-2007 from Mrexcel.

This problem is similar to episode 1206, but this time the question is how to highlight the entire row of the record with the largest value. Episode 1207 shows you how. Learn Excel 97-2007 from MrExcel!