Named ranges, which substitute a user-specified name for data in a range of cells, make data entry easier, formulas simpler to name, and cells a cinch to locate.
Business Management Daily is your source for office technology tips and training. WE provide keyboard-tested advice on Outlook, Excel, PowerPoint and more.
It is said that people only use 10% of their brains. Are you only using 10% of your office technology? We’ll help you unlock the other 90%.
With new applications being released on a minute-by-minute basis, here are some of the best new applications that you might have missed.
Q. What is the best way to create identical worksheets? I do a lot of copying and pasting, but I’m sure there is a better way.
Q. I used to highlight emails from certain people in a particular folder. I can’t find this option in Outlook 2010.
Q. I need several versions of a PowerPoint presentation. For some audiences, I’ll need to show all the slides, for others just the topic summaries and some of the detail. Another audience needs just a section or two of the whole thing. Do I have to make multiple copies?
Evernote can store anything from links to files to photos that you can access from any computing device. If so, you’re ready for add-ons that make Evernote even better, according to TJ McCue, owner of TechBizTalk.com. Here are his add-on picks.
The Undo feature in Word is wonderful because you can step back a series of operations, but you cannot select from this list of actions. An alternative is to turn on Track Changes from the Review tab. You can also turn on the Reviewing Pane ...