MrExcel Excel Videos

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.

Viabahv asks how to replace the grand total column in a Pivot Table with a Delta Column. Bill re-introduces us to the oft hated Calulated Item feature to solve this problem today, in Episode #1435. "Learn Excel 2007 through Excel 2010" by Bill Jelen!

In today's Dueling Podcast, Episode #1434, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen are asked to work with a Spreadsheet with data that summarizes a list of call times... The objective, in using the Data, is to determine how many calls occurred in each quarter hour? Mike and Bill offer two solutions to reach the quarter hour count.

John is looking for some VBA to find and remove duplicate records in a database of 169,000 records. Today, in Episode #1433, Bill shows us how its done.

Excel 2010 introduces the ability to put your worksheets on the web and introduced PowerPivot. You could never get your PowerPivot worksheets on the web, but Rob Collie the HostedPowerPivot.com team have solved the issue. Win a PowerPivot t-shirt!

Today, Denver asks how to convert a number in Excel to words such as "three thousand four hundred sixty five dollars and thirty two cents". In Episode #1431, Bill shows us a cool knowledge base article with the answer to solve 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!

A write-in to Bill today to ask about methods to create a Waterfall Chart in Excel, without the aid of an Excel Add-in. In Episode #1430, Bill shows us how to accomplish the task. "The Learn Excel from MrExcel Podcast Series" Learn Excel 2010!

Today's Dueling Excel looks at what the I.T. Department is sending down. It's an ugly report, each day, and we want to collapse multiple lines - for each person - into a single line. But it is more complicated than that; we have to Concatenate First Name and Last Name, plus a Lookup to figure out which Column should be reported. Follow along with Episode #1429 as Bill 'MrExcel' Jelen employs a PowerPivot Solution and Mike 'ExcelisFun' Girvin employs a Formula to solve this week's challenge.

Today's 'Learn Excel from MrExcel' Podcast is focused on some work provided by 'Dave' from Boca Raton Fire Dept. Dave sends us this tip: "Use a Formula to create a Rolling Date Data Validation." The Date Data Validation Dropdown offers 'Now', '15 Minutes from Now', '15 Minutes Ago' and so on. Follow along in Episode #1428 to learn how its done! Thank you Dave!