In today's Dueling Excel Podcast [Episode #1256], Mike and Bill work on a formula that adds up all of the non #N/A values in a range. Traditional Excel meets Excel 2010 - and a few new menu items!

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
AND
"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

One of the great things to return to Excel 2010 is the ability to customize the ribbon - without knowing XML and without being a programmer! Customize the Ribbon in Excel 2010 to make the interface more efficient for your needs. Episode #1255 and Chapter 2 of "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" by Bill Jelen show you how.

• 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

As a follow-up to Episode #1252,  "Once you've used the HLOOKUP to return the last value in the row, can you find the date associated with that entry?" Yes, you can!  Today, in Episode #1254, Bill shows us how to locate the last value in a row of data and return that value to our designated cell using the INDEX and MATCH Functions.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Tweet

A 3-D Reference (also known as a 'Spearing Formula') is when you need to shoot through a series of worksheets to add up the same cell on many worksheets. Episode #1253 shows you how to create these references in just a few clicks!

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", 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

A question from my seminar at the NAESA conference in New Orleans (September 2010): "How can I return the last value entered in a particular row?" Episode #1252 will show you how.

...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Tweet

Podcast #1251 introduces my newest book, "Rev Up to Excel 2010 - Upgraders Guide to Excel 2010". In Chapter 1, Today I take a look at how to get the elusive mini toolbar to appear.

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

Create SmartArt Business Diagrams in Excel 2010 where the text for the shapes is calculated by a formula. Originally a Power Point feature, Smart Art can and will add dimension to your spreadheet and charts. Follow Bill's example -here in Episode #1250- to enhance the visual presentation of your data.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", 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 Picture Background Removal Tool has returned (with Excel 2010) with more flexibility resulting in a better quality image when your editing is completed. In Episode #1249, Bill shows you how to most effectively use the Background Removal feature in Excel 2010 to achieve the result you want!

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", 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

Based on the examples in Professor Edward Tufte's book, the Excel team decided that the min and max axis values in sparklines should vary from chart to chart. Two simple changes can dramatically improve your sparklines in Excel 2010, making comparisons easier! Check out Bill Jelen's example in Episode #1248 to add some "Spark" to your chart!

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", 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

Don't recreate your data field to update your chart in Excel 2010! In Episode #1247, Bill shows three (3) methods of automatically adding that new data to your existing chart without having to entirely recreate the chart by simply extending the data field.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", 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

Originally part of Excel 2003, 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 Bill Jelen a.k.a. "MrExcel"

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", 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

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.

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

Tweet

Using the Microsoft Excel Macro Recorder. In Episode #1244, Bill shows you an example of how to record an Excel Macro using Relative References to get the job done!

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

Tweet

Let us suppose that you have a model set up to perform a calculation. In using that calculation, you need to figure out how to adjust one input value to get to a certain answer - that 'certain answer' being your goal. The Goal Seek command demonstrated here, in Episode #1243, can simplify this process.

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

Tweet

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.

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

Tweet