- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
Use Word 2010's check box content controls to mark attendance
Check box controls provide a visual way to express two possibilities. In this quick example, learn how to use them to mark attendance.
Posted by Susan Harkins | May 10, 2011, 11:42 AM PDT
-
Office Challenge: Why won't Word hide index tags?
In this week's challenge, test your Word skills with an obscure display option and learn the solution to last week's Styles pane challenge.
Posted by Susan Harkins | May 10, 2011, 10:33 AM PDT
-
Use Excel's conditional formatting features to highlight input cells
Conditional formatting is great for adding visual clues to values, but you can also use it to identify input cells to guide users through a data entry task.
Posted by Susan Harkins | May 9, 2011, 7:01 AM PDT
-
Quick Tip: Use this mouse trick to edit Excel formulas
Instead of manually typing pieces of a cell reference, use this quick mouse trick to extend the reference when modifying a formula.
Posted by Susan Harkins | May 4, 2011, 8:29 AM PDT
-
Office challenge: Why are some of the Style Pane options disabled?
Take a crack at the latest TechRepublic Microsoft Office Challenge and match wits with your peers. The Challenge: Why are some of the Style Pane options disabled?
Posted by Susan Harkins | May 3, 2011, 8:26 AM PDT
-
Use a gradient fill in PowerPoint to add interesting effects to circle shapes
Susan Harkins shows you how to add a gradient fill pattern to add interesting layers to a circle shape within a PowerPoint slide.
Posted by Susan Harkins | May 2, 2011, 12:26 PM PDT
-
Two quick methods for removing data validation rules in Excel
Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time.
Posted by Susan Harkins | April 29, 2011, 10:31 AM PDT
-
A quick fill handle trick for Microsoft Excel
If you think you know every fill handle trick in the book, there just might be one more you don't know about. Susan Harkins explains.
Posted by Susan Harkins | April 28, 2011, 12:56 PM PDT
-
Office challenge: Why is PowerPoint losing hyperlinks
Take a crack at the latest TechRepublic Microsoft Office Challenge and match wits with your peers. Check out and critique the correct answer to last week's Challenge.
Posted by Susan Harkins | April 26, 2011, 1:23 PM PDT
-
Quickly save a new style in Word with these shortcuts
After you've formatted text in a special way, will you need the format again? If so, save a new style using the formatted text!
Posted by Susan Harkins | April 25, 2011, 8:04 AM PDT
-
Quick mouse access to the Go To tab is just a click away
Keyboard shortcuts are always efficient but there are other quick routes to the Microsoft Word features you use a lot.
Posted by Susan Harkins | April 25, 2011, 7:55 AM PDT
-
Add a dictionary-style header to your Word document
Use the StyleRef field in Microsoft Word to display a dictionary-style header (or footer) in your Word documents.
Posted by Susan Harkins | April 25, 2011, 7:42 AM PDT
-
Office challenge: How would you include a blank page at the end of a document if the last page is odd?
Learn the solution to last week's Word challenge and test your skills with this week's new Word challenge.
Posted by Susan Harkins | April 19, 2011, 8:52 AM PDT
-
Use wildcards with SUMIF() to create a powerful Excel function
You already know that SUMIF is a useful function. Combine it with wildcards and you've got one powerful function!
Posted by Susan Harkins | April 19, 2011, 8:40 AM PDT
-
How to inhibit a page number for the first page in a Word document
Your users might have trouble finding the built-in solution to inhibit a page number, even though it's an easy-to-implement solution.
Posted by Susan Harkins | April 15, 2011, 10:47 AM PDT
-
Some of my favorite Outlook Calendar keyboard shortcuts
If you work in Outlook's Calendar view a lot, you'll appreciate these keyboard shortcuts and their ability to increase your efficiency.
Posted by Susan Harkins | April 14, 2011, 7:39 AM PDT
-
Quick Tip: Easy filtering of data in Excel
Filters for data in Microsoft Excel are just a click away with this simple-to-implement filtering technique. Susan Harkins shows you how it works.
Posted by Susan Harkins | April 13, 2011, 6:47 AM PDT
-
Office challenge: Why does my Word document look different on my home computer?
Learn the solution to last week's PowerPoint challenge and test your skills on this week's new Word challenge.
Posted by Susan Harkins | April 12, 2011, 8:51 AM PDT
-
Use custom markers to create a more compelling Excel chart
Some Excel charts use markers and you might be surprised to learn how easy it is to customize those markers to make your chart more compelling.
Posted by Susan Harkins | April 12, 2011, 6:45 AM PDT
-
How to apply your favorite Word styles with a single click
Styles provide an easy way to manage documents with multiple formatting requirements. With just a little coaxing, you can display your most-used styles in the Quick Style Gallery so they're just a...
Posted by Susan Harkins | April 7, 2011, 10:28 AM PDT
-
Two ways to add checkbox controls to a Word document
Use a customized bulleted list or a content control to insert checkboxes into a Word document, depending on how you are going to use it.
Posted by Susan Harkins | February 22, 2012, 8:16 AM PST
-
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
-
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
-
Use SUMIFS() to sum by multiple conditions in Excel
Excel's SUMIF() lets you sum values, conditionally. It's new sibling, SUMIFS() lets you sum values by multiple conditions.
Posted by Susan Harkins | November 14, 2011, 11:25 AM PST
-
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
-
Add horizontal lines to a Word document
Susan Harkins shows you two easy ways to insert a horizontal line into a Word document.
Posted by Susan Harkins | September 29, 2010, 12:00 AM PDT
-
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
-
Four ways to insert an em dash in a Word document
When you need an em dash, you can let Word enter it for you the easy way. If that approach doesn't suit your needs, try one of three manual methods.
Posted by Susan Harkins | March 1, 2010, 12:00 AM PST
-
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
-
Use COUNTIFS() to evaluate multiple count and criteria ranges
Excel's COUNTIFS() function is flexible enough to handle different ranges and data types.
Posted by Susan Harkins | May 21, 2012, 10:37 AM PDT
-
The secret to unhiding column A in an Excel worksheet
After you hide column A, it might seem like it's gone forever. Fortunately, there are two simple tricks for unhiding it.
Posted by Susan Harkins | March 16, 2009, 12:00 AM PDT
-
Quickly fill blank cells in Excel
Blank cells can spell trouble. Here's an easy way to fill in those blanks and protect the validity of your data.
Posted by Susan Harkins | April 26, 2010, 10:50 AM PDT
-
A quick and dirty way to compare columns of Excel data
Using this little-known feature in Excel, you can quickly compare one column of data to another.
Posted by Susan Harkins | April 6, 2012, 11:41 AM PDT
-
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
-
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
-
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
-
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
-
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
-
10 things you can do to give your PowerPoint presentations a heartbeat
This information is also available as a PDF download. Imagine this: You've just returned to your seat for this afternoon's training seminar. The morning session was pretty interesting, providing...
Posted by Katherine Murray | July 10, 2007, 2:44 PM PDT
-
Use a custom format in Excel to display easier to read millions
Use a custom format in Microsoft Excel to reduce the number of digits in a large number without losing its scale.
Posted by Susan Harkins | March 14, 2012, 11:16 AM PDT
