FC2Video

“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.” In Episode #1438, Bill shows us how to use Goal Seek to back into this answer.

"My friend Lyn opened his spreadsheet and he can't see anything! What a mystery. Things show up in the formula bar, but nothing's visible in the Excel window. Is the Worksheet hidden? No. Columns Hidden? No. Bill solves this mystery in Episode #1437.

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

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… how many calls occurred in each quarter hour?

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.

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!

Dave from Boca Fire sends in today's tip: using a Formula to create a Rolling Data Validation. The 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!

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 Don't Fear the Spreadsheet. Send in your best Excel Newbie stories! Learn Excel from MrExcel!

AkshayaPatra Foundation UK hosted Morari Bapu at the Excel Auditorium UK to raise funds for the Akshaya Patra Foundation, the Mid Day meal program feeding more than a million children everyday throughout India.For More information please visit: http://www.akshyapatra.org

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. Learn Excel 2007 through Excel 2010 from MrExcel

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. "Learn Excel 2007 through Excel 2010 from MrExcel" - by Bill Jelen.

Today, a viewer from YouTube asks how to make sure that a price entered is less than the upper limit in a lookup table. Mike and Bill compare two different ways, one using Data Validation and one using Conditional Formatting. Learn Excel from MrExcel

Today's question takes us back to Excel 2003. Teresa asks how to do a COUNTIF with 2 conditions in Excel 2003. Today, in Episode #1423, Bill attempts to provide an easy explanation of how SUMPRODUCT actually works. "Learn Excel from MrExcel!"

Today in Episode #1422, a call to Excel-lers! What is the craziest newbie Excel question you've ever heard - or asked!? Send in your questions for a chance to win a prize.

Today, with Learn Excel Episode #1420, Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin create methods to search for and match records in a Workbook. Learn inherent functions of Excel as well as Custom Methods. Learn Excel 2010 from MrExcel!

Ricardo has a chart and wants to show the monthly label for every third month. This leaves a big gap at the end. Today, in Episode #1419, Bill shows us a workaround solution for this problem.

A VLOOKUP to convert State Codes to State Names all in an Array Formula - and no backward compatibility! Today, in Episode #1418, Bill shows us how to get this issue fixed along with a brief, but informative look at a few ways to work with VLOOKUP.

In Episode #1411, Bill showed us how to use Pivot Table Slicers to display images. Today, in Episode #1417, Bill shows us how to set up the Dynamic Images in Excel Using Paste Picture Link with an OFFSET named range.

Last week, in Episode #1411, Bill Challenged the audience to figure out how he was using the Pivot Table Slicer to update images in a Workbook. Today, with Episode #1416, we learn how to employ this technique. Learn Excel 2010 from MrExcel

Adam liked my Filter/Sort by color trick on the recent CFO Magazine webcast. He asks if there is any way to sum by color. In Episode #1415, Bill shows us a macro to do this. "Learn Excel 2007 through Excel 2010 From MrExcel" - by Bill Jelen.

Today, Nick asks how to get the word 'August' in cell B1 from a date in cell A1. In Episode #1414, Bill shows us how to convert a date to a month name or to a weekday name using the TEXT function.

Shawn has to do a four-way lookup: Worksheet, Row, Set of Columns, Column within the Set. To get the correct LOOKUP result, Bill shows a method using INDEX and INDIRECT to solve the problem posed in Episode #1413. Learn Excel 2010 by Bill Jelen

http://www.infocart.jp/e/61655/1092/ この動画はワード・エクセル・アクセス・パワーポイントを動画で楽々マスター！ 動画パソコン教室【楽ぱそDVD】のサンプルです。 全２７時間の動画講座の詳細はこちら

http://www.infocart.jp/e/61655/1092/ この動画はワード・エクセル・アクセス・パワーポイントを動画で楽々マスター！ 動画パソコン教室【楽ぱそDVD】のサンプルです。 全２７時間の動画講座の詳細はこちら

http://www.infocart.jp/e/61655/1092/ この動画はワード・エクセル・アクセス・パワーポイントを動画で楽々マスター！ 動画パソコン教室【楽ぱそDVD】のサンプルです。 全２７時間の動画講座の詳細はこちら

David gets data from SAP that he loads into Excel. Some part numbers in the import data just happen to look like dates and end up being converted to dates by Excel. Today, in Episode #1412, Bill discusses two ways to solve this problem.

Bill returns from a writing hiatus with a new book, one less car, and a good story to tell. Also, how is he using that pivot table slicer to show pictures on a screen? Figure it out and you can win the new book.

I have some writing to get done, so I won't be in the office again until July 11, 2011. The podcast is going on hiatus until then." - Bill Jelen a.k.a. "MrExcel" MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today, in Episode #1409, Bill shows us how to use Data from the Chart itself to Create a Dynamic Chart Title and Mike shows us two (2) variations on the theme. Also, learn a few Shortcuts and a few tips on navigating the Excel 2010 User Interface.

This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Today, in Episode #1408, Bill shows us how to Change our Chart Title, set up a comprehensive Legend and adjust the colors of our charted data.

This is the third of a Four (4) Part series on the Basics of Charting. We have our Data Set and our Chart created...Today, in Episode #1407, Bill will show us how to change our Chart Scale or Chart Axis settings in Excel.

This is the second of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Yesterday, we set up our Data Set. Today, in Episode #1406, Bill begins creating the Chart. “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen

The Basics of Excel Charting: Part I Today, in Episode #1405, Bill will begin by taking just words in a Word Document, to create a Data Set - the Data Set will become our Chart in Excel. “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen

Another Dueling Excel Podcast with Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen. Today, in Episode #1404, Mike and Bill look at finding the Percent of the Parent Row Total in Excel 2003 to 2010 using Formulas and/or PowerPivot.

The May 2011 MrExcel Challenge of the Month invites you to mash up some data from the Azure Data Market. This episode of the MrExcel Podcast demos getting data from ADM. For more info about the May 2011 Challenge, visit http://bit.ly/mPrDvX

Today, in Episode #1402, Bill takes a look at Calculating a Weighted Average using two (2) SUMIF Functions. This Formula will need to reference Data on another worksheet as well. Learn about "SUMIF"! **The Learn Excel from MrExcel Podcast Series.**

Warren from Australia writes about choosing Lotto numbers, but =RANDBETWEEN(1,45) is giving him duplicates. Today, in Episode #1401, Bill shows us another way to solve the problem and further eliminate the probability of duplicates. "Learn Excel"

Today, In Episode #1400, Bill reviews "Change-Pro for Excel", by Litéra. This high-end tool will locate all of the changes between two versions of the same workbook. Follow along with Bill to see it work!

In Part I of "Top 2 by Industry", Episode #1394, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen showed us how to get the result. Today, in Episode #1399, Mike and Bill revisit the Top 2 method to compare formula methods.

Want to let others know that your Chart Data is current? Add a Live Title to that Chart to show that the Chart represents Data through the current date. In Episode #1398, Bill shows us how this is accomplished. …Learn Excel 97-2007 from MrExcel.

Most people know how to make a column wider...simple, right? But what happens when someone has turned off column headers-what can I do? Today, in Episode #1397, Bill shows us what to do while discussing a variety of column width adjustment methods.

The question: "Why won't VLOOKUP add up all the matching results?" Today, Episode #1396 will show us how to use the SUMIF function instead of VLOOKUP. Included in today's episode... "Why it is important to lock the rows in your VLOOKUP table range."

Alex asks how to identify the top 2 amounts by industry. Today, in Episode #1394, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen show us how its done.

Wayne from Kentucky points out that you can quickly adjust Column Widths using the Paste Special Column Widths tool. He laments that there is not a tool for copying Row Heights. In Episode #1393, Bill shows us how to copy Row Heights as well.

Using Excel VBA create a macro to add a red font color automatically after editing a cell. In Episode #1392, Bill shows us three techniques for formatting our data.

Author Tom Urtis shows readers how to get the most out of Excel with this book and DVD tutorial.

Author Tom Urtis shows readers how to get the most out of Excel with this book and DVD tutorial.