MrExcel Excel Videos

Excel MVP Charles "Fast" Williams just released V3 of his Fast Excel add-in. I had the opportunity to see Charles demo this product recently in Amsterdam and it blew me away. This review shows some of my favorite features of the product.

If you are great at Excel and lousy at Photoshop, why not use the Excel SmartArt tools to rapidly create prototype graphics for your web designer? All you have to worry about is the message and Excel will make the graphics look good. The SmartArt book is on sale at http://www.tinyurl.com/smartart14

Ryan has a data set where all of the fields are going down column A and he would like to take this column of data back into a rectangular range. Normally, I would use a macro to do this, but today, a single INDEX formula copied through the range does the trick.

There are too many ways to copy charts from Excel to PowerPoint. Do it wrong, and the person with your PowerPoint can access the entire Excel Workbook. Ever since Office 2010, I prefer using the Screen Clipping Tool to get a perfect representation of the chart. This tool is great for copying screenshots from the web or any application into your Excel, Word, or PowerPoint documents.

I used to solve this problem with Home, Find & Select, Go To Special, Blanks, OK, 0, Ctrl+Enter. There is a faster way, using Ctrl+H, as shown in today's episode.

Phoebe from Florida has a spreadsheet where gridlines are missing from just one section of the worksheet. Today, two theories on how that happened, how to fix it, and, since we are covering gridlines, how to toggle gridlines off and on for the whole workbook and how to change the gridlines to an annoying red color.

When you run your data through PowerPivot, you can not group daily dates up to Months & Years as you can with a regular pivot table. Episode 1886 shows how to use a Calendar table to group and sort in Power Pivot. Check out the new Power Pivot Alchemy book at Power Pivot, PowerPivot, Excel, Excel 2010, Excel 2013, Microsoft Excel, Microsoft Power Pivot

Have you ever discovered crazy steps that will actually cause the macro recorder to work? In today's episode, I share my way to have the Macro Recorder successfully record the AutoSum. But, I am looking for a way to use the macro recorder to record a Sort.

Mysteriously, some Excel cells are showing a leading space. But when you double-click to edit the cell, the leading space disappears! The cells are left-justified, no indent. What is causing the problem?