Technology tips, tricks, and hacks to make your workday work better.
July 3rd, 2008 @ 7:37 am
Even if you spend a lot of time using Excel, you may not be taking full advantage of the spreadsheet program’s power. Productivity501 sheds some light on three of Excel’s lesser-known, but extremely useful, capabilities. They are:
Granted, these aren’t functions every user needs every day, but they can definitely save you some time. The six-minute video shows you how.
Subscribe to this discussion via Email or RSS
ryanhca
I usually skip over these "Hacks" segments, but this one was great! I always wondered how to do that "transpose" trick.
One suggestion: script the presentations a little better.
vijayk29
Very good and useful
RayMcBeth
Mark,
If you look at this help entry: "Create a drop-down list from a range of cells" (Excel 2003) you can do something similar to "Validate entries to a list" but the named ranges can be on a different sheet and you can choose to force the entries from the named range or allow for other entries (which is useful if some items are typically selected, but legitimate exceptions do occur).
Ray McBeth
Rick Broida
A technology writer for more than 15 years, Rick Broida is a regular contributor to CNET, Popular Science, Wired and other publications. He's also the author of numerous books, including How to Do Everything with Your Zune. When he's not chained to his keyboard, he's usually shooting hoops or watching quality television. more »
Popular on CBS sites: SEC Football | NFL | Video Game Cheats | iPhone | Video Game Reviews | Notebooks | Antivirus Software
About CBS Interactive | Jobs | Advertise | Mobile | RSS
© 2009 CBS Interactive Inc. All rights reserved. | Privacy Policy (updated) | Terms of Use | Site Map
Forget 'What are your strengths and weaknesses?' If you want to get the real dope on prospective employees, ask job candidates these seven questions.
In the highly publicized chicken wars, KFC seems to be winning the financial battle over El Pollo Loco. But is it really fair to compare the smaller chain to Colonel Sanders' empire?
How’d you like to earn a few thousand dollars for less than an hour of your time? This is no get-rich-quick come-on. The extra income is the potential payoff for making a few simple and painless money moves.
