MrExcel Excel Videos

Figure out the number of billable days between two dates. Episode 1018 looks at ways to count the number of days, number of workdays, or number of Monday-Wednesday-Friday dates between two dates. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Shawn sends in today's question. The spreadsheet has billing data to audit. For each record, there is a location, a start date, and an end date. Shawn wants to find any records where the same date and location is double-billed. A quick two-loop macro solves this problem. Episode 1017 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Our guest host today is Jon Peltier. Jon maintains an excellent set of charting examples at Peltier Tech Blog - Peltier Tech Excel Charts and Programming Blog. In todays podcast, Jon discusses the best way to organize your data for charting. Episode 469 shows you how.

I realize this is the Learn Excel podcast, but we have a Word tip today from Anne Troy aka Dreamboat, author of Dreamboat On Word. Have you ever changed a character in Word and had the format of the entire paragraph change? Our guest podcast host, Anne Troy will show you why that happens in Episode 468.

Todays podcast is the first in a series featuring guest podcasters. Bob Umlas, Excel MVP and author This Isnt Excel, Its Magic shares one of the tips from his book. This is one of my favorite Bob Umlas tips how to add a blank row between every row in your dataset. Episode 467 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 466 shows how to get rid of leading spaces while leaving the interior spaces intact. Plus news on Microsoft MVP Summit from Seattle and preview of Excel guest appearances on the MrExcel podcasts. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

As the NCAA games start today, the commissioner needs to track how many games youve won, but also to see in the future to see how many games you are guaranteed to lose in future rounds. Nothing is worse (for you) than having a Cinderella team knock out your winner in the whole tournament. The Excel-based NCAA bracket takes a look at not just what games you have won, but also what games where your winning team has already been knocked out of the bracket. Episode 465 shows how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

In offices throughout the US, people are starting to turn in their NCAA bracket sheets to the office commissioner. Whether you are asking accountants to fill out an NCAA bracket or sales reps to fill out a sales forecast, it makes sense to collect the data in an Excel workbook. In Episode 464, we take a look at a macro that can be used to gather entries from the individual worksheets and combine them into a master worksheet.

The first entries in the NCAA office pool are starting to come in and the commissioner of the NCAA pool will have to key your entries from the faxed USA Today bracket into the spreadsheet. In the MrExcel spreadsheet, concatenation formulas help to make sure that the teams keyed for each player are correct. Episode 463 shows you how to use FIND, ISERR, and IF functions to check to make sure your data entries are in a list of valid values. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!