MrExcel Excel Videos

Ever wonder how you could easily strip 'illegal' characters from a URL? How about return the contents of an entire webpage to a Single Cell in Excel? Are you familiar with 'xPAth'? Today, in Episode #1599, Bill continues his review of Excel 2013 by looking at new ways to find, filter and work with Web-Based Data. Follow along with Bill as his review of Microsoft Excel 2013 continues today! ...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"...

Tony has skills. He has created a great workbook, done his VBA Coding well and has incorporated a Userform into his work to make things simple and smooth... but the Userform won't launch. Clicking the 'Launch' button on the user side produces a 'Compile Error: Expected Function or Variable'. What is causing the error - it's a single, short line of code!? Follow along with Episode #1598 to find out what the issue is and how to correct it quickly. ...This 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...

How do I compare two Ranges of Data? 'Comparison Operators' are the key. Today, in Episode #1597, Bill looks at the need to compare two Ranges of Data to be sure they are Matched - and then he shows us how to do it. Follow along to learn the basics of Comparing Data from two different sources to reconcile for the final True result. Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others...

Today, Tim wants to know if he can produce several Charts based on one Pivot Table, so that on 'Refresh' all of his Charts will be refreshed. Bill says the key is having only One Pivot Cache. Follow along with Episode #1596 as Bill shows us how to create several Charts based on this One Pivot Cache. This 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! "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

#N/A...unsightly and it's nice when we can make it 'disappear'. Anna suggested a quick way to make those little 'eye-sores' go away. Follow along with Episode #1595 as Bill describes and demonstrates this easy to implement trick! This 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! "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Well, we've covered some interesting basics already in this 'Don't Fear The Spreadsheet' series, but today Tyler and Bill are really stepping out onto new ground! Today, Bill is going to show the process of creating your first Formula in Microsoft Excel! If you need to learn the way, today is a great start to get you launched! Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft...

Today, Bill reviews an earlier podcast that focused on moving Chart Legends to the top. However, after trying this, a viewer noticed that there was a large space between items in the Legend. Today, in Episode #1593, Bill looks at why this might be happening and how to correct it.

Well... all this week Bill has been reviewing and highlighting some interesting features that are available in Excel 2013: Ease of access to utilities and web services; Ease of use for First Time Excel Users; More developed Pivot Tables and Data Manipulation; Changes in Notifications and Message Box dialog...and now Apps. Follow Bill in Episode #1592 as he demonstrates the ability to reach outside of your office to get stuff on the internet including Apps Designed for use in Excel 2013! This is a great feature to see! This Concludes Bill's first set of Review Podcasts for Excel 2013, but there will be more in the near future detailing even more exciting features and abilities in the New Excel as well as more in-depth looks at single...

**CONTEST ALERT** It's Thursday and Bill is reviewing the week thus far and Bill has an interesting discovery - Excel Messagebox messages are sporting 'Attitude'. Take a look at Episode #1591, churn your ideas and then enter the contest! [Bill talks about the contest in the Podcast] This is Part IV of V in the Excel 2013 Review Series. ...This 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...