MrExcel Excel Videos

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!

You've tried Printing your Report from the Excel Workbook that you've toiled over and instead of one neatly arranged and printed page, you've ended up with several pages of cut off Data! Now what? Tape? Staples? And will my Reports always print like this? How can I get all of my Data to Print on one page? Follow along with Episode #1569 to learn how to change your Settings, display 'Page Breaks' and end up with the result you really want to achieve. "Don't Fear The Spreadsheet: A Beginner's Guide To Overcoming Excel's Frustrations" by Tyler Nash, Kevin Jones, Tom Urtis and Bill Jelen Don't Fear the Spreadsheet "This Book Makes Excel For Dummies™ Look Like It Was Written For Rocket Scientists!" "The Learn Excel from MrExcel...

In our latest Dueling Excel Podcast, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen look at using =SUM, =AVERAGE, =STDEV, =MIN, =MAX with a Pivot Table and More to show a set of Descriptive Statistics from the current Data Set. Follow along with Mike and Bill in Episode #1568 to see a few very important Functions in action! Dueling Excel Podcast #108...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 / Print Edition and as a DVD Bundle] Slaying Excel Dragons and "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday...