- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
Must-Read Post
Nine guidelines for writing effective email messages
If you want people to pay more attention to your email, perhaps you should pay more attention to your email!
-
Use conditional formatting in Access forms and reports
Access' conditional formatting feature is just as comprehensive, flexible, and powerful as Excel's, but many users aren't aware it exists.
Posted by Susan Harkins | February 9, 2012, 11:45 AM PST | Latest comment by ssharkins@...
-
Office challenge: How to get Outlook contacts into an address book
This week, prove your Outlook prowess by solving this missing address book mystery.
Posted by Susan Harkins | February 8, 2012, 7:47 AM PST | Latest comment by herbman@...
-
Launch Word with the most recently used document
Show users how to open the most recently used file when launching Word. Or, provide them with a shortcut that does the same thing.
Posted by Susan Harkins | February 7, 2012, 8:09 AM PST | Latest comment by stpeters@...
-
Harness the power of Word's AutoCorrect feature
Show users how to work more productively and accurately using Word's AutoCorrect feature.
Posted by Susan Harkins | February 6, 2012, 11:00 AM PST
-
White Papers
Rethink Your Storage With IBM
Data storage is an interesting thing. While it's easy to add more storage with band-aid solutions, before long, you'll need to seriously rethink how you store. For some advice, turn to this white...
From: IBM
Read more -
Webcasts
Live Webcast: 3 Simple Steps to Better Patch Security
For better patch security, you'll need to take some precautions and know how to react when the time comes. For help with that, check out this live webcast from TechRepublic.
From: Sophos
Register Now -
Run a list of rolling credits at the end of your PowerPoint presentation
Acknowledge important credentials using PowerPoint's credits effect at the end of your presentation.
Posted by Susan Harkins | February 2, 2012, 11:57 AM PST | Latest comment by marybee27
-
Office solution: How to select a specific cell when returning to a sheet
This week, learn the solution to the challenge: What's the easiest way to select a specific cell when you return to a specific sheet?
Posted by Susan Harkins | February 2, 2012, 11:43 AM PST
-
Office challenge: How can I change Outlook's default contact folder?
In this week's challenge, Outlook users ask for the near impossible when it comes to contact management; can you meet their demand?
Posted by Susan Harkins | February 1, 2012, 11:24 AM PST
-
Add space between table cells in Word to add visual interest
Learn two easy ways to add visual interest to your Word tables by adding space between cells.
Posted by Susan Harkins | January 31, 2012, 8:39 AM PST
-
Disable send and receive mail options in Outlook
Users don't have to both send and receive email via Outlook; they can choose to do one or the other.
Posted by Susan Harkins | January 30, 2012, 7:59 AM PST
-
Quickly highlight matching values in Excel with keyboard shortcut
When you just need to see matching values and you don't want to filter or sort, try this Excel keyboard trick.
Posted by Susan Harkins | January 27, 2012, 6:42 AM PST | Latest comment by DBlayney
-
Office solution: How to continue numbering from one table column to another
This week, learn the solution to the challenge: Can you continue numbering by column? Hint: It's not intuitive.
Posted by Susan Harkins | January 26, 2012, 2:02 PM PST | Latest comment by ppg
-
Office challenge: What's the easiest way to select a specific cell when you return to a specific sheet?
In this week's challenge, help a user preserve the cursor location in a sheet whenever he/she returns to it.
Posted by Susan Harkins | January 25, 2012, 12:28 PM PST | Latest comment by foreigner
-
A quick tip for entering names into an expression
Show users this quick tip for entering range names into formulas and functions. It's easy to use and reduces errors from typos.
Posted by Susan Harkins | January 25, 2012, 12:27 PM PST | Latest comment by ssharkins@...
-
What to do when Excel's Custom Views option is disabled
Custom views are handy if users need to view data in different ways, but sometimes it isn't available. Learn why and what to do when this feature is disabled.
Posted by Susan Harkins | January 24, 2012, 8:27 AM PST
-
Office solution: Two ways to eliminate Excel grid lines from a PowerPoint slide
This week, learn the solution to the earlier challenge, how would you eliminate Excel grid lines from a PowerPoint slide?
Posted by Susan Harkins | January 19, 2012, 10:52 AM PST
-
Three things you must do when you inherit an Excel workbook
When you inherit a workbook, don't put it into play without checking it out first with these three vital steps.
Posted by Susan Harkins | January 19, 2012, 10:49 AM PST | Latest comment by ssharkins@...
-
Use Access validation rules to ensure accurate data entry
Your Access database is only as sound as the data it stores. Data types can only do so much. The next step is to constrain input values using validation rules.
Posted by Susan Harkins | January 18, 2012, 8:02 AM PST
-
Office challenge: Can you continue numbering by column?
This week, test your Word skills by out-smarting Word's Numbering option to force numbering by column before by row.
Posted by Susan Harkins | January 18, 2012, 7:54 AM PST | Latest comment by smileyface522
-
How to delete duplicate values and duplicate records in Excel 2007 and 2010
Using Excel 2007 and 2010, you can use the same built-in feature to to delete duplicates in columns as well as duplicate rows.
Posted by Susan Harkins | January 17, 2012, 8:51 AM PST
-
Office solution: How to quickly add numbers in Word without a table
This week, learn the solution to last week's Office challenge: What's the quickest way to sum a series of numbers in Word?
Posted by Susan Harkins | January 12, 2012, 10:43 AM PST | Latest comment by jbenton@...
-
How to find duplicates in Excel
You'll need more than one trick up your sleeve to find duplicates in Excel.
Posted by Susan Harkins | January 12, 2009, 12:00 AM PST | Latest comment by NickNielsen
-
How to add a drop-down list to an Excel cell
Drop-down lists can greatly facilitate data entry. Here's a look at how to use Excel's data validation feature to create handy lists within your worksheets.
Posted by Susan Harkins | June 12, 2008, 12:00 AM PDT | Latest comment by AlemAdam
-
Save replies in folders other than the Sent folder to increase productivity
Finding messages in the Sent folder isn't for the meek; save replies with the messages instead. You'll never hunt for another reply.
Posted by Susan Harkins | January 12, 2012, 7:47 AM PST | Latest comment by kindozo
-
Transpose Excel data from rows to columns, or vice versa
When you need to flip-flop data in an Excel worksheet, don't waste time doing it manually. Excel offers a handy Transpose option that will quickly take care of the task.
Posted by Jeff Davis | June 23, 2009, 12:00 AM PDT | Latest comment by excelinexcel
-
White Papers
Rethink Your Storage With IBM
Data storage is an interesting thing. While it's easy to add more storage with band-aid solutions, before long, you'll need to seriously rethink how you store. For some advice, turn to this white...
From: IBM
Read more -
Webcasts
Live Webcast: 3 Simple Steps to Better Patch Security
For better patch security, you'll need to take some precautions and know how to react when the time comes. For help with that, check out this live webcast from TechRepublic.
From: Sophos
Register Now -
How to use Excel 2010's new conditional formatting with references
Excel 2010's new referencing option makes conditional formatting more powerful than ever before!
Posted by Susan Harkins | August 30, 2010, 8:40 AM PDT | Latest comment by cutietoy
-
Three things you must do when you inherit an Excel workbook
When you inherit a workbook, don't put it into play without checking it out first with these three vital steps.
Posted by Susan Harkins | January 19, 2012, 10:49 AM PST | Latest comment by ssharkins@...
-
Build a simple timesheet in Excel
Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.
Posted by Susan Harkins | January 26, 2010, 9:43 AM PST | Latest comment by excelinexcel
-
Convert your Word documents into PowerPoint 2007 presentations
If you need to make a PowerPoint presentation from a Word document, don't worry about endless cutting and pasting. Mary Ann Richardson shows how you can use Word's built-in formatting to make an...
Posted by Mary Ann Richardson | April 1, 2008, 12:00 AM PDT | Latest comment by venduco
-
How to Alphabetize Lists In Word
I learned something new the other day—Word can alphabetize a list. I’m sure many users already know this, but it’s brand new to me. Years ago, I could do this with WordPerfect, but I’ve...
Posted by Susan Harkins | May 29, 2007, 12:13 PM PDT
-
Create an Excel data entry form that includes check boxes
You can keep a lot of information on an Excel data entry form, but you can make it easier for your users -- and yourself -- to create tables by adding check boxes. Here's how to set up check boxes...
Posted by Mary Ann Richardson | July 31, 2007, 12:00 AM PDT | Latest comment by AlemAdam
-
Remove unwanted blank pages inserted after a Word table
When you create a table that ends at the bottom margin, Word automatically inserts a new blank page. If you turn on the Show/Hide button, it reveals a paragraph mark after the table. Follow these...
Posted by Mary Ann Richardson | November 20, 2007, 12:00 AM PST | Latest comment by trpemc
-
How to create an electronic form using Word 2010 content controls
Use Word 2010's content controls to create easy-to-use electronic forms. They're similar to Word 2003's form fields, but better.
Posted by Susan Harkins | March 30, 2011, 7:34 AM PDT | Latest comment by dlflynn
-
10 annoying Word features (and how to turn them off)
Word can be a little unruly sometimes, making inexplicable changes, inserting text you didn't ask for, and hijacking your formatting. Here are some common stunts that Word tries to pull on unwary...
Posted by Jody Gilbert | July 14, 2009, 12:00 AM PDT | Latest comment by Jerry Poon
-
Convert Office 2007 files to a 2003 readable format
As adoption of Microsoft Office 2007 becomes more prevalent, the likelihood that you will receive a document saved in the native Office 2007 format grows. If you and your organization are not...
Posted by Mark Kaelin | May 22, 2007, 8:29 AM PDT | Latest comment by AlemAdam
-
Use Word's Vertical Alignment settings to center a page
Centering text vertically isn't difficult; you just have to know where to look!
Posted by Susan Harkins | July 28, 2010, 6:30 PM PDT
-
Delete a stubborn page break in Word
Sometimes, Word won't let you delete a page break. The fix is usually simple -- although the cause might surprise you.
Posted by Susan Harkins | January 8, 2010, 7:13 AM PST | Latest comment by scole215
-
Quickly highlight matching values in Excel with keyboard shortcut
When you just need to see matching values and you don't want to filter or sort, try this Excel keyboard trick.
Posted by Susan Harkins | January 27, 2012, 6:42 AM PST | Latest comment by DBlayney
-
A quick tip for entering names into an expression
Show users this quick tip for entering range names into formulas and functions. It's easy to use and reduces errors from typos.
Posted by Susan Harkins | January 25, 2012, 12:27 PM PST | Latest comment by ssharkins@...
-
Use a formula to trigger Excel's Conditional Formatting feature
If you need a visual clue to hype a worksheet, use Excel's Conditional Formatting feature to help values stand out.
Posted by Susan Harkins | January 5, 2009, 1:07 PM PST | Latest comment by JNirvaha
-
Office challenge: What's the easiest way to select a specific cell when you return to a specific sheet?
In this week's challenge, help a user preserve the cursor location in a sheet whenever he/she returns to it.
Posted by Susan Harkins | January 25, 2012, 12:28 PM PST | Latest comment by foreigner
-
White Papers
Rethink Your Storage With IBM
Data storage is an interesting thing. While it's easy to add more storage with band-aid solutions, before long, you'll need to seriously rethink how you store. For some advice, turn to this white...
From: IBM
Read more -
Webcasts
Live Webcast: 3 Simple Steps to Better Patch Security
For better patch security, you'll need to take some precautions and know how to react when the time comes. For help with that, check out this live webcast from TechRepublic.
From: Sophos
Register Now
Resources from our Sponsor
- Maximize your company's technology resources with CDW data center optimization solutions
- Do more with less using CDW's power and cooling solutions.
- Get control over your data center with a smart power and cooling strategy from CDW.
- See how APC and CDW can help create efficiencies for your data center.
Keep Up with TechRepublic
Media Gallery
White Papers, Webcasts, and Downloads
-
White PapersPrevent Your Next Server Room Mishap With Proper Monitoring
Check out this white paper to learn more about monitoring systems and how they can help prevent your next server room mishap.
-
White Papers
Prevent Your Next Server Room Mishap With Proper Monitoring
-
Webcasts
Live Webcast: Fast and Efficient Business Security Strategies
From GFI Software -
White Papers
Rethink Your Storage With IBM
From IBM
