MrExcel Excel Videos

The Basics of Excel Charting: Part III This is the third of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously, we'd set up our Data Set and proceeded into Creating our Chart; today we will look at changing our Chart Scale. Excel uses a setting called 'Auto' to figure out the low and high point along the edge of the chart. Many charting gurus suggest that you need to take more control over those settings. Today, in Episode #1407, Bill will show us how to change our Chart Scale or Chart Axis settings in Excel. ...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...

The Basics of Excel Charting: Part II This is the second of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Yesterday, we set up our Data Set to be used for the Chart. Today, in Episode #1406, Bill begins creating the Chart from the Data Set. Also, learn how to access your Charting Tools in Excel once your Chart is created. ...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. MrExcel. For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for Excel Tips and Solutions.

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.