“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.

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

Today, Episode #1437′s 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. Ten 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.

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

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 an other Database software? Today, in Episode #1436, Bill shows us how to accomplish this task effectively.

For more information on 'Pivot Table Tricks', Usage and general 'Pivot Table How-To', check out: "Pivot Table Data Crunching: Microsoft Excel 2010" by Bill Jelen and Michael Alexander.
 

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

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.

For more information on 'Pivot Table Tricks', Usage and general 'Pivot Table How-To', check out: "Pivot Table Data Crunching: Microsoft Excel 2010" by Bill Jelen and Michael Alexander

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

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.

Dueling Excel Podcast #84…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

For anyone who hasn’t noticed, the third edition of Learn Excel is now available. This edition is titled “Learn Excel 2007-2010 From MrExcel – Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More – 512 Excel Mysteries Solved.” Yes, it is a really long title, but I wanted to convey that it is not a book for Excel beginners.

To learn more about Learning Excel 2010 and Bill's new book "Learn Excel 2007 through Excel 2010", from Bill himself, visit the "Learn Excel" blog post here to read his notes.

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 with an inherent feature of Excel 2007 / 2010 that takes only a few simple clicks!

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

Excel 2010 introduces the ability to put your worksheets on the web. Excel 2010 introduced PowerPivot. Unortunately, you could never get your PowerPivot worksheets on the web. Finally, Rob Collie and the team at HostedPowerPivot.com have solved the issue. Win a PowerPivot t-shirt just for trying it out! Today, in Episode #1432, Bill shows us and explains a bit to us about Excel and PowerPivot and gives details about how to win the t-shirt!

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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!

Bill also covers PowerPivot with his book ” PowerPivot for the Data Analyst: Microsoft Excel 2010” by Bill Jelen

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions

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 and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

A write-in to Bill “MrExcel” Jelen 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 without the use of an Excel Add-in.

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

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.

Please Note: The Video Podcast for this Episode [#1429] would not upload to Libsyn on it's original Date. As a temporary measure, if you cannot view the video podcast, please visit The "Learn Excel from MrExcel" Blog - Here, on WordPress for todays Dueling Podcast #83.

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

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!

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

Today, in Episode #1427, Bill shares an interesting way to find totals in Excel … the Read Aloud Method! This episode is another in our series for the forthcoming book,  ”Don’t Fear the Spreadsheet” by Tyler Nash and Bill Jelen. Maybe you’d like to win a copy of this book when it is ready for shipment? Send in your best Excel Newbie stories for a chance to win!

…This blog and video podcast is brought to you by the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. 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

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.

…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

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.

This blog is / video podcast is brought to you by 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!

*For users of earlier Editions of Microsoft Excel and earlier Editions of  the “Learn Excel from MrExcel Series”, visit the MrExcel Store! The Learn Excel Series covers Excel 97 through Excel 2010 in three (3) Editions! 

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!