MrExcel Excel Videos

Reaching way back to the archives, the DSUM function allows for some pretty amazing criteria. This video discusses how to build smaller criteria ranges for your DSUM function.

Excel 2010 adds a new function called AGGREGATE. This function is similar to SUBTOTAL but we several new tricks, including MEDIAN, LARGE, SMALL, and the ability to ignore error values

When you are recording a macro, never use the AutoSum button. This video will show you the workaround to summing a column in a macro.

Have a loop hit every other row instead of every row using the Step command.

An explanation of how defined constants such as XLRight make life easier in VBA

One of the best features in Office 2010 is the new Paste Options flyout menu. This episode takes a look at how to leverage the Paste Options menu.

As you start to use the Excel 2010 ribbon, you will notice that it has a different arrangement of icons depending on the resolution of your monitor. This can lead to some confusion as you try to help your coworkers over the phone.

If you are going to publish your PowerPivot report to Excel Server or to SharePoint, you want it to look good. This video gives you several tips for making the report look less like Excel.

Say that you want to report actuals from last year and budget from this year. Regular pivot tables can't do that. Starting in Excel 2010, OLAP pivot tables can do that. But, that doesn't help you if you have regular old Excel data instead of OLAP cubes. However...take your regular Excel data through PowerPivot and it turns into an OLAP Cube! Thus, Named Sets become an option. Chapter 12 makes me want to run every single data set through pivot table. I need to turn back to Chapter 3 to remind myself of why not to do that...