MrExcel Excel Videos

Today we will learn how to replace Numeric Chart Labels with a Formula using the method Bill gives in Episode #1426. Also learn to vary Colors by Point AND "Making Excel Columns Wider" using Gap Width. Learn Excel 2007 through Excel 2010 from MrExcel

Today, in Episode #1425, Bill takes another look at Chart Titles, how to make them Dynamic and using the TODAY() and TEXT() Functions in order to add a date to a Dynamic Chart Title. "Learn Excel 2007 through Excel 2010 from MrExcel" - by Bill Jelen.

Today, a viewer from YouTube asks how to make sure that a price entered is less than the upper limit in a lookup table. Mike and Bill compare two different ways, one using Data Validation and one using Conditional Formatting. Learn Excel from MrExcel

Today's question takes us back to Excel 2003. Teresa asks how to do a COUNTIF with 2 conditions in Excel 2003. Today, in Episode #1423, Bill attempts to provide an easy explanation of how SUMPRODUCT actually works. "Learn Excel from MrExcel!"

Today in Episode #1422, a call to Excel-lers! What is the craziest newbie Excel question you've ever heard - or asked!? Send in your questions for a chance to win a prize.

September 5, 2011 was the 'Labor Day' Holiday in the States; Labor Day is celebrated in honor of those workers who have contributed economically and socially...but it can make spreadsheet calculations a little difficult [as can most holidays, weekends, vacation time]. Today, in Episode #1421, Bill shows us how to calculate the previous work day - particularly when that previous day is a holiday. Learn how to work with the =WORKDAY Function, Holidays, Weekends, a few Excel Shortcuts and More when calculating time with Excel. ...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%...

Today, with Learn Excel Episode #1420, Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin create methods to search for and match records in a Workbook. Learn inherent functions of Excel as well as Custom Methods. Learn Excel 2010 from MrExcel!

Ricardo has a chart and wants to show the monthly label for every third month. This leaves a big gap at the end. Today, in Episode #1419, Bill shows us a workaround solution for this problem.

A VLOOKUP to convert State Codes to State Names all in an Array Formula - and no backward compatibility! Today, in Episode #1418, Bill shows us how to get this issue fixed along with a brief, but informative look at a few ways to work with VLOOKUP.