MrExcel Excel Videos

Dueling Excel with Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen looks at 'Employee Review'. Its that time again and We want to show each employee their performance. While rated against everyone else, we only show the name of the employee. In Episode #1662, we will learn two ways to create this Chart. Also watch as Bill struggles to remember how to make a Chart Title all caps and how he whacks out the Recommended Charts feature in Excel 2013. Dueling Excel Podcasts...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. Slaying Excel Dragons [Currently available in eBook / Print Edition and as a...

Conrad says that some numbers are more popular than others - it's not completely random. I have 1000 results from the Roulette Gaming; How can I easily view which numbers are 'Hot' and which ones are 'Overdue? Follow along with Episode #1661 as Bill guides us through creating a Pivot Table and a Filter Scheme that will allow us a more Dynamic measure of the Data. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com...

Did you ever have a need to keep a small bit of information ever present as you move through your Worksheet Data? Today, in Episode #1660, Bill shows us how to accomplish this task in Excel 2010 with the use of a Custom Macro and a Userform. This is a relatively straight forward "First VBA Project" Follow along and try out some VBA! ...Today's Podcast topic may be found in Bill's book, "VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstad. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions. VBA and Macros: Microsoft Excel 2010 "The Learn Excel from MrExcel Podcast Series"...

In a continuation of yesterday's Podcast [Episode #1658], Bill looks closer at the Currency Conversion Table sent in by Bob. Going with a bit more advanced Excel solution, Bill employs a VLOOKUP to provide the conversion. Follow along with Episode #1659 to see a slightly different take - using a single VLOOKUP Formula. "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru" by Bill 'MrExcel' Jelen. From 'MrExcel Labs', this Enhanced eBook is designed *exclusively for the iPad*. This e-publication Includes text, audio, and video; a media-rich and in-depth look at the Excel VLOOKUP by Bill Jelen. To read more, click here: VLOOKUP Awesome Quick "The Learn Excel from MrExcel Podcast Series" Visit us...

Don't Fear The Spreadsheet: The Excel Series for Beginning Excel Users with Questions. Bob asks: "My Database contains different currency types; I set up a conversion filter to show British Pounds...but the Formula is AutoFilling all the way down. Why and what can I do to stop this because I am getting the wrong conversion figures?" Following along with Bill in Episode #1658 to learn why this is happening and what to do to correct the issue. If you are just starting out in Excel or you want to go back and find the things that you missed when you started using Excel, then "Don't Fear the Spreadsheet" is the 'Beginner Oriented' Excel How-To book for you. Why are we so confident? Because the questions in this book were asked by an...

Taylor has to find Averages within Ranges of the Data Set. Bill 'MrExcel' Jelen immediately sets up a Pivot Table - Mike 'ExcelisFun' Girvin chooses to go with a different method using =AVERAGEIF and more. Mike and Bill also encourage us to check out SpeedTools Add-in from Excel and UDF Performance Stuff featuring the work of Charles Williams -'The Master of Fast'- with dozens of functions including Fast, Efficient VLOOKUPs. Follow along with Episode #1657 to solve the Average question and to learn more about the New Add-in from Charles Williams.

The Macro Recorder often returns Code that works today...but may not work every day. Although Pete sent in a question about using a Loop, Bill had to comment on Code designed to select an entire Table. With a few quick changes, Bill's new Code shortens 7 lines of the Recorded Code into 1 line - but it will only work if the 'Shape' of the Data is matches the imagine that Bill has in his head. Today, in Episode #1656, Bill presents: 'A Long Story About What Can Go Wrong with Recorded Code'. ...Today's Podcast topic may be found in Bill's book, "VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstad. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial...

Michael has a question: "I have Actual and I have Budget Figures that are combined; what I would like to see Actual Minus Budget, right in the Pivot Table. How can I do this?" Follow along with Bill in Episode #1655 as he shows us how to set up our Table to show the results we'd like our Pivot Table to produce. Pivot Table Data Crunching: Microsoft Excel 2013 - by Bill 'MrExcel' Jelen and Michael Alexander Excel 2013 Pivot Table Data Crunching (MrExcel Library): Jelen, Bill: 9780789748751: Amazon.com: Books Crunch any data, from any source, quickly and easily, with Excel 2013 Pivot Tables! Use Excel 2013 Pivot Tables and Pivot Charts to produce powerful, dynamic reports in minutes instead of hours... understand exactly what's...

Yesterday Bill introduced us to the new GeoFlow Add-in, coming soon for Excel. Today in Episode #1654, Bill gives us an Introduction to how it works and how we can work with it! ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!