FC2Video

Bob Umlas’ new book just arrived from the printer – “Excel Outside the Box: Unbelievable Excel Techniques”. Bill takes a look at the new book, tells you where you can buy an advanced copy, and shows you a trick from the book.

Frank asks if there is a way to rewrite a formula using a scrollbar. While we can't do it with a scrollbar, I do have a way to rewrite formula with a dragging technique. Following along with Bill in Episode #1455 to see how it's done.

Kevin wants to clear out data for yesterday’s shift worksheet any time someone opens the Workbook. Using the formula from Episode #1452, plus four tiny macros added he has added, Bill shows us the solution today in Episode #1453. "Learn Excel 2010".

“Did a new shift start between Time 1 and Time 2? It sounds like an easy formula, and it probably is, but I sure had a tough time with this formula out. Do you have a solution?” In Episode #1452, MrExcel looks at working with time and day changes.

Today, in Episode #1450, Christopher and Sheila both wrote in with different problems that required the same solution. Both happened to have numbers or dates stored as text. The Alt+DEF shortcut came worked - And Bill shows us how!

Today, in Episode #1449, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen address different methods to answer the question: “Is there a way that the Grand Totals and Subtotals would omit the Negative Subtotals?” "Learn Excel 2007 through Excel 2010"

Today, in Episode #1448, Bill re-addresses a few past podcasts with alternate solutions. Follow along, make note and improve your effectiveness with Microsoft Excel! "Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen. Visit MrExcel.com

Want to see immediate results? Set an area to the bottom and right of a massive spreadsheet where you can add totals and see them at a glance. In Episode #1447 Bill shows us how to do this with only a few keystrokes.

In a spreadsheet that keeps track of expenses, we want to mark the cell in one color if the expenses are within 25% of the budget and in another color if they are within 10% of the budget. Today, Bill shows us how to do this. Learn Excel Podcasts!

Is it possible to flag a cell if the time in the cell is more than an hour late? Today, in Episode #1444, Bill shows us a Conditional Formatting Formula to answer this question. "Learn Excel 2007 through Excel 2010 from MrExcel" by Bill Jelen.

Jack asked about centering titles above a report. I suggested “Center Across Selection”, and Jack’s coworker suggested “Merge and Center”. While it is a lot easier to find Merge and Center, there are reasons why you don’t want to use this to method.

I want to Hide some Settings right in plain view on the spreadsheet, but the person using the spreadsheet keeps inadvertently deleting those settings! In Episode #1442, Bill shows us one solution to keeping those settings from being deleted.

“Last week, I needed one Chart to use the colors from one Theme and a second Chart to use the colors from another Theme. The Chart Fill Dropdown wasn’t helping, but I found a workaround. In Episode #1440, Bill gives us the details.

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

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!

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

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

I showed this a long time ago on an episode of TechTV. The VBA code that I used in Excel 2003 to add the pop-up pictures no longer works in Excel 2010. Today, with Episode #1386, Bill shows us how to update the code for use in Microsoft Excel 2010.

In Episode #1380, Bill looks at =RANK. Excel 2010 makes it easy to Rank a Column in a Pivot Table. Although...the way that Pivot Tables handle ties is different than how the RANK function handles ties. Watch the podcast and learn a bit about =RANK.

Hyperlink haters Episode #1371 is for you! I cover the following topics: Deleting one hyperlink; Deleting a range of hyperlinks with Excel 2010 new features; Deleting all hyperlinks with a 1-line macro; How to stop Excel from creating the hyperlinks.

Today's Dueling Excel Podcast, Episode #1369, Looks at creating Data Bars. in Excel 2010 and earlier versions of Excel. Check out today's Dueling Excel Podcast to learn about the =REPT Function to create a Data Bar set in an early version of Excel.

Awesome. There is a video on the 'net with Microsoft's Donald Farmer showing off a new add-in called Gemini. This is an amazing product. In Episode 975, I point out where you can get a sneak peak at Excel 2010 pivot tables in the Donald Farmer video. 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!