- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
Office challenge: Why aren't my formulas calculating correctly?
This week, test your Excel skills against a workbook that suddenly stops calculating correctly.
Posted by Susan Harkins | September 14, 2011, 7:50 AM PDT | Latest comment by mrsmithatraytheon
-
Office solution: Why the reverse print option might not work
The solution to last week's Office Challenge: learn how easy it is to solve the reverse printing mystery.
Posted by Susan Harkins | September 14, 2011, 7:42 AM PDT
-
How to unhide row 1 and column A in an Excel sheet
The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.
Posted by Susan Harkins | September 13, 2011, 7:51 AM PDT | Latest comment by SirWizard
-
Quickly format subtotaling rows to increase your productivity
Use this easy selection trick when you apply formatting to subtotaling cells or rows to save yourself some time.
Posted by Susan Harkins | September 12, 2011, 1:01 PM PDT | Latest comment by alecpjd
-
Keep up with your favorite sites and blogs using Outlook's RSS feed
Susan Harkins explains how to use Outlook's RSS feed feature to have newly published content delivered right to your Inbox.
Posted by Susan Harkins | September 9, 2011, 8:11 AM PDT | Latest comment by Mark W. Kaelin
-
Office challenge: Why doesn't reverse print work?
This week, test your Word printing skills when Word's reverse printing option doesn't seem to work.
Posted by Susan Harkins | September 8, 2011, 1:05 PM PDT | Latest comment by Too-Tired Techie
-
How to print a section of a Word document
There's no obvious way to print the sections of a Word document, but you can still do it! Susan Harkins reveals the secret.
Posted by Susan Harkins | September 8, 2011, 1:01 PM PDT | Latest comment by kprince@...
-
Use Excel's Find feature to find and select cells
When you need to select several cells with a similar attribute, you can use Excel's Find feature to make the process eaiser.
Posted by Susan Harkins | September 7, 2011, 7:36 AM PDT
-
Display page-dependent messages in a header or footer
Use Word field codes to display informational messages in headers and footers, depending on the current page.
Posted by Susan Harkins | September 1, 2011, 8:25 AM PDT | Latest comment by Jeff_Mason
-
Office challenge: Can you troubleshoot this database error?
This week, troubleshoot a mysterious and troublesome error after what should've been a quick and easy enhancement goes sour.
Posted by Susan Harkins | September 1, 2011, 8:18 AM PDT | Latest comment by iandrew@...
-
Office solution: This is how to disable that graph paper effect in Word
Learn the answer to last week's Office challenge: Why is Word displaying graph paper?
Posted by Susan Harkins | September 1, 2011, 8:10 AM PDT | Latest comment by howamil1
-
Use Excel's conditional formatting feature to display simple icons
Understanding your data and how Excel's conditional formatting works is the key to accurately using icons to represent data.
Posted by Susan Harkins | August 31, 2011, 7:34 AM PDT | Latest comment by oliverbartholdson
-
Use Word 2010's Navigation Pane to quickly reorganize documents
Use Word 2010's new Navigation Pane to quickly move sections in a document; it's much quicker and easier than trying to select and move all that content manually.
Posted by Susan Harkins | August 30, 2011, 7:10 AM PDT | Latest comment by birumut
-
Office challenge: Why is Word displaying graph paper?
In this week's challenge, help a Word user who's seeing graph paper! Where did they come from and can you help him get rid of them?
Posted by Susan Harkins | August 25, 2011, 1:26 PM PDT | Latest comment by clop0455@...
-
Office solution: Here is how you inhibit formats when using the fill handle
Read the solution to last week's Office challenge: how would you inhibit formats when using the fill handle?
Posted by Susan Harkins | August 25, 2011, 1:25 PM PDT | Latest comment by birumut
-
Five keyboard shortcuts for inserting arrows into a Word document
Susan Harkins shows you five keyboard shortcuts that allow you to quickly insert arrows into a Word document.
Posted by Susan Harkins | August 24, 2011, 7:19 AM PDT | Latest comment by birumut
-
Five of my favorite Excel worksheet tips
If you're not using these worksheet-related tricks, you're working harder than you have to! Susan Harkins shares five of her favorites.
Posted by Susan Harkins | August 23, 2011, 6:56 AM PDT | Latest comment by birumut
-
Three tips for working with bullets in PowerPoint
If you think you don't have the skills to create a bullet-less PowerPoint presentation, take a look at these three easy tips.
Posted by Susan Harkins | August 22, 2011, 12:52 PM PDT
-
Solution: How would you print index cards in Word?
Read the solution to last week's Office challenge: how do you format and print index cards in Word.
Posted by Susan Harkins | August 18, 2011, 8:20 AM PDT | Latest comment by ssharkins@...
-
Office challenge: How would you inhibit formats when using the fill handle?
In this week's Office Challenge, test your Excel skills with an simple fill handle trick for inhibiting formats.
Posted by Susan Harkins | August 18, 2011, 8:15 AM PDT | Latest comment by ssharkins@...
-
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 david.hanshumaker@...
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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 | Latest comment by jeng02@...
