- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
How to replace extraneous text for application names on menus
Is it just me or do the long application names on the program menu annoy you? Of course, all the applications on the Microsoft Office menu are Microsoft products. How many times must I read...
Posted by Susan Harkins | November 9, 2007, 12:00 AM PST
-
How to add an Office application to the Windows Quick Launch toolbar
The more technology we have, the more we want. For some of us it’s just about getting our work done, and there’s nothing wrong with that. While I spend a lot of time solving custom problems...
Posted by Susan Harkins | November 7, 2007, 12:00 AM PST
-
Taking a look at IBM Lotus Symphony Presentations
Continuing with my first-look series covering the IBM Lotus Symphony office suite, I've created a gallery covering the slideshow application, Symphony Presentations. (I covered Symphony Documents...
Posted by Greg Shultz | November 6, 2007, 9:59 AM PST
-
How to keep someone from turning off Track Changes in a Word document
Word's Track Changes feature allows you to see changes that you and others make to a document. You enable this feature by choosing Track Changes from the Tools menu or by double-clicking the TRK...
Posted by Susan Harkins | November 6, 2007, 8:24 AM PST | Latest comment by raygbutler@...
-
Easily change a picture's shape and shadow in Word 2007
In Word 2007, you can preview a change you'd like to make to a picture, such as rounded corners or a drop shadow, before you actually apply it. Mary Ann Richardson explains how.
Posted by Mary Ann Richardson | November 6, 2007, 12:00 AM PST
-
Create a macro for printing multiple Access reports
Did you know that you can create a macro to print a number of Access reports all at once? Mary Ann Richardson shows you the steps.
Posted by Mary Ann Richardson | November 6, 2007, 12:00 AM PST | Latest comment by john.nealis@...
-
Help users get to their Excel workbooks quickly
Rather than having your employees navigate through different folders to get to their Excel workbooks, allow them to place them all into their Favorites folder. Follow these steps to make it easier...
Posted by Mary Ann Richardson | November 6, 2007, 12:00 AM PST | Latest comment by LocoLobo
-
Tip: Quick toggles on Word’s status bar
When I find a quick and easy solution, I do one of two things -- I cheer or I roll my eyes. This morning, I'm rolling my eyes at myself. Sometimes I wonder if I'm smart enough to make coffee, let...
Posted by Susan Harkins | November 2, 2007, 8:14 AM PDT | Latest comment by ssharkins@...
-
Limit your Style list in Word to your favorites
If you use only a few of the available Word document styles, you can save yourself time by limiting the list to only those styles you frequently use instead of scrolling through all the styles...
Posted by Mary Ann Richardson | October 30, 2007, 12:00 AM PDT
-
Use Access menus to add page numbers, dates, and times to your reports
In Access, you can use menus to add page numbers, dates, and times to your reports -- and Access provides menus so that you don't have to know the code for setting these controls. Here's how to...
Posted by Mary Ann Richardson | October 30, 2007, 12:00 AM PDT
-
Export your VBA code for use in another Excel application
After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply...
Posted by Mary Ann Richardson | October 30, 2007, 12:00 AM PDT | Latest comment by shanu.vb
-
Taking a look at IBM Lotus Symphony Spreadsheets
Continuing my series of first-look galleries covering the IBM Lotus Symphony office suite, I've created a gallery introducing the spreadsheet application, Symphony Spreadsheets. (I covered the...
Posted by Greg Shultz | October 26, 2007, 11:35 AM PDT
-
Office 2003 SP3 breaks AutoCorrect
The AutoCorrect feature does not work in Outlook 2003 after you install Office 2003 SP3 This one's making the rounds in the usual places this morning.
Posted by Susan Harkins | October 24, 2007, 11:32 AM PDT | Latest comment by JLivengood
-
Find it in Word 2007: Change Case
Word's Change Case feature has long been one of its handiest devices. It's not smart enough to apply true title case (where articles and prepositions are left uncapitalized), but it will still...
Posted by Jody Gilbert | October 23, 2007, 2:50 PM PDT | Latest comment by Winnietang
-
Taking a look at IBM Lotus Symphony Documents
A long time ago, in a world of DOS-based computers, a company called Lotus Development Corporation decided to capitalize on the success of its groundbreaking Lotus 1-2-3 spreadsheet application...
Posted by Greg Shultz | October 23, 2007, 8:56 AM PDT
-
Prevent users from changing data by using Access form control properties
Access allows you to prevent users from inadvertently changing data on their forms. Here's how to set the control properties called Enable and Locked to prevent data entry.
Posted by Mary Ann Richardson | October 23, 2007, 12:00 AM PDT
-
Save time in Excel with automated reports
You can use Excel programming to automate a lot of your employees' monthly reporting. For example, if your employees submit a monthly travel expense report, learn how you can develop an...
Posted by Mary Ann Richardson | October 23, 2007, 12:00 AM PDT | Latest comment by wizard57m-cnet
-
Change the default font in Word 2007
Word 2007's Normal template uses a new default font, Calibri 11. If you have been using Times New Roman or Arial 12 as your default font, you still can -- just change the default. It's easy --...
Posted by Mary Ann Richardson | October 23, 2007, 12:00 AM PDT | Latest comment by Larry@...
-
How to show filename extensions
By default, Windows doesn't display filename extensions. They're there, you just can't see them. An extension is the three-character suffix at the end of a filename. The extension tells you the...
Posted by Susan Harkins | October 22, 2007, 12:37 PM PDT | Latest comment by charkaye17
-
Tip: Quick access to Word styles
Word comes with several predefined styles, but not all of them are available via the Styles control on the Formatting toolbar. In fact, only a few are in that control's drop-down list. When a...
Posted by Susan Harkins | October 22, 2007, 12:00 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 | 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@...
