MrExcel Excel Videos

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

Excel 2010 offers a variety of ways to zoom waaaaay in or waaay out. Today, in Episode #1295, Bill uses the MrExcel Podcast to take a look at zooming in Excel 2010. Zoom in +10% increments, -10% increments, use the Control Key and the Mouse Wheel, use the Zoom Dialog to set a precise zoom percentage... Episode #1295 shows you how.

Today, in Episode #1294, Bill discusses 'High-Low Lines', 'Up-Down Bars' and why using 'High-Low Lines' may be the way to go...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen

Today in Episode #1293, Bill takes a look at the Formula Bar in Excel 2010: "...you will never have a long formula spilling over the formula bar and covering your worksheet cells."... "Rev Up to Excel 2010: Upgraders Guide to Excel 2010"

In Episode #1292, Bill tells us why he doesn't really care much for the Compact Layout of Pivot Table data and why it is limiting - and sometimes time consuming to work with. What to do? Use the 'Flattened Pivot Table' option in Excel 2010!

In Episode #1291, Bill looks at manipulating Charts with Excel VBA. Its easy to control the exact location of your Chart by designating its placement on your worksheet. ...a podcast from Ch.11 -"VBA And Macros: Microsoft Excel 2010", from Bill Jelen.

Today, in Episode #1290, Bill looks at Chapter 8 of his book, ""Rev Up to Excel 2010: Upgraders Guide to Excel 2010" where the topic is Print Preview in Excel 2010 - Find it; Use it; Tweak it!