Dueling Excel – Percent of Parent: Podcast #1404

May 13, 2011

Another Dueling Excel Podcast with Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen. Today, in Episode #1404, Mike and Bill look at finding the Percent of the Parent Row Total in Excel 2003, Excel 2007 and Excel 2010 using Formulas, PowerPivot and some easy to learn techniques.

Dueling Excel Podcast #79…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“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. Entry filed under: PowerPivot, Excel 2010 In Depth, Rev Up To Excel 2010, Learn Excel 97-2007, Dueling Podcasts, Pivot Table Data Crunching, Excel 2010, Slaying Excel Dragons, MrExcel Products, Excel 2007, PowerPivot 2010, Learn Excel from MrExcel, New MrExcel Publication, Mike Girvin and Bill Jelen, MrExcel Podcast, Excel and PowerPivot, Azure Data Marketplace, Excel 2003. Tags: 2007, 2010, accounting, Bill Jelen, business, Excel, Excel 2003, Excel 2007, Excel 2010, formula, MrExcel, Percent of Parent Row Total, Percent of Total, Pivot Table, PowerPivot, spreadsheets, technology, tutorial, Worksheet.

Be the first to like this post.

View the original article here

Dueling Excel-Charting Positive and Negative: Podcast #1323

January 14, 2011

Dueling Excel Episode #1323 with Mike “Excel Is Fun” Girvin and Bill “MrExcel” Jelen looks at Charting methods on both sides of the number line in both Excel 2007 and Excel 2010. Learn Shortcuts, formulas and inherent functions in this episode!

Dueling Excel Podcast #61…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. [Coming early 2011!!]

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions. Entry filed under: Dueling Podcasts, Excel 2007, Excel 2010, Excel 2010 In Depth, Slaying Excel Dragons. Tags: 2010, accounting, Bill Jelen, business, charting, charts, Data, Dueling Excel, Excel, Excel 2007, Excel 2010, formula, Functions, MrExcel, spreadsheets, technology, tutorial, Worksheet.

Be the first to like this post.

View the original article here

Dueling Excel – Three Way Lookup: Podcast #1328

January 21, 2011

Today, in Episode #1328, Mike “Excel Is Fun” Girvin and Bill “MrExcel” Jelen look at a question posed by ‘Raymond30031' from YouTube. Basically, arranging 2 Criteria with Multiple Ranges to give us our result, Mike and Bill use the INDEX, INDIRECT and MATCH Functions to lookup the data. Also learn keyboard shortcuts to maneuver through your spreadsheets easily!

Dueling Excel Podcast #63…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. [Coming early 2011!!]

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions. Entry filed under: Dueling Podcasts, Excel 2010, Excel 2010 In Depth, Slaying Excel Dragons. Tags: Bill Jelen, business, Data, Dueling Excel, Excel, Excel 2010, formula, Function, Functions, INDEX, INDIRECT, Learn Excel, MATCH, MrExcel, shortcuts, Spreadsheet, spreadsheets, technology, tutorial, VLOOKUP, Workbook, Worksheet.

Be the first to like this post.

View the original article here