MrExcel Excel Videos

Today is Part II in our 'Named Range' miniseries. In Episode #1581, Bill looks at a common issue with Excel; Deleting a Worksheet results in a finding #REF! listed in the Name Manager -- and I really don't want them there. Learn how to deal with these empty references by removing them from the Name Manager list. ...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" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Well, today we've decided to do something a little bit different. Pre-empting our 'Named Range' series by a day, [and moving today's Podcast up in the schedule] we wanted to take a break from all of the Excel-ling to, instead, take a look at a modern book printing facility! Hess Print Solutions, of Brimfield, Ohio [ HESS PRINT SOLUTIONS - HOME ]was kind enough to allow Bill "MrExcel" Jelen into their facility to record a walking tour full of interesting information and cool, 'adult-sized' toys and gadgets! Enjoy Episode #1580 as you learn how our latest MrExcel Bookshelf Edition, "Don't Fear The Spreadsheet" by Tyler Nash, Kevin Jones, Tom Urtis and Bill Jelen, made it to the bookshelf! Many 'Beginner Oriented' Excel How-To books say...

Name Box Expand is a great way to actually be able to see your Ranges - as you've named them - in the Named Range Box, without trying to guess what you are looking at. But did you know that you can find that name showing in lists when using other Functions of Excel? Bill shows us an interesting discovery and the uses of that discovery in Episode #1579 - this may make your Excel tasks just that much easier and more logical to follow. Today begins a week-long Series on Named Ranges: This is Part I of IV 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...

The earliest Spreadsheets were designed for accountants. To this day, some of Excel's annoying behavior is to make the accountants happy [but it may not be making you very happy]. How can I set up Excel so that it always shows Dollars and Cents? Excel has a "Accounting" Format, but perhaps you're not interested in the look and feel of that Format. To have your Data present the way you'd like it to, take a look at the "Currency" Formatting options today with Bill, in Episode #1578. 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...

Update: Jon Peltier sells an add-in that replaces all of these steps: Peltier Tech Charts for Excel 3.0 Today's episode is a continuation from Episode #1091 [ Stacked & Clustered – 1091 – Learn Excel from MrExcel Podcast ] that shows how to create a chart with Two (2) Series Stacked and a Third as a Cluster. But in Episode #1577, Bill is going to show us how to stack Two (2) Series of 2, side by side. Follow along to see how it's done.

Sheri has two Spreadsheets: One Sheet contains all of the company's current customers and the other contains a generic list of all the top warehouse customers. What Sheri's employer wants is to find out how many customers on the generic warehouse list match current customers of the company. So, how do we set out to accomplish the task? Follow along as Bill shows us the way in Episode #1576. ...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...

Are all of your Numbers in your Spreadsheet appearing as 'Pound Signs' [Hash or Number signs]? Learn why this happens - why it happens with Numbers and not Text - and what you can do to restore the look of your Spreadsheet, as your Numbers are probably not corrupt at all. Following along with Bill in Episode #1574 to learn more about the issue and how to solve it. 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...

[This Podcast Rendered at an Altitude of 33K Feet] A tip from Patricia today! Several ways to get those " $ " signs where you want them when working out your Forumula! Follow along with Bill in Episode #1573 to see how it's done! ...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!

Today's podcast takes a solution found in "Pivot Table Data Crunching: Microsoft Excel 2010" by Michael Alexander and Bill Jelen. Taking a table that is currently set up as a Two-Way Table, Bill uses the 'Old Pivot Table Dialogue' in Excel to set up a Pivot Table to transform the current Table to a Linear Table. Follow along with Episode #1572 to learn how to access that 'Old Dialogue' and transform the Two-Way Table. For more information on 'Pivot Table Tricks', Usage and general 'Pivot Table How-To', check out: ""Pivot Table Data Crunching: Microsoft Excel 2010" by Bill Jelen and Michael Alexander Pivot Table Data Crunching: Microsoft Excel 2010 ...This blog is the video podcast companion to the book, Learn Excel 2007 through...