MrExcel Excel Videos

Abhijeet took INDIRECT to the extreme - 1200 formulas, each looking at 5600 records and the recalc time is taking too long. Two ways to build those formulas without INDIRECT.

Good news: The new Surface ads feature Excel. Bad news: there is a spreadsheet error in the ad. Read the original blog post from David Yanofsky here: Microsoft botched the Excel spreadsheet in its Surface tablet ad This episode of the podcast looks at how the spreadsheet could be totaling incorrectly and teaches you why you should not use =B1+B2+B3+B4+B5. Also - how did they get the gaps in the pie chart?

David from Fort Myers has one worksheet for each expense category. The total row appears on a different row in each worksheet. On a Summary worksheet, he would like to grab the totals from each worksheet. In today's episode, how to use INDIRECT as the 2nd argument in VLOOKUP to solve the problem.

Andrew and David have similar Excel issues - they need a Summary worksheet to return values from all other worksheets and want a simple way to enter one formula that can be copied to point to the other worksheets. Today, in episode 1822, how to use INDIRECT to solve the problem when the Total row is on the same row in every worksheet.

The Excel 2010 & 2013 macro recorder will not record how to stack and scale a picture fill in a chart. This episode shows two different sets of code to control the stack and scale settings.

You copied some Excel VBA code from the Internet, but when you try to run it, you get a compile error with Sub or Function Not Defined. This video shows you what might be causing that error and how to find the line to fix.

Juan is charting three series. The first two series have a similar order of magnitude, the third series is very small. Episode 1819 shows how to build this chart in either Excel 2010 or Excel 2013.

Use View, New Window to allow comparing two worksheets of the same workbook side by side.

Jim from Timken shares a trick to prevent typing extra zeroes, even if you are entering 0.000012. This trick works for entering numbers in thousands, millions, thousandths, millionths or any order of magnitude.