Information
- Founded:
- 1998
Events
2 upcoming eventsSee All
- POWER MACROS FOR EXCEL
Akron, OH
Monday, November 16 at 8:30am - Power Excel Seminar in Oklahom...
The Centre
Thursday, November 19 at 12:00pm
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
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.....
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...
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...
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!
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...
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...
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...
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...
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....
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 I have been a fan for years ... I aspire to be an MVP ... some day :-)
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...
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!
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...
