- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
Assemble professional documents with Word 2007's building blocks
Now that you've written your report, make it pop. Mary Ann Richardson explains how you can put together a great-looking document in a hurry using Word 2007's built-in components.
Posted by Mary Ann Richardson | August 7, 2007, 12:00 AM PDT
-
Let Access choose your data type format
Sometimes it is hard to tell which data type format to select for an Access field. For example, if your field's data type is Number, should you select General, Percent, or Integer? Also, which...
Posted by Mary Ann Richardson | August 7, 2007, 12:00 AM PDT | Latest comment by ssharkins@...
-
Tip: Quickly access just the right Outlook form
Outlook has a number of standard forms you interact with, and they're all specific to the task you're trying to complete. But with all of Outlook's views, it can be difficult to find just the...
Posted by Susan Harkins | August 4, 2007, 10:13 AM PDT
-
Hide columns in a form using Datasheet view
A Datasheet form is a form object that resembles a table or query in Datasheet view. The following view is actually a form, not a table or query. You might be surprised to learn that the...
Posted by Susan Harkins | August 4, 2007, 10:11 AM PDT
-
Best of both worlds: Office info meets the 10 Things list
Here in the Office blog, there's a steady supply of tips on solving problems, knocking out tasks, and helping users work effectively with the various Office apps. But sometimes, you might just...
Posted by Jody Gilbert | August 3, 2007, 1:22 PM PDT
-
Create process diagrams in less time with Word 2007's SmartArt
Word 2007's SmartArt makes diagram creation easier than ever, automatically resizing elements and allowing you to preview changes before you apply them. Here's how to create a simple diagram in...
Posted by Mary Ann Richardson | July 31, 2007, 12:00 AM PDT
-
Print mailing labels using the Label Wizard in Access
Word is handy for printing mailing labels, but did you know you can do it in Access too? Access' Label Wizard can perform many of the same versatile tasks you'd find in Word or Excel -- and, if...
Posted by Mary Ann Richardson | July 31, 2007, 12:00 AM PDT | Latest comment by CanOfPoke
-
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
-
SharePoint Server 2007 content types enable enhanced document management
This information is also available as a PDF download. Many SharePoint users already know that you can create a new Word document from within a document library. However, Microsoft Office...
Posted by Martin W. P. Reid | July 30, 2007, 9:44 AM PDT | Latest comment by simonessalamone
-
Print a logo in an Excel header
Excel isn’t a word processor, nor does it generate reports the way Access does. But that doesn’t mean you can’t improvise. For instance, you can display a graphic, such as a company logo, at...
Posted by Susan Harkins | July 25, 2007, 10:06 AM PDT
-
Add a Total row to your Access 2007 table
What's the bottom line? In Access 2007, you can calculate totals in table view. Here's how to add a Total row to your database and then analyze the data it presents.
Posted by Mary Ann Richardson | July 24, 2007, 12:00 AM PDT
-
Quickly convert text values to numbers with Excel's Paste Special
If you regularly copy numerical data from Access tables to Excel spreadsheets, you may know that doing calculations on the copied text is challenging, if possible at all. Here's how to convert...
Posted by Mary Ann Richardson | July 24, 2007, 12:00 AM PDT | Latest comment by viren_lucky1
-
Use Word 2007's contextual spell checker to avoid embarrassing errors
Word's spell checker may miss words that sound the same. Find out how to use Word 2007's contextual spell checker to avoid slipping on homonyms.
Posted by Mary Ann Richardson | July 24, 2007, 12:00 AM PDT | Latest comment by Trackstardeb
-
Hide duplicate values in an Access report
When pulling Access data together into a meaningful format, you may find that reports repeat data. Depending on how you're using the data, you may or may not want to display those duplicate...
Posted by Susan Harkins | July 23, 2007, 5:45 AM PDT
-
Tip: Print e-mail addresses
Printing a phone list of your Outlook contacts is simple. Click Contacts and then choose Arrange By from the View menu. Next, select Current View and finally, choose Phone List. To customize the...
Posted by Susan Harkins | July 19, 2007, 5:29 AM PDT
-
Insert directions into Word using Smart Tags
If you include an address with a Word document, you don't need to send readers to an online mapping service to figure out how to get there. Use Word's Smart Tag feature and give your readers...
Posted by Mary Ann Richardson | July 17, 2007, 12:00 AM PDT | Latest comment by kvick@...
-
Add a help button to Excel 2002/2003 applications
Sometimes words and numbers don't tell the whole picture. That's why Excel 2002/2003 allows you to create and display online help text and examples for your applications and embed them right in...
Posted by Mary Ann Richardson | July 17, 2007, 12:00 AM PDT
-
Save time by creating tables from Access 2007 field templates
Access 2007 data field templates are predefined data fields that you add to your own database tables, saving you the step of entering the same information each time. Here's how to create your own...
Posted by Mary Ann Richardson | July 17, 2007, 12:00 AM PDT
-
Tip: Quick access to Word codes and formatting
By default, Word’s formatting codes aren’t visible while you work, and most of us like it that way. When you need to see the codes, choose Options from the Tools menu and click the View tab...
Posted by Susan Harkins | July 16, 2007, 5:41 AM PDT
-
Grab user attention with blinking text in an Access form
A virus scan I use blows what sounds like a foghorn when it's done. I try to be out of the room because it's so loud and annoying. I prefer a gentler approach. Blinking signs are a good...
Posted by Susan Harkins | July 13, 2007, 3:05 PM PDT | Latest comment by mnmcollector@...
-
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
-
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
-
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
-
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@...
