- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
How to pull a paragraph in Word into the left margin
It's easier than you might think to pull text into the left margin. Doing so is as simple as setting a format option, but in an unusual way.
Posted by Susan Harkins | April 2, 2012, 11:38 AM PDT | Latest comment by jonc2011
-
Office solution: When a looping introduction refuses to stop
This week, learn the possible solutions to last week's challenge: When you can't get a looping introduction to stop.
Posted by Susan Harkins | March 29, 2012, 8:29 AM PDT | Latest comment by Centennial00
-
Set PowerPoint's default view to a setting that suits you
Reset PowerPoint's default view setting to one that matches your work habits and current needs.
Posted by Susan Harkins | March 29, 2012, 8:19 AM PDT
-
How to repeat pivot table headings when printing Excel documents
A pivot table that spans more than one printed page will be confusing without its column headings. Use this tip to print column headings on every sheet.
Posted by Susan Harkins | March 28, 2012, 11:03 AM PDT | Latest comment by jensqox@...
-
Count the number of Excel records that fall between two dates
Using Excel's COUNTIFS() function, you can quickly count records that fall between two dates.
Posted by Susan Harkins | March 26, 2012, 8:38 AM PDT | Latest comment by N / A
-
Make the right decisions when starting a free trial of Office 365
Make sure you choose the correct Microsoft Office 365 plan for your free trial. Brett Hill shows you what you need to consider for each decision.
Posted by Brett Hill | March 23, 2012, 12:44 PM PDT | Latest comment by office365guy
-
Office solution: When a presentation doesn't play a music file
This week, learn the possible solutions to last week's challenge: Why doesn't my presentation play music?
Posted by Susan Harkins | March 23, 2012, 7:53 AM PDT
-
Copy an Excel sheet from one workbook to another
Susan Harkins shows you two quick ways to copy data from one Excel workbook to another.
Posted by Susan Harkins | March 22, 2012, 8:39 AM PDT | Latest comment by Standss
-
Office challenge: What to do when you can't get a looping introduction to stop?
This week, test your PowerPoint skills by troubleshooting an introductory loop that doesn't know when it's time to quit.
Posted by Susan Harkins | March 21, 2012, 8:16 AM PDT | Latest comment by dcsloan128@...
-
How to prefix a numbered list in Microsoft Word
Susan Harkins shows you how to quickly add a descriptive prefix to a numbered list in a Word document.
Posted by Susan Harkins | March 20, 2012, 8:24 AM PDT
-
Add helpful information fields to a shared document
To display specific information about a shared Word document including its author, you can use the fields feature.
Posted by Susan Harkins | March 19, 2012, 7:53 AM PDT
-
Microsoft Office 365 and Microsoft Office 2010: Better together
Office 365 MVP Brett Hill highlights how well Microsoft Office 365 works with the stand-alone version of Office 2010.
Posted by Brett Hill | March 16, 2012, 12:06 PM PDT | Latest comment by HAL 9000
-
Create a table of contents in an Excel sheet using hyperlinks
Show users how to create a quick table of contents in Excel using the power of hyperlinks.
Posted by Susan Harkins | March 16, 2012, 10:17 AM PDT | Latest comment by jgfelicio@...
-
Office challenge: Why doesn't my presentation play music?
This week, test your PowerPoint skills by troubleshooting a presentation, complete with music, that doesn't play the music on any computer other than the author's.
Posted by Susan Harkins | March 15, 2012, 11:32 AM PDT | Latest comment by pptmagic
-
Office solution: Displaying the total number of pages in a section
This week, learn the solution to last week's Word challenge: How would you display the total page numbers in a section?
Posted by Susan Harkins | March 15, 2012, 11:30 AM 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@...
-
Avoid a few pitfalls when changing an existing Word style
Changing an existing style is easy, but how will your document respond? How will existing or future documents respond? Learn what to expect and avoid pitfalls when changing styles.
Posted by Susan Harkins | March 13, 2012, 10:48 AM PDT | Latest comment by ssharkins@...
-
Use PowerPoint's laser pointer to catch attention and add excitement
Use PowerPoint's cool laser pointer feature to simulate a laser pointer during a PowerPoint presentation.
Posted by Susan Harkins | March 9, 2012, 7:05 AM PST | Latest comment by zaphod1701
-
Office challenge: How would you display the total page numbers in a section?
Configure the x of y page numbering format where y reflects the position of the current page within the section, rather than the total document page count.
Posted by Susan Harkins | March 8, 2012, 7:09 AM PST | Latest comment by mark@...
-
Office solution: A quick way to rearrange PowerPoint slides
This week, learn the solution to last week's PowerPoint challenge: help this user quickly rearrange slides in a PowerPoint presentation.
Posted by Susan Harkins | March 7, 2012, 8:13 AM PST
-
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
-
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
-
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@...
