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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from 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.
Today, in Episode #1298, Bill "MrExcel" Jelen and Mike "Excel Is Fun" Girvin set out to create a 'median' of test scores by moving down rows and across column by simply working in the Formula Bar. Also the F9 Evaluation Feature is highlighted today!
The 'Go To Special' Dialog in Excel 2010. Today, in Episode #1297, Bill looks at the 'Go To Special' Dialog as he shows us how to leverage the Special Cells property to quickly select all rows to hide or delete, using VBA in Microsoft Excel.
In today's episode, #1296, Bill shows us how to mix Chart types in Excel 2010 so that we may present two (2) distinct Orders of Magnitude in a single Chart! Watch and see how its done!
"Charts And Graphs: Microsoft Excel 2010", by Bill Jelen
