- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
How to create one table of contents from multiple documents
I is possible to create a single table of contents for multiple Word documents, it just requires an extra step or two. Susan Harkins explains how.
Posted by Susan Harkins | August 17, 2011, 10:48 AM PDT | Latest comment by tomkinsr@...
-
How to insert a table of contents into a Word document
Susan Harkins shows you how easy it is to insert a table of contents into a Word document using the built-in default styles.
Posted by Susan Harkins | August 16, 2011, 1:22 PM PDT | Latest comment by wordknowhow
-
15 ways to select text in a Word document
There are many ways to select Word text - 15 at least! Susan Harkins shares her favorite selection methods.
Posted by Susan Harkins | August 15, 2011, 10:56 AM PDT | Latest comment by smca
-
Enter date values quickly using these Excel tricks
Susan Harkins explains how to use these simple tricks to enter date values quickly and intuitively into Microsoft Excel.
Posted by Susan Harkins | August 12, 2011, 11:06 AM PDT | Latest comment by berth@...
-
Use Paste Special to perform calculations while pasting in Excel
Use Excel's Paste Special feature to calculate multiple values against a data range, at the same time. You can make the process even more efficient with keyboard shortcut combinations.
Posted by Susan Harkins | August 11, 2011, 8:10 AM PDT | Latest comment by david.hanshumaker@...
-
Solution: How do you count the results of a filtered set?
Read the easy solution to last week's Office Challenge: how to count items in a filtered set. Have you got a better solution? Let us know about it.
Posted by Susan Harkins | August 10, 2011, 12:42 PM PDT
-
Office challenge: How would you print index cards in Word?
In this week's Office Challenge, test your Word skills with an interesting printing challenge involving index cards.
Posted by Susan Harkins | August 10, 2011, 12:36 PM PDT | Latest comment by dhays
-
Get Outlook to default to the address book you choose
You're not stuck with Outlook's default address book; with a simple setting change, you can determine which address book Outlook uses.
Posted by Susan Harkins | August 9, 2011, 11:42 AM PDT | Latest comment by cbrady@...
-
A macro to unhide all hidden sheets in an Excel workbook
Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel workbook.
Posted by Susan Harkins | August 8, 2011, 7:08 AM PDT | Latest comment by DBlayney
-
Office challenge: How do you count the results of a filtered set?
In this week's Office challenge, tests your Excel skills by providing a solution that can count filtered rows.
Posted by Susan Harkins | August 4, 2011, 8:00 AM PDT | Latest comment by mvdarend
-
Solution: How would you count personnel selling below quota?
Read the easy solution to last week's challenge: how to use a dynamic counting formula that references a table.
Posted by Susan Harkins | August 4, 2011, 7:56 AM PDT
-
A Word macro that highlights and lists misspelled words
Susan Harkins shares a macro that will highlight all misspelled words and copy them to a new document to make them easy to find and correct.
Posted by Susan Harkins | August 3, 2011, 1:39 PM PDT | Latest comment by ssharkins@...
-
Rotate PowerPoint's flip entrance for an unusual twist
Susan Harkins explains how to use the flip entrance effect in combination with a simple change of perspective to add an elegant bit of excitement to a PowerPoint presentation.
Posted by Susan Harkins | August 2, 2011, 11:02 AM PDT | Latest comment by JaneHawkins
-
A cheatsheet of Excel shortcuts that make inserting data faster
These handy Microsoft excel shortcuts will help you enter data, create names, and complete functions easier and more efficiently once you start using them regularly.
Posted by Susan Harkins | August 1, 2011, 7:51 AM PDT | Latest comment by medler1@...
-
Add Next Page and Previous Page to Word 2010's ribbon
You can work more efficiently by adding options and commands that you use a lot to a custom group on the Office 2010 ribbon.
Posted by Susan Harkins | July 29, 2011, 11:23 AM PDT | Latest comment by ssharkins@...
-
Office Challenge: How would you count personnel selling below quota?
In this week's Office Challenge, Susan Harkins tests your Excel skills by creating a dynamic counting function. Can you meet the challenge?
Posted by Susan Harkins | July 28, 2011, 10:21 AM PDT | Latest comment by RRB
-
Solution: What's the easiest way to migrate your customized Word 2003 Normal.dot?
Read the easy solution to last week's challenge: how to quickly migrate a custom Word template when upgrading.
Posted by Susan Harkins | July 28, 2011, 10:14 AM PDT
-
Quickly copy your signatures to another computer
Don't hunt and peck looking for signature files when you need to update a new computer or share them with a second computer, use this quick shortcut to find signature files.
Posted by Susan Harkins | July 27, 2011, 7:38 AM PDT | Latest comment by CharlieSpencer_Palmetto
-
Use Excel's table nomenclature to quickly create dynamic formulas
In Excel, defining a data range as a table opens the door to a number of efficient behaviors. Susan Harkins explains how to use nomenclature to create and use dynamic formulas.
Posted by Susan Harkins | July 22, 2011, 10:17 AM PDT | Latest comment by LonMcClure
-
Use the Find A Contact control to quickly find any Outlook contact
Viewing contact information was never easier. From 2010's new Home tab, you can view contact information for anyone in your address book, without leaving the current window!
Posted by Susan Harkins | July 21, 2011, 8:05 AM PDT | Latest comment by HAL 9000
-
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 | Latest comment by ian@...
-
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 dhivya.vasu01@...
-
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
-
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 | Latest comment by peter.r7
-
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 manishdhir
-
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 | Latest comment by Shrike49
-
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 | Latest comment by Marshwiggle
-
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 | Latest comment by jbenton@...
-
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 | Latest comment by fallon.stuart@...
-
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 | Latest comment by Midhunmj
-
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 | Latest comment by HAL 9000
-
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 nor12345
-
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 raj_as
-
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 Corbybhoy
-
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 kramer22
-
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 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
-
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 | Latest comment by jeng02@...
