- Follow this blog:
- RSS
- Email Alert
Microsoft Office
Mark Kaelin
TechRepublic Staff
Mark Kaelin
Must-Read Post
Nine guidelines for writing effective email messages
If you want people to pay more attention to your email, perhaps you should pay more attention to your email!
-
Three ways to hide zero values in an Excel sheet
Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an Excel sheet.
Posted by Susan Harkins | June 21, 2012, 8:18 AM PDT | Latest comment by ssharkins@...
-
An alternative Excel averaging formula that doesn't evaluate zero
Excel's AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives.
Posted by Susan Harkins | June 20, 2012, 11:49 AM PDT
-
Tweak an annoying AutoCorrect entry instead of deleting it outright
You can delete a problematic AutoCorrect entry or you can try this case shuffling trick to have your cake and eat it too.
Posted by Susan Harkins | June 19, 2012, 8:48 AM PDT | Latest comment by ssharkins@...
-
Quickly delete whole paragraphs by searching styles
Using styles often has unexpected perks. For instance, you can delete multiple paragraphs by relying on a style.
Posted by Susan Harkins | June 14, 2012, 7:07 AM PDT | Latest comment by ssharkins@...
-
Outlook's conversation settings lead to a more efficient Inbox
Use Outlook's conversation view to arrange related messages into meaningful groups.
Posted by Susan Harkins | June 12, 2012, 12:20 PM PDT | Latest comment by evdbogaard
-
A quick Excel keyboard trick for selecting large ranges
You'll want to add this quick selection trick to your repertoire. It's handy when the range isn't a complete data range or it comprises more than one data range.
Posted by Susan Harkins | June 11, 2012, 10:53 AM PDT | Latest comment by wilkisa
-
Slicers provide a quick way to filter an Excel pivot table
Filtering a pivot table isn't hard, but Excel 2010 slicers make it even easier.
Posted by Susan Harkins | June 7, 2012, 7:56 AM PDT | Latest comment by ssharkins@...
-
How to customize Word bullet points
Word's default bullet character is adequate, but you can add a bit of distinction or creativity by using custom bullet characters.
Posted by Susan Harkins | June 5, 2012, 8:21 AM PDT | Latest comment by ssharkins@...
-
Quick Tip: Apply a uniform size to all charts on an Excel sheet
After adding several charts to a sheet, you might want to adjust their sizes so they're all the same. You can do so manually or by using the easy macro.
Posted by Susan Harkins | June 4, 2012, 11:03 AM PDT | Latest comment by JSmotherman
-
Generate random dates within a specific date range
Excel's RAND() functions generate random values between 0 and 1. When you need a little more flexibility try RANDBETWEEN().
Posted by Susan Harkins | May 31, 2012, 11:28 AM PDT
-
Highlight text with the gradient fill effect in Word
Using font colors is nothing new, but you can also apply a gradient fill effect to text. Here's how.
Posted by Susan Harkins | May 30, 2012, 7:47 AM PDT | Latest comment by jacinorwood@...
-
Highlight the minimum and maximum values for Excel subsets
Excel's MIN() and MAX() function work great, until you want to use them on a subset of data. Consider using this conditional formatting rule.
Posted by Susan Harkins | May 29, 2012, 8:00 AM PDT | Latest comment by DBlayney
-
Display the slideshow name on all your PowerPoint slides
Use this simple VBA macro to display your presentation's name on all your PowerPoint slides.
Posted by Susan Harkins | May 24, 2012, 6:50 AM PDT | Latest comment by pptcrafter
-
Office solution: Clearing up that wacky date problem when copying sheets
This week, learn the solution to the last Office challenge: Why does Excel change dates when I copy a sheet to a new workbook?
Posted by Susan Harkins | May 23, 2012, 10:27 AM PDT
-
A quick Word trick for typing text into a scanned document
This quick trick will have you up filling in scanned paper forms in less than two minutes.
Posted by Susan Harkins | May 22, 2012, 8:07 AM PDT | Latest comment by Shadeburst
-
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
-
Use Word macros to save your place in a document
Use these two simple Word macros to temporarily bookmark a spot you want to return to later.
Posted by Susan Harkins | May 17, 2012, 8:19 AM PDT | Latest comment by uri1090
-
Challenge solution: How to set all workbooks to R1C1 referencing
This week, learn the solution to the recent challenge: Can you help a user who wants all workbooks to default to R1C1 referencing?
Posted by Susan Harkins | May 16, 2012, 10:46 AM PDT
-
Implement a search offset in an Access form
Adding search capability to an Access form is pretty easy, but users might appreciate a bit more flexibility by letting them also set an offset value.
Posted by Susan Harkins | May 15, 2012, 8:14 AM PDT
-
Use COUNTIFS() to compare two data sets in Excel
There are lots of ways to find duplicates in the same set of records. Using the COUNTIFS() function, you can compare different data sets for duplicate records.
Posted by Susan Harkins | May 14, 2012, 7:59 AM PDT
-
How to find duplicates in Excel
You'll need more than one trick up your sleeve to find duplicates in Excel.
Posted by Susan Harkins | January 12, 2009, 12:00 AM PST | Latest comment by exisllc
-
A quick Word trick for typing text into a scanned document
This quick trick will have you up filling in scanned paper forms in less than two minutes.
Posted by Susan Harkins | May 22, 2012, 8:07 AM PDT | Latest comment by Shadeburst
-
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
-
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 cutietoy
-
A quick Excel keyboard trick for selecting large ranges
You'll want to add this quick selection trick to your repertoire. It's handy when the range isn't a complete data range or it comprises more than one data range.
Posted by Susan Harkins | June 11, 2012, 10:53 AM PDT | Latest comment by wilkisa
-
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
-
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
-
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 AlemAdam
-
How to create an electronic form using Word 2010 content controls
Use Word 2010's content controls to create easy-to-use electronic forms. They're similar to Word 2003's form fields, but better.
Posted by Susan Harkins | March 30, 2011, 7:34 AM PDT | Latest comment by markwilla
-
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 excelinexcel
-
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 annoying Word features (and how to turn them off)
Word can be a little unruly sometimes, making inexplicable changes, inserting text you didn't ask for, and hijacking your formatting. Here are some common stunts that Word tries to pull on unwary...
Posted by Jody Gilbert | July 14, 2009, 12:00 AM PDT | Latest comment by tech trog
-
Remove unwanted blank pages inserted after a Word table
When you create a table that ends at the bottom margin, Word automatically inserts a new blank page. If you turn on the Show/Hide button, it reveals a paragraph mark after the table. Follow these...
Posted by Mary Ann Richardson | November 20, 2007, 12:00 AM PST | Latest comment by vgrandja
-
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
-
Quick Tip: Apply a uniform size to all charts on an Excel sheet
After adding several charts to a sheet, you might want to adjust their sizes so they're all the same. You can do so manually or by using the easy macro.
Posted by Susan Harkins | June 4, 2012, 11:03 AM PDT | Latest comment by JSmotherman
-
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 scole215
-
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 jalong@...
-
Where's the Convert Table To Text command in Word 2007 and 2010
Want to convert a Word 2007 table to text? You won't find the command in the most obvious place, but it's still there.
Posted by Susan Harkins | October 7, 2010, 7:12 AM PDT | Latest comment by shakurqazi
-
Highlight the minimum and maximum values for Excel subsets
Excel's MIN() and MAX() function work great, until you want to use them on a subset of data. Consider using this conditional formatting rule.
Posted by Susan Harkins | May 29, 2012, 8:00 AM PDT | Latest comment by DBlayney