- Subscribe to this page:
- RSS
- Email Alert
susan harkins
(1365 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
Using Excel's Text To Columns feature to clean up foreign data
November 20, 2012 7:24am PST
Work smart when cleaning up foreign data. Text To Columns can divide data and get rid of delimiters.
11 Latest comment by ssharkins@...
-
Blog Post
Create space with two helpful spacing options in Word
November 13, 2012 8:46am PST
When spacing matters, use these two options to reduce and expand Word text inside a document.
7 Latest comment by ace203jh
-
Blog Post
Track your time better by automatically color coding your Outlook appointments
November 7, 2012 8:17am PST
Using the conditional format feature, you can configure Outlook to color code an appointment automatically.
9 Latest comment by Standss
-
Blog Post
Add autofilter to Excel and filter data by selection
October 30, 2012 8:23am PDT
Cut filtering tasks by more than half by adding the AutoFilter option to the ribbon or toolbar.
15 Latest comment by ssharkins@...
-
Blog Post
Put Word's recent documents list to work for you
October 19, 2012 1:45pm PDT
Use Word's Recent Documents list to quickly open the files you use most often.
9 Latest comment by Full Tao-er
-
-
Blog Post
Display chapter numbers as page number components in a Word document
October 16, 2012 8:38am PDT
Displaying a page number is easy. Displaying the chapter number and the page number is just as easy - if you use Word styles.
3 Latest comment by ssharkins@...
-
Downloads
10 steps to creating a scrolling Excel chart: Demo files
October 16, 2012 12:00am PDT
These sample Excel workbooks (xls and xlsx versions) illustrate the scroll bar technique described in this 10 Things blog post.
Provided by: Susan Harkins
-
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.

































