MrExcel Excel Videos

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.

Starting in Excel 2007, you could sort by color. In today's Episode, #1317 of the "Learn Excel from MrExcel" podcast series, Bill shows us how to sort a database where the sales reps have been identified by cell color. Chapter 15 ... This episode is the video podcast companion to the book, "Rev Up to Excel 2010: Upgraders Guide to 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. Considering Upgrading to Excel 2010? Want some help in making an informed decision? Check out Bill Jelen's Blog Post: "Upgrade to Excel 2007 or Excel 2010?"

Saying good bye to 2010 and welcoming in 2011, Mike "Excel Is Fun" Girvin and Bill "MrExcel" Jelen present you with "Red Over 140". In todays Dueling Excel Podcast [Episode #1316] Mike and Bill use a variety of methods to track values that exceed a predetermined threshold. Maybe you'll also need information in cells adjacent to the exceeded value - they'll show you how to get that too!

"If you've seen one of my seminars, you know that my favorite trick is to Double Click the Fill Handle to copy a formula down the the Data Set. Excel 2010 handles blank cells in the adjacent column much better than in previous versions." - Bill Jelen