MrExcel.com
Information
Founded:
1998
Events

2 upcoming eventsSee All

Video

1 of 13 videosSee All

0:50 Added over a year ago
 
MrExcel.com
A cool way to streamline a VBA loop using SpecialCells. Episode 1140 shows you how.This blog is the video 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!
Tuah Izwan

Tuah Izwan i tried to follow your instruction in regression analysis where you give an exmaple of ice cream stall...
But when i try to click { Ctrl+Shift+Enter } only one answer that popup... (-98.8)
Why it didn't work just like you do?
Please help me.....

MrExcel.com
A viewer from Portugal sends in a question about finding which row contains the match. Episode 1139 shows you a few ways to go!This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...
MrExcel.com
Rod from Cincinati asks how to solve the problem of trailing spaces in the lookup table. I had never tried it before, but you can apply a TRIM to the entire lookup table. Episode 1138 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...
MrExcel.com
In Episode 1137, a cool way to remove all hyperlinks from a spreadsheet.This blog is the video 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!
Claude Van Horn
Claude Van Horn
I like it! That's a lot quicker than the macro I wrote to change
email addresses TO hyperlinks:)
November 4 at 8:25pm
MrExcel.com
Mary from Louisiana passes along a cool tip for applying AutoFilter dropdowns to a subset of your records. Episode 1136 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...
MrExcel.com
Nick asks how to do a pretty lengthy bonus calculation. It might be too complex for the Excel 2003 nested IF limit, so I decided to use the range version of VLOOKUP. But...as a twist, I embed the table right in the formula...
MrExcel.com
Today's Dueling Excel Podcast is a question sent in by Hassan. Hassan wants to enter a name and a through-month and then add up that person's sales from January through the selected month...
MrExcel.com
Patricia called the other day with a problem which will be familiar to everyone who works in a public school district. The state pays the school for every student who is enrolled on the magic date of October 1. Given a start date and end date, how can you tell if the date is in that range...
MrExcel.com
The Excel fill handle is really cool with quarters. But wait....it can not do quarters and years. But wait...it can do them but in a hideous format. Episode 1132 asks  - "Does anyone have a better way?"This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel....
Clive Parker
Clive Parker
You can enter 1Q 09 etc or 1st Qr 09 etc. The trick is starting with a number instead of Q.
November 4 at 5:06pm
MrExcel.com
Roger from Columbus Indiana passes along a cool trick for formatting all of the text in a chart at once. Episode 1131 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...
Teresa McPherson

Teresa McPherson I have been a fan for years ... I aspire to be an MVP ... some day :-)

MrExcel.com
Greg wants to set up dynamic validation, but he has a wrinkle....Once someone chooses from the first data set, he needs to append the word My before that answer to get to the name of the second data set...
MrExcel.com
A dueling podcast...how to find the first week of the month. Mike and Bill show you various ways in Episode 1129.This blog is the video 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!
MrExcel.com
The last in my series of podcasts about GetPivotData. Today, we see how to use GetPivotData to overcome all the bad stuff in a pivot table. Episode 1128 shows you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel...