MrExcel Excel Videos

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

Use regular Excel pivot table tricks to create a report showing the top 5 stores for selected divisions. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

I hate the compact view for pivot tables. The PowerPivot team gives us Flattened pivot tables. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

See how to calculate columns in the PowerPivot grid using DAX. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

This episode shows you how to manually define a relationship between two tables in PowerPivot. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

If you have data in Excel and want to get that data into PowerPivot, you could copy and paste, or you can use the method in this video; declare the data as a table, then create a Linked Table. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010

Chapter 3 of the book is full of rants telling you why you wouldn't run every future data set through PowerPivot. PowerPivot's inability to automatically sort by custom lists is my number one complaint. PowerPivot will not automatically sort your months into custom list sequence, which means that you will get month names arranged in alphabetical sequence of April, August, and so on. This video shows the eight-click workaround.