It’s been quite a while since the last one, but I’ve finally posted another list of Excel Twitters. The Twitter spam was making it too tough to collect the interesting tweets, and that’s why I stopped. Howe...
You open lots of Excel files every day, and sometimes open the same file several times. In Excel 2007, if you click the Office Button, you can see a list of documents that you’ve opened recently. Click on file name, to open that file again. ...
Almost a year ago, we talked about creating a table of contents sheet in Excel. In that post, one of the suggestions was to type a list of sheets on a worksheet, then change each sheet name into a hyperlink...
John Walkenbach is having a 2 hour sale of his Power Utility Pak (PUP) – over 80% OFF the regular price. You can get all your Christmas shopping done early, if you act fast! I’m sure that all your family and friends would love an awesome Excel utility. Th...
For the past 82 years (approximately), I’ve used Excel almost every day. Along the way, I’ve learned a few tricks, and produced some sophisticated workbooks. One of the joys of Excel is that there’s always something new to learn. This...
Thanks for participating in the Very Scary Fall Giveaway for Excel Nerds! Your Excel horror stories were truly frightening, and the costume ideas were very creative...
Have you read all the Excel horror stories and costume ideas in the Very Scary Fall Giveaway for Excel Nerds? There’s some truly frightening stuff there! The entry deadline is tomorrow at noon, Eastern Daylight Time, so get moving if you haven’t entered already. My...
The Very Scary Fall Giveaway for Excel Nerds is going strong, with lots of frightening Excel horror stories and some scary costume ideas. Please take a few minutes to read the comments, and add your contribution...
Contextures Inc.
In Excel, use a mouse shortcut to quickly copy formulas and paste the results as values. Detailed instructions at http://blog.contextures.com/archives/200
It’s time for another Excel giveaway! Hallowe’en is just around the corner, so let’s find out what Excel Nerds do to celebrate. I’ve been given some awesome Excel utilities, books, and ebooks to give away, so let’s have some fun. Rules are at the end of this article. To enter...
How much time do you spend trying to find and fix error in your Excel workbooks? Or even worse, fixing errors in other people’s workbooks. ...
In a lookup table, how can you get Excel to find the item that’s the exact match, including the upper and lower case? For example, in this table, row 8 is M7 and row 9 is m7. There’s a different value for each of these in column B. If I do a lookup for m7, I want the result to be 9, not 8. ...
Garbage in, garbage out. You depend on Excel spreadsheets to show accurate data and analysis. Enter the wrong data and the results will be incorrect, and that could have a negative impact on your business or reputation. Here are 3 ways to help safeguard your data entry...
It’s Thanksgiving Day in Canada, so some of us will be eating turkey and watching football. However, we don’t limit ourselves to one day, like the USA – we celebrate for three days! Tomorrow, eight feet of snow will fall, and we’ll stay inside for the rest of the winter. For ...
This week I was travelling, and signs are really important for helping you figure out where you are, and where you should be headed. Whether you’re posting street signs, retail signs, or worksheet instructions, try to make them clear and helpful. ...
