MrExcel Excel Videos

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...

Today, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen look at working with the Electoral College. Using the State by State Electoral Vote Count, Mike and Bill will sort out which States had the highest number of votes collecting the required 270 votes and which States had the lowest number of votes which added up to 270 votes. Learn a little about the Electoral College, why the numbers matter, see why simple Filters will not do the complete job, why Bill chooses to use a Pivot Table and Mike goes with Functions such as =LARGE, =INDEX, =SMALL and more. A real Information-Packed Dueling Podcast! Check out Episode #1571. Dueling Excel Podcast #109...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A...

Todays question involves doing a Range Lookup using a VLOOKUP Formula. Bill shows us how to set this up based on the Data Range provided and explains why today's VLOOKUP will be ending with a 'TRUE' statement instead of the usual 'False'. See how and why its done in Episode #1570. ...This a 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!