Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Bill’s favorite Excel-related April Fool’s day trick will freak out your manager. Take a look at how this old trick plays out in the old Excel, the new Excel, and in Vista. Episode 476 shows you how.
posted by Bill at 9:00 AM
Excel MVP from Brazil Robert Martim shows how to set up a 2-level data validation. Episode 475 shows you how.
posted by Bill at 9:00 AM
Dick Kusleika is our guest podcaster today. Dick is the host of the Daily Dose of Excel. He shows how to troubleshoot formulas by evaluating parts of a formula right in the formula bar. Episode 474 shows you how.
posted by Bill at 9:00 AM
Sure – it is easy to add up a column of numbers in Excel, but did you know that you can do this in Microsoft Word as well? Our guest host today is Word MVP Tony Jollans. In Episode 473, Tony shows you how to add up a column of numbers in Word.
posted by Bill at 9:00 AM
Do you need to turn data on its side in Excel 2007? PowerPoint MVP Kathy Jacobs shares her favorite new feature in Excel 2007. Episode 472 show you how.
posted by Bill at 9:00 AM
Today’s guest podcaster is Curt Frye, author of the Step by Step series for Excel. Curt shows off some cool fill handle tricks. Episode 471 shows you how.
posted by Bill at 9:00 AM
Today’s guest podcaster is MVP Zack Barresse. Zack shows how to apply a greenbar formatting using a cool conditional formatting formula. Episode 470 shows you how.
posted by Bill at 9:00 AM
Our guest host today is Jon Peltier. Jon maintains an excellent set of charting examples at http://peltiertech.com/. In today’s podcast, Jon discusses the best way to organize your data for charting. Episode 469 shows you how.
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
Today’s podcast is the first in a series featuring guest podcasters. Bob Umlas, Excel MVP and author This Isn’t Excel, It’s 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.
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
As the NCAA games start today, the commissioner needs to track how many games you’ve 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.
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
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.
posted by Bill at 9:00 AM
March Madness has begun and commissioners in offices throughout the US are using the office copier this morning to distribute copies of the NCAA bracket found in the USA Today. While you are invited to join the free MrExcel.com/ncaa.html contest, today’s Episode 462 takes a look at the life of the NCAA commissioner – using formulas to pre-enter your bracket selections in Excel.
posted by Bill at 9:00 AM
You are invited on Monday to download MrExcel’s NCAA bracket and enter his free NCAA pool. The winner will get their choice of books from the MrExcel store. In today’s Episode 461, we will take a look at the Data – Validation commands used to make the NCAA bracket selection worksheet work.
posted by Bill at 9:00 AM
Dan has an unusually wide spreadsheet where the page breaks suddenly disappear. This is a decade old problem and as soon as I heard the question, I remembered beating my head against my desk when this started happening to me back in the mid-90’s. Episode 460 will take a look at what causes the problem and how it can be solved.
posted by Bill at 9:00 AM
How to import a delimited text file into Excel. Learn the gotchas associated with this type of file, including the annoying “feature” that gets turned on for the rest of the day after importing the text column. Episode 459 show you how.
posted by Bill at 9:00 AM
In our continuing look at importing text files, today’s netcast discussed how to import fixed width files into Excel. Watch to learn why choosing the text column type will cause your formulas to never work. Episode 458 provides the details.
posted by Bill at 9:00 AM
If you need to import a text file into Excel, you will need to use the text to columns wizard. Before you start importing text, you need to figure out if your dataset is fixed width or delimited. Episode 457 will explain the difference.
posted by Bill at 9:00 AM
Dan from Akron notes that when he inserts new columns in Excel, Excel is automatically extending the size of any charts that happen to span the new column. With most objects, you can right-click and indicate that you don’t want to move or size with cells. However, charts don’t seem to have the ability to change the resizing options. Episode 456 will show you the bizarre solution.
posted by Bill at 9:00 AM
Joe writes in with a question of how to subtract the most second most recent price in the row from the most recent price. The solution involves the relatively obscure OFFSET function. Episode 455 shows you how.
posted by Bill at 9:00 AM
