MrExcel Excel Videos

As you know, you can customize the Quick Stats to show you Sum, Average, Count, Max, Min, and Count Numeric. But...what if you wanted to copy those values to the clipboard so you could paste them somewhere? I had fun with today's podcast, finding code from Nate Oliver, Juan Pablo Gonzalez and then finally Chip Pearson to solve the last part of the problem. Just as Szilvia Juhasz's closing theme music started to play, I thought to myself... "this would be a whole lot better if it would paste as formulas instead of static values", so I paused the recording and tried it out. This podcast will be useful for anyone who needs to copy a VBA variable to the Excel clipboard for later pasting. See the accompanying blog post: Copy the Quick Stats...

Well, we are going off the beaten path today, for something incredibly arcane. Several people in a company have a problem where the comma format in Excel is showing only one comma, even when you have 1234,567.89. This problem might be unique to the tiny dual-island nation of Trinidad and Tobago. Episode 1893 shows you why.

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