MrExcel Excel Videos

The Basics of Excel Charting: Part I This is the first of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Today, in Episode #1405, Bill will begin by showing us the criteria for the Data Set we want to create our Chart with. By taking just words in a Microsoft Word Document, Bill will then proceed with the steps of Best Practice to get the Data from Word set up to create our Chart in Excel. Follow along to learn - from the ground up - how to proficiently Chart in Microsoft Excel 2010! ...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel. For more Excel 2010 knowledge, check out "Excel 2010 In Depth", by Bill Jelen a.k.a...

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 to 2010 using Formulas and/or PowerPivot.

The May 2011 MrExcel Challenge of the Month invites you to mash up some data from the Azure Data Market. This episode of the MrExcel Podcast demos getting data from ADM. ...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! For more Excel 2010 knowledge, check out "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today, in Episode #1402, Bill takes a look at Calculating a Weighted Average using two (2) SUMIF Functions. This Formula will need to reference Data on another worksheet as well. Learn about "SUMIF"! **The Learn Excel from MrExcel Podcast Series.**

Warren from Australia writes about choosing Lotto numbers, but =RANDBETWEEN(1,45) is giving him duplicates. Today, in Episode #1401, Bill shows us another way to solve the problem and further eliminate the probability of duplicates. "Learn Excel"

Today, In Episode #1400, Bill reviews "Change-Pro for Excel", by Litéra. This high-end tool will locate all of the changes between two versions of the same workbook. Follow along with Bill to see it work!

In Part I of "Top 2 by Industry", Episode #1394, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen showed us how to get the result. Today, in Episode #1399, Mike and Bill revisit the Top 2 method to compare formula methods.

Want to let others know that your Chart Data is current? Add a Live Title to that Chart to show that the Chart represents Data through the current date. In Episode #1398, Bill shows us how this is accomplished. ...Learn Excel 97-2007 from MrExcel.

Most people know how to make a column wider...simple, right? But what happens when someone has turned off column headers-what can I do? Today, in Episode #1397, Bill shows us what to do while discussing a variety of column width adjustment methods.