Create SmartArt Business Diagrams in Excel 2010 where the text for the shapes is calculated by a formula. Smart Art will add dimension to your presentations. Follow along with Episode #1250 to enhance the visual presentation of your data.
-
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.
The Picture Background Removal Tool has returned with more flexibility and a better quality image when your editing is completed. In Episode #1249, Bill shows you how to use the Background Removal feature in Excel 2010 to achieve the result you want!
Based on the examples in Professor Tufte's book, Excel can show min and max axis values in sparklines and can vary from chart to chart.
Two simple changes will dramatically improve your sparklines in Excel! Episode #1248 shows you how!
Don't recreate your data field to update your chart in Excel 2010! In Episode #1247, Bill shows (3) methods of adding that new data to an existing chart by simply extending the data field.
..."Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel
The Border Drawing Tools are back in Excel 2010! Use the border drawing tools to quickly add borders to a cell or range of cells. Learn how to find and use them in Episode #1246, with "MrExcel"
"Excel 2010 In Depth", by Bill Jelen
Microsoft took the vastly improved Equation Editor from Word 2007 and added it to Excel as a brand new feature for Excel 2010. Versatile, dimensional and very functional - in Episode #1245, Bill previews the Equation Editor and a few of its features.
Using the Microsoft Excel Macro Recorder. In Episode #1244, Bill shows you an example of how to record an Excel Macro using Relative References.
...This is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Suppose you have a model set up to perform a calculation. Using that calculation, you need to figure out how to adjust one input value to get to a certain answer - your goal. The Goal Seek command can simplify this process. "Excel In Depth" - MrExcel
Define a relationship between two tables in PowerPivot. Podcast #1242 shows you how to link tables on two different sheets to create a Pivot Table.
"Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
