- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
-
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
-
Diagnose problems in Word 2007 with Microsoft Office Diagnostics
If Word 2007 is dragging or even crashing already, you can do some diagnostics. Microsoft Office Diagnostics will check your computer for a variety of problems, including disk errors, updates, and...
Posted by Mary Ann Richardson | July 10, 2007, 12:00 AM PDT | Latest comment by amodkshukla
-
Let Access 2007 create a form from the active table
Access 2007 makes form creation easier than ever. Here's how to make a form from any table you open.
Posted by Mary Ann Richardson | July 10, 2007, 12:00 AM PDT | Latest comment by ollney.hoopai@...
-
Add help messages to Excel applications with Data Validation
Excel applications can get tricky, and it's not unusual for your users to need some help from time to time. Here's how to add a help message to any worksheet cells you choose -- without...
Posted by Mary Ann Richardson | July 10, 2007, 12:00 AM PDT
-
Tip: Customize Windows Regional settings
Dr. Keith Rowlings of South Africa recently asked an Outlook question. He wanted calendar view to display the day's name, along with date, as in Monday, July 9, 2002. That's how Outlook displays...
Posted by Susan Harkins | July 9, 2007, 11:03 AM PDT
-
Tip: Avoid trouble with Word tables
Word's table feature is easy to use and intuitive enough that most of us can insert a table without too much going wrong. The quickest way to create a table in Word is to enter the table's...
Posted by Susan Harkins | July 6, 2007, 11:03 AM PDT | Latest comment by augustine70_2000@...
-
How to reference an Access subform
Referencing subform controls always throws Access users for a loop while they're new to using Visual Basic for Applications (VBA). That's because Access views the subform as just another one of...
Posted by Susan Harkins | July 5, 2007, 3:05 PM PDT | Latest comment by askolits
-
Access 2007 bug list
Thanks to Marty Connelly, one of Microsoft's newest MVPs, for this link to a list of Access 2007 bugs and other good stuff, by Allen Browne.
Posted by Susan Harkins | July 4, 2007, 6:30 AM PDT
-
All-time favorite version of Word?
I've been writing about Word since it was a pup. And using it even longer -- all the way back to the days of Word for DOS and the first version of Mac Word. When I started writing The Cobb Group's...
Posted by Jody Gilbert | June 29, 2007, 6:19 AM PDT | Latest comment by AtCollege
-
How do I... Remove misspelled words from the custom dictionary in Office 2003 or 2007?
This information is also available as a PDF download. By default, Office 2003 offers a built-in custom dictionary that lets you store terms and names that would otherwise get flagged as...
Posted by Jody Gilbert | June 27, 2007, 1:27 PM PDT | Latest comment by rkuhn@...
-
Warning: New Outlook Patch Email a Fraud
Thanks to Ben Camm-Jones at WebUser for this warning. A new scam is a foot. If you receive an email warning about an Outlook vulnerability and guiding you to download a patch, don't fall for it....
Posted by Susan Harkins | June 27, 2007, 8:25 AM PDT | Latest comment by ipeters61
-
Download: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats
Generally, it takes people a while to upgrade. For what it’s worth, I've heard from users who have Office 2007, but they're not using it. While the ribbons wow users who are new to Office, they...
Posted by Susan Harkins | June 25, 2007, 6:37 AM PDT | Latest comment by ERISAgeek
-
2007 viewer and pdf downloads available
In previous discussions, I’ve posted links to viewers and a download for saving documents to PDF format. If you’re using Office 2007, there are two downloads you might be interested in....
Posted by Susan Harkins | June 24, 2007, 8:09 AM PDT | Latest comment by kethy123456
-
A word about SharePoint Server
Microsoft's big push with Office 2007 doesn't seem to be the suite itself but rather, SharePoint, which first showed up with Office 2003. SharePoint is a sever technology that allows organizations...
Posted by Susan Harkins | June 24, 2007, 7:43 AM PDT | Latest comment by CharlieSpencer_Palmetto
-
Tip: Hide sensitive data in Access
Anyone who works extensively with Access knows that it’s weak on security. Nothing Access offers will deter a determined hacker. That’s just a quick warning—if you’re working with...
Posted by Susan Harkins | June 21, 2007, 6:53 AM PDT
-
Tip: Shortcut for applying line spacing in Word documents
I love it when I find a keyboard shortcut that eliminates menu choices. Office is full of them and I'm still discovering them. Just the other day I discovered a couple that have been available for...
Posted by Susan Harkins | June 19, 2007, 4:58 PM PDT | Latest comment by esvlwg@...
-
Two new downloads offer one-stop info on Office 2007
Scattered throughout the Office blog, you'll find a number of "10 things" posts that touch on various Office 2007 overview topics (such as "10 Word 2007 features you can skip" and "10+ ways to...
Posted by Jody Gilbert | June 18, 2007, 1:32 PM PDT
-
How do I... remove the built-in icons from the Office My Places bar?
This information is also available as a PDF download. As I discussed in a previous entry, the My Places bar was introduced in Office 2000. It appears on the left side of the File Open and File...
Posted by Susan Harkins | June 18, 2007, 9:15 AM PDT
-
How-to change perspective in an Excel chart
Oh my, I had no idea you could do this with an Excel chart! What am I raving about? You can reverse the order of the axis values. You have to see this in action to appreciate it. First, look at a...
Posted by Susan Harkins | June 14, 2007, 5:49 AM PDT | Latest comment by ssharkins@...
-
Tip: Indenting paragraphs in Word
When typing letters and documents, we distinguish paragraphs in one of two ways: We use a tab character to indent the first line of each paragraph or we insert a blank line between paragraphs. If...
Posted by Susan Harkins | June 13, 2007, 7:06 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 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 jeboy.06
-
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
-
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
-
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
-
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@...
-
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
-
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
-
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
-
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
-
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@...
-
A quick way to delete blank rows in Excel
Deleting blank rows in an Excel data range is easy with this technique, but watch out for unintended consequences.
Posted by Susan Harkins | January 5, 2012, 11:48 AM PST | Latest comment by jbenton@...
-
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
-
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
