MrExcel Excel Videos

Due to a strange accounting error, I had to reduce 7 invoices by 80%. I had filtered to those 7 invoices. Copied 0.2 to the clipboard. I was about to Paste Special Multiply, when I wondered if it would work correctly. Episode 1900 shows you the result.

All week, I've been testing a Responsive Web Design (RWD) for a new section of MrExcel.com called the Excel Mall. It is Friday afternoon, and I am looking for some people with a variety of phones (Android, Windows, iPhone) or tablets to give the new site a spin and let me know if the site is rendering OK on your device? http://www.mrexcel.com/Excel_Utilities.html

You have a main table and two lookup tables. You need to use all three tables in a pivot table. Bill shows Power Pivot and Mike shows VLOOKUP in Dueling Excel episode 161

Can you have the height and width of a rectangle in Excel change in response to formula cells in the worksheet? Episode 1899 shows a Worksheet_Calculate event handler that does the trick.

You have a column of numbers. Select the column. Totals appear in the status bar. But they are wrong. Turns out a lot of the numbers are not in the total. The green triangles are not showing up to indicate text. There is no apostrophe. What is going on? This episode includes an open letter to the Excel team from all of us, asking for TRIM and CLEAN to start handling CHAR(160) - the Non-Breaking Space.

Char asks: When you have a column chart with a mix of positive and negative numbers, the month labels are appearing near the axis instead of at the bottom of the chart. How can you move the labels to the bottom of the chart? As a bonus, this podcast shows how to have the positive numbers in green and the negative columns in red. Covers both Excel 2013 and Excel 2010.

Sum all of the negative values from this range, but only if the row ID matches a particular value. Mike and Bill duel it out in Excel. Although Mike comes up with a single-cell formula and Bill needed many helper cells, when we used Charles Williams Fast Excel V3, the helper cell solution was faster.

The dueling Excel podcasts return with a new theme song from Sziliva Juhasz, a new voiceover from Charles "Fast" Williams, a D function from ExcelisFun, and more in this three-way lookup problem.

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