Wednesday, December 9, 2009

[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:


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)


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
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.

235 Second Street
San Francisco, CA 94105

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.