Wednesday, April 1, 2009

[TechRepublic] Use an Excel range to save time and prevent errors

April 01, 2009
Use an Excel range to save time and prevent errors
Don't enter the same values and formulas over and over. Assign a range to a single instance and use the range name instead.

Sponsored
Do a salary check

IT Professionals - check your salary on activeTechPros. Be a member and get instant access to salary charts and country reports.

* * * * * * * * * *

Business Professionals - join activeBizPros and play a part in driving the salary charts. Your input will help us build a valuable resource for you to compare salaries.


Members' choice

Use Outlook to send e-mail to a cell phone
Outlook is flexible enough to send e-mail to cell phones. You just need the cell phone's 10-digit number, the carrier's domain, and a cell phone that supports SMS.

Hottest new tips

Word scraps speed up data entry
See how to drag selected text from your Word documents onto your Desktop for quick and easy access.


10+ keyboard shortcuts for working efficiently with Outlook items
You can zip around Outlook via the keyboard if you know a few handy shortcuts. This useful list covers basic tasks, from creating a distribution list to generating a meeting request.


Change the default text field size in Access 2007
If the default size of Access 2007 text fields doesn't fit your needs, you could waste a lot of time manually adjusting each one you create. Take a moment now to set your own default and save yourself all that extra work.


Mark duplicate entries automatically with Excel's COUNTIF function
Sometimes, it's handy to get a quick view of data that matches up between two columns. By combining an Excel function and the conditional formatting feature, you can easily accomplish this.


IT Career Guide, 2 GB USB Executive Pen Drive
Executive Ball Pen Designed to help you develop and cultivate your skills and excel in the workplace, providing tips on how to navigate office politics, improve your communication skills, acquire leadership skills, and much more! All combined in a stylish Executive Ball Pen.

TechRepublic
Newsletters
Get the latest community updates, product reviews, and need-to-know lists in the following TechRepublic newsletters.

Automatically sign up today!


TechRepublic Today

10 security threats to watch out for in 2009
10 ThingsAlong with the explosion of new technologies, user habits, and social practices comes the inevitable wave of new security threats. Deb Shinder examines emerging vulnerabilities, from social networking to cloud computing to IP convergence.

Subscribe to the 10 Things RSS feed.RSS

Get more from TechRepublic


Conficker: Shavlik CEO explains what it does and how to fight it
Conficker has the potential to be the first serious, wide-scale virus outbreak in several years. In this interview, Shavlik Technologies CEO and founder Mark Shavlik gives a quick summary of what Conficker can do, the three ways it spreads, and what IT departments can do to combat it.

No comments:

Post a Comment

Thanks for understanding that we need to prevent the nasties.

Terms of Use

Personal & Educational Use Only This blog consists mainly of FREE newsletters from computer web gurus that I receive. I thought you might like to see them all in one place than try to discover them on your own. A moderate amount of editing may be done to eliminate unrelated repetitious ads or unnecessary text which bloat the post. However I have given the authors full credit and will not remove their site links because you deserve to see where it comes from and they deserve to get credit for what they have written. Your use of this site is simply for educational purposes. For more computer-related help go to: CPEDLEY.COM for free software, advice and tips on low cost products which are very helpful. If you want to contact the editor, please go CPEDLEY.COM and check the Contact page for email address.