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.
Slicers are the new visual filter in Excel 2010 Pivot Tables. Learn how to make them look good. Slice, Dice and Present your data using tips from Podcast #1241.
"Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Roll daily dates up to months and years using an Excel pivot table.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Filter by Selection? In Excel 2010? Really? Where is it!? Podcast #1239 shows you! Access this 'secret command' hidden behind a wrong label in Excel. Add it to your Excel Ribbon to enable faster, more accurate filtering of your data.
Need to sort your data with a bit of a twist? Podcast #1238 shows you how to sort Excel items into a sequence that is neither AZ nor ZA.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
When you have a defined table in Excel 2010 and add a formula next to it, the formula will automatically copy to all of the rows of the table - no more double-clicking the Fill Handle! Episodes #1237 shows this intuitive time saver in action.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.