- Subscribe to this page:
- RSS
- Email Alert
susan harkins
(1359 results)
About Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
-
Blog Post
Change multiple Outlook contacts at the same time
October 9, 2012 11:14am PDT
Don't spend time changing multiple Outlook contacts one at a time, Change just one contact in a group and update the entire group.
3 Latest comment by hirussellsmith
-
Blog Post
Make Word's Quick Style gallery work for you
October 1, 2012 11:08am PDT
Susan Harkins shows you how to move quick styles that you use regularly in Word to the head of the list.
8 Latest comment by jaykulsh@...
-
Blog Post
A quick trick for hiding duplicate Excel values
September 25, 2012 8:47am PDT
Duplicate values aren't wrong, but you might not want to display them. Use this simple technique to hide duplicate values in Excel.
12 Latest comment by ssharkins@...
-
Blog Post
Use AutoText to save multiple return addresses
September 20, 2012 1:12pm PDT
If you work with multiple return addresses, you don't have to enter those addresses manually as you use them; use Word's AutoText feature instead.
5 Latest comment by Murfski-19971052791951115876031193613182
-
Downloads
10 tips for summarizing Excel data: Demo files
September 17, 2012 12:00am PDT
These sample Excel workbooks (xls and xlsx versions) illustrate the summarizing techniques described in this 10 Things blog post.
Provided by: Susan Harkins
-
-
Blog Post
Three ways to display text in the margin of a Word document
September 11, 2012 8:34am PDT
Use these simple methods to display text and graphics in the left or right margin of a Word document.
3 Latest comment by ssharkins@...
-
Blog Post
A simple Excel conditional format technique that highlights input cells
September 4, 2012 10:26am PDT
Use this simple conditional format technique for Excel to solicit input values from users.
8 Latest comment by ssharkins@...
-
Blog Post
Use Consolidate to summarize Excel data without sorting
August 29, 2012 11:47am PDT
There are a number of ways to summarize Excel data, but Consolidate is one of the easiest to implement and the results are easy to use.
-
Blog Post
Use PowerPoint 2010 dynamic transitions to visually link data
August 21, 2012 8:50am PDT
Use PowerPoint 2010's new dynamic transitions to pan from one slide to another, and back again.
8 Latest comment by Johncoltrane
-
Blog Post
Three tips for rounding Excel time values
August 16, 2012 8:48am PDT
Summing Excel date and time values is easy; rounding requires a bit of function help.
20 Latest comment by johnmcdermott@...
-
Blog Post
How to populate a dependent dropdown list in Word
August 8, 2012 1:29pm PDT
Use VBA code to populate a dependent form field in Microsoft Word. Susan Harkins show us how.
11 Latest comment by raicsl@...
-
Blog Post
Two ways to find a conditional average in Excel
July 30, 2012 8:35am PDT
There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions.
3 Latest comment by ssharkins@...
-
Blog Post
Use Word's Go To feature to browse common elements
July 26, 2012 7:46am PDT
Word's Go To feature has two modes of navigation. You can use it to access an element once, or you can browse common elements, one by one.
-
Blog Post
Display the total number of emails in an Outlook folder
July 25, 2012 9:57am PDT
To the right of each mail folder, Outlook displays the number of unread messages. With a few clicks, you can change that number to the number of total messages in the folder instead.
4 Latest comment by ssharkins@...
-
Blog Post
A quick way to return the latest date in a subset in Excel
July 24, 2012 8:26am PDT
Identifying the latest entry for a subset doesn't have to be difficult - use a pivot table.
5 Latest comment by ssharkins@...
-
Blog Post
Grant yourself access to Word's horizontal and vertical rulers
July 20, 2012 11:22am PDT
Word's ruler is a bit unpredictable - now you see it, now you don't. Learn how to control its seemingly unruly behavior.
3 Latest comment by Fiona33
-
Blog Post
Modify a style at the template level
July 19, 2012 11:13am PDT
You can modify a style on two levels: for the current document only or for all new documents based on the underlying template. Make sure you make the right choice.
-
Blog Post
Sum only negative values in a given range using SUMIF()
July 17, 2012 8:10am PDT
Summing only the positive or negative values in the same range of values only sounds difficult. Fortunately, the SUMIF() function can handle both.
2 Latest comment by wehmeier
-
Blog Post
A quick way to create a list of sequential numbers in Word
July 12, 2012 7:43am PDT
Creating a list of sequential numbers isn't as difficult as it might sound at first. If you can create a table, you can create a list of sequential numbers.
13 Latest comment by ssharkins@...
-
Blog Post
Two useful Word shortcuts for quickly deleting text
July 11, 2012 9:02am PDT
Editing text is tedious work. Use these two shortcuts to delete whole words instead of single characters.
10 Latest comment by stapleb
