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. +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.

Chapter 10... 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.

Tweet

Today, in Episode #1294, Bill discusses 'High-Low Lines', 'Up-Down Bars' and why using 'High-Low Lines' (an option under the "Analysis" tab in Excel 2010) may be the way to go.

From Chapter 6...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.

Tweet

"The Amazing Expanding Formula Bar in Excel 2010!"

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."

Chapter 9... 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.

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!

…This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

In Episode #1291, Bill looks at manipulating Charts with Excel VBA [Visual Basic for Applications]. Its easy to control the exact location of your Chart by designating its placement on your worksheet - yourself! Check out Episode #1291, follow along with Bill and gain control of your Chart and where it appears each and every time!

From Chapter 11…This episode is the video podcast companion to the book, "VBA And Macros: Microsoft Excel 2010", from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Tweet

"Uh... Where is Print Preview in Excel 2010?"

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! Bill also shows you how to move about in 'Backstage View', adjust the number in the Reently Viewed file list and more!

Chapter 8... 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.

Tweet

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

From Chapter 5...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.

Tweet

Select your Pivot Table Data using Slicers. Learn how to select and work with Slicer selections in Episode #1288.

...This episode is the video podcast companion to the book, "Pivot Table Data Crunching: 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.

Tweet

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.

From Chapter 4...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.

Tweet

Todays Dueling Excel Podcast, Episode #1286, addresses a teacher's question of how to calculate the % score for a student, ignoring any assignments where the student had an excused absence. SUMPRODUCT, ISNUMBER and More in today's episode!

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“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.

Tweet

Chapter 7 of the book "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" is all about the 'Page Layout View'  introduced in Excel 2007. Today, however,  in Episode #1285 of the MrExcel Podcast Series, Bill is going to focus on Excel 2010's ability to remember the 'Last Custom Margins' used. A "Two Clicks and Done" route to your favorite margin settings once they are set up.

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.

Tweet

In Episode #1284, Bill looks at Charting Dated Data and how to get a more realistic distance between dates. Included in Podcast Episode #1284: Using " =DATEVALUE() " to convert your text dates to real numbers!

...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.

Tweet

In today's Dueling Excel Podcast [Episode #1283] Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen look at a data set and then attempt to find all of the records that contain the word "Car". Using Excel VBA [Macro] and Formula methods, Mike and Bill produce the desired results - see how they do it in Episode #1283!

…This episode is the video podcast companion to the book, “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“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.

Tweet

Today, Episode #1282 takes a look at the new Paste Options menu in Excel 2010. Specifically, Bill reviews a variety of time efficient methods to convert Excel Formulas to Values, the Paste Options available in Excel 2010 as well as that odd looking key found on the lower-right of your keyboard called the 'Context Key'.

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.

Our Sponsor, "Easy-XL", produces a fine Microsoft Excel Add-in with many, inherent, time saving features. Today, in Episode #1281, Bill looks at merging data from two (2) different worksheets using the "Easy-XL" Add-in and just a few mouse clicks! No VLOOKUP and no time consuming process! Check out Episode #1281!

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

And

"Easy-XL" From MrExcel. Add over 50 time saving data analysis and manipulation features to Excel.

For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.
Tweet