MrExcel Excel Videos

Excel 2010 now contains 400 Functions. Amongst those new Functions is a new Function called 'AGGREGATE'. AGGREGATE is similar to SUBTOTAL, but with several new tricks, including the ability to ignore Error Values. "Rev Up to Excel 2010" by Bill Jelen

PowerPivot 2010 offers the opportunity to create up to 4 Charts from your data . . . but what if you need to move beyond that to 5 or more Charts? In Episode #1306, Bill shows us how to move into the "More Than Four" dimension.

"Go Zips!" The University of Akron mens soccer team wins a National Championship- the First University of Akron sports team to win a National Championship! In Episode #1305, Bill uses the new Excel 2010 Sparkline tool to analyze this season and last.

Today, in Episode #1304, Bill shows us how to use a Pivot Table in combination with Excel VBA [Visual Basic for Applications] to 'Roll-Up' dates to weekly increments. From Chapter 13..."VBA And Macros: Microsoft Excel 2010", by Bill Jelen.

Todays Dueling Excel Podcast #1303 with Mike Girvin and Bill Jelen looks at 'Unwinding Dates'. Suppose your dates are input like this: "1997-1999" How can you have each date year list out so that they now appear as sequential: "1997 1998 1999"?

Today in Episode #1302 Bill shows us how to create a chart for each customer in our database. Using a Pivot Table to manipulate the data, some formatting and the "Show Report Filter Pages" option our task becomes simplified. From Chapter 8...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel. For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Most people know that the sum of the selected cells appear in the Status Bar at the bottom of the Excel screen. Episode #1301 will show you how to show many more statistics in the Status Bar as well. "Rev Up To Excel 2010", by Bill Jelen.

Use regular Excel pivot table tricks [Slicers and Filters] to create a PowerPivot report showing the top 5 stores for selected divisions.

Don upgraded to Excel 2010, from Excel 2003, and discovered that he could no longer easily find and use the colors he'd become accustomed to using in his workbooks. How did the Exclusive "MrExcel Color Add-In" develop from this? Watch Episode #1299.