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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
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.
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!
Chapter 7 of "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" is all about the 'Page Layout View' introduced in Excel 2007. Today, in Episode #1285, Bill is going to focus on Excel 2010's ability to remember the 'Last Custom Margins' used.
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(). "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen
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!
Episode #1282 takes a look at the new Paste Options menu in Excel 2010. Specifically, Bill reviews a variety of time methods to convert Excel Formulas to Values in Excel 2010. "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" by Bill Jelen
