MrExcel Excel Videos

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

Use the DAX time intelligence functions to create MTD Revenue in a PowerPivot Pivot Table. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

Perhaps you've used Calculated Fields in traditional pivot tables. DAX Measures make that feature look like it was designed by someone in kindergarten. Learn how to use the Calculate function to create DAX Measures. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

What if you need more than four PowerPivot pivot charts tied to the same set of slicers? This episode of the MrExcel netcast will show you how. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010