MrExcel Excel Videos

Finishing off the 'Learn Excel with MrExcel Podcast Series' on Charting Basics this week, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen look at The Title of the Chart we've created. Today, in Episode #1409, Bill shows us how to use Data from the Chart itself to Create a Dynamic Chart Title and Mike shows us two (2) variations on the theme. Also, in Episode #1409, you will learn a few Shortcuts and a few tips on better navigating the Excel 2010 User Interface while working with your Chart. Dueling Excel Podcast #80...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...

The Basics of Excel Charting: Part IV This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously we'd set up our Data Set, Created our Chart and made adjustments to our Chart Axis. Today, in Episode #1408, Bill shows us how to Change our Chart Title, set up a comprehensive Legend and adjust the colors of our charted data. ...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 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"