[TechRepublic] 10 things I can never remember how to do in Excel

Trouble viewing this mail? Read it online | Manage my newsletters | Unsubscribe TechRepublic Microsoft Office Suite TechRepublic Member | December 09, 2009

10 things I can never remember how to do in Excel If your Excel skills are perennially rusty, this cheat sheet will help you knock out basic tasks without forcing you to scramble back up the learning curve. Read more Resource of the day Live Webcast: Delivering High Availability For Virtualized Data Centers Learn how to use the new features of Microsoft Windows Server 2008 R2 Hyper-V to boost the availability of your virtualized data center. Display a Word document's pathname in the title bar Displaying a Word document's name and full path in the title bar can be helpful -- and a little VBA will quickly take care of the job. Read more Print a list of your recurring Outlook appointments Outlook is great at keeping your appointments, but it can't print a plain list of recurring appointments. When you need such a list, export it to Excel. Read more Quickly insert rows and columns into an Excel sheet Use this easy-to-remember keyboard shortcut to insert rows and columns into your Excel sheets. Read more Office challenge: What's the easiest way to access contact information when viewing an appointment? This week's challenge tests your knowledge of Outlook appointments and contacts. You'll also learn the solution to last week's Word challenge on mixing page orientation within a document. Read more Members' choice   Create a simple invoice template in Word Here are the basics steps involved in setting up an invoice using a Word template -- along with a sample template you can download and customize. Perennial favorites   Colorize your Outlook messages to identify e-mail from specific senders Use Excel's Lookup functions to search a database Quickly access the Office folders you use most often Additional TechRepublic resources   10 Firefox extensions that enhance security Compromising Web sites has become cybercriminals' favorite method of getting malware installed on computers. Here are 10 ways to beef up Firefox, making it more difficult for the bad guys. Read more Featured multimedia   The 30 most anticipated video games of 2010 View on site Featured Webcast Live Webcast: Create a More Energy-Efficient Data Center And Save Looking to save on data center operations? Maximize energy efficiency by consolidating your distributed x86-based computers onto fewer machines. SmartPlanet resources Recession is no excuse to let green policies slip Will racket ware shift the client-server balance? How saying 'no' drives great careers TechRepublic newsletters   Get smartphones news, product reviews, and need-to-know lists in the following TechRepublic newsletters. Automatically sign up today: Smartphones Product Spotlight 10 Things Today's recommended downloads Live Webcast: Gain Faster, More Reliable Access to Critical Biz Information (IBM) Live Webcast: Delivering High Availability For Virtualized Data Centers (Dell EqualLogic) Free White Paper: Measuring The Business Value Of IT (SAP) Free Virtual Expo: Building a Successful e-Discovery Strategy (Quest Software) Live Webcast: High-Performance Workstations for Engineering and Entertainment (TechRepublic) TECHREPUBLIC TODAY 10 best year-end tech practices for SMBs For a lot of IT departments, the end of the year means a slower pace - which makes it the ideal time to catch up on a host of essential (but often deferred) tasks. Read more Subscribe to the 10 Things feed. Get more from TechRepublic TR Dojo: Remove Windows XP from and dual-boot configuration with Windows 7 Acer Timeline: Don't buy a netbook, get this instead The opposite of bullies: The damage conflict-averse bosses can cause Video: The pros and cons of the Verizon Droid Featured training courses   Configuring, Managing, and Maintaining Server 2008 MCITP: Server and Enterprise Administrator Combo Boot Camp Configuring Windows Server 2008 Active Directory Domain Services Implementing and Administering Windows 7 in the Enterprise Microsoft Exchange Server 2007 Browse all training courses Presented by Global Knowledge Should we be afraid of Google Public DNS? Google has its own DNS service, slipping its tentacles into yet another fundamental aspect of online life. How bad can it be?

Send us your feedback here. 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 (updated)   Copyright 2009 CBS Interactive, Inc. All rights reserved. TechRepublic is a registered service mark of CBS Interactive, Inc. TechRepublic 235 Second Street San Francisco, CA 94105 U.S.A.