MrExcel Excel Videos

Conditional Formatting offers the ability to mark duplicates or uniques, but it sort of missed the boat. Today, in Episode #1326, Bill looks at how to use a formula-based conditions with VBA to fill voids left by Conditional Formatting.

The Subtotal command in Excel 2010 allows you to quickly add subtotals to a Data Set. In Episode #1325, Bill shows us how to collapse the results to show only the subtotals and then how to bring the largest subtotals to the top of the results.

Today Bill shows us how to sort a pivot table field using a custom list as this requires too many steps in PowerPivot. ...This is the podcast companion to "Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.

Dueling Excel Episode #1323 with Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen looks at Charting methods on both sides of the number line in both Excel 2007 and Excel 2010. Learn Shortcuts, formulas and inherent functions in this episode

Today, in Episode #1322 of the Learn Excel from MrExcel Podcast, Bill shows us how to have dynamic text within a shape. Use a formula and the Shape tool in Excel 2010 to produce a dynamic visual presentation of your data! From Chapter 11

Excel 2010 added a cool new search box to the Filter dropdown. Today, in Episode #1321 of the Learn Excel from MrExcel podcast, Bill looks at filtering by multiple [keyword] searches to display results for an industry.

PowerPivot enables something called "Asymmetric Reporting". Asymmetric Reporting creates the ability to report Actuals for last year and Budget for this year. Watch as Bill demonstrates this feature of Power Pivot in Episode #1320 today.

Today, in Episode #1319, Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen show us the options available to create a formula that defines the address of a cell containing a total. Using VLOOKUP, MATCH the ADDRESS Function and a few other tricks, getting that address becomes easy! Dueling Excel Podcast #61...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. AND "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Data is great stuff. Adding a visual component to enhance the appeal of your data? Awesome! Today, in Episode #1318, Bill shows us how to use Microsoft Map Point in conjunction with our Data Set in Excel 2010 to produce a great visual! Try it! From Chapter 10...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.