MrExcel Excel Videos

Is it possible to flag a cell if the time in the cell is more than an hour late? Today, in Episode #1444, Bill shows us a Conditional Formatting Formula to answer this question. ...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! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Jack asked about centering titles above a report. I suggested Center Across Selection, and Jack's coworker suggested Merge and Center.While it is a lot easier to find Merge and Center, there are reasons why you don't want to use this to method to center titles for your reports. In Episode #1443 Bill shows how to use the Center Across Selection method and explains why we don't want to use the Merge and Center method for our titles.

I want to Hide some Settings right in plain view on the spreadsheet, but the person using the spreadsheet keeps inadvertently deleting those settings! In Episode #1442, Bill shows us one solution to keeping those settings from being deleted. ...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! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Amal wants to highlight an entire record in red when the date falls within two weeks and then, leave the 'Done' column not marked as True. In Episode #1441, Bill shows us the tricky Conditional Formatting method to get the results we want. ...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! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

"Last week, I needed one Chart to use the colors from one Theme and a second Chart to use the colors from another Theme. The Chart Fill Dropdown wasn't helping, but I found a workaround using the Cell Fill Dropdown. Today, in Episode #1440, Bill gives us the details on solving this issue. ...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! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Mike's son Dennis has a baseball problem from his algebra class. Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin differ over whether the problem actually requires Algebra, Goal Seek, or simply a visit with Bob Barker. Pick up tips on solving Algebra Equations with Excel, using =AVERAGE, COUNTA, Goal Seek and more!

"I was in Milwaukee this week at the IIA Regional Conference when Heidi asked me about calculating a loan payment for a loan, with variable interest rates." Understanding that "PMT" makes this easy for a fixed rate, in today's podcast, Episode #1438, Bill shows us how to use Goal Seek to back into this answer.

Today, Episode #1437 title should be, "Learn Excel Mystery Theater at Hartville Hardware: Where is the Spreadsheet?" "My friend Lyn opened his spreadsheet and he can't see anything! What a mystery. Things show up in the formula bar, but there is nothing visible in the Excel window. Is the Worksheet hidden? No. Are the Columns Hidden? No. 10 minutes into this issue and it's still a mystery..." See how Bill solves this mystery and what we can do to keep this from happening in the future in Episode #1437.

Do you need to format your Excel Data Set -which has previously been prepared as a printed report- so that it is now capable of being imported into Microsoft Access or some other Database arrangement? Today, in Episode #1436, Bill shows us how to accomplish this task effectively.