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

April 01, 2009

TechRepublic Microsoft Office Suite Trouble viewing this mail? Read it online | Manage my newsletters Welcome: TechRepublic Member Update my profile | Unsubscribe from this mail Blogs | Photos | Downloads | Forums 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. SponsoredDo 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 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! Community Central Product Spotlight 10 Things White Papers from our partners Do a salary check How file fragmentation occurs on Windows XP / Server 2003 (Diskeeper) eBook: BI and the Power of Choice (Oracle) Yankee Group: Software as a Service dramatically improves CRM success (Oracle) Build or buy: Oracle's pre-built analytic applications vs. building a custom warehouse (Oracle) TechRepublic Today 10 security threats to watch out for in 2009 Along 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. Get more from TechRepublic Add Copy To and Move To commands to Windows XP Explorer with this registry hack Sanity check: Three reasons to pause before deploying netbooks in business Job hunting: Put a new spin on 'old' Video: Power tips for maximizing the business lunch 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. Sign up for more free newsletters from TechRepublic. To manage your account settings or to remove yourself from all TechRepublic communications, please visit our Subscription Center. The e-mail address for your subscription is cpedley@churchpower.com Unsubscribe from this e-mail | FAQ | Advertise | Privacy Policy   Copyright © 2009 CBS Interactive Inc. All rights reserved. TechRepublic, TechRepublic.com and the TechRepublic logo are registered trademarks of CBS Interactive Inc. Used by permission. CBS Interactive Inc. 235 Second Street San Francisco, CA 94105 U.S.A.