MrExcel Excel Videos

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!

In Episode #1289, Bill shows you how to compare two populations by mirroring their Bar Charts back to back. You will also learn how to turn a column negative using 'Paste Special, Multiply', display a negative number as a positive and more!

Select your Pivot Table Data using Slicers. Learn how to select and work with Slicer selections in Episode #1288. ...This episode is the video companion to the book, "Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.

Today, in Episode #1287, Bill looks at the dilemma of too many slices cluttering your Pie Chart and shows you how to move those smaller slices to their own Chart within the same graphic display. "Charts And Graphs:Microsoft Excel 2010" by Bill Jelen.