susan harkins

Blog Post

Highlight Excel list values when they change

February 4, 2013 11:04am PST

If your Excel lists repeats values and you need help finding changes, try this easy conditional format.

23 Latest comment by ssharkins@...

Blog Post

Add frequently used tables to Word's Quick Tables gallery

January 28, 2013 11:00am PST

Reduce repetitive tasks and add frequently used tables to Word's Quick Tables gallery for quick retrieval.

Blog Post

Display multiple subtotaling functions in Excel

January 21, 2013 12:05am PST

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

2 Latest comment by sparent

Blog Post

Two dynamic chart enhancements using Excel

January 14, 2013 8:23am PST

These two Excel chart enhancements are easy to implement and will improve readability.

2 Latest comment by ssharkins@...

Blog Post

Four things I learned from readers in 2012

January 7, 2013 11:40am PST

Susan Sales Harkins shares a few Microsoft Office tricks she learned from TechRepublic readers during 2012.

1

Blog Post

Create an Excel data table to compare multiple results

December 28, 2012 12:57am PST

Suppose you want to view multiple possibilities within an Excel calculation. The answer is to create a data table.

4 Latest comment by tufte@...

Blog Post

Two easy ways to customize the ribbon interface

December 26, 2012 12:28am PST

If the ribbon doesn't provide easy access to the options you use the most, put them on the QAT or add a new group to the ribbon.

12 Latest comment by flhenry

Blog Post

The ten most popular Office tips of 2012

December 20, 2012 12:20pm PST

Susan Harkins lists ten of 2012's most popular Office tips published in the Windows and Office Blog, and the now inactive Office Blog.

12 Latest comment by skbinok

Blog Post

Use a keyboard shortcut to quickly apply any Word style

December 20, 2012 7:40am PST

Bypass Word's busy Styles gallery by using this easy-to-implement keyboard trick to apply styles.

7 Latest comment by toadforce

Downloads

10 steps to creating a Word userform for addressing letters: Demo files

December 12, 2012 12:00am PST

These sample Word templates (dot and dotm versions) illustrate the addressing technique described in this 10 Things blog post.

Provided by: Susan Harkins

Blog Post

Use Excel's AutoSum to sum non-contiguous values

December 11, 2012 8:42am PST

You know how to use AutoSum to add contiguous ranges, but you can also use it with non-contiguous ranges.

13 Latest comment by ssharkins@...

Blog Post

Three tips for making Outlook's To-Do bar work for you

December 4, 2012 8:40am PST

If you're tempted to hide Outlook's new To-Do bar, stop! Customize it and put it to work for you.

11 Latest comment by ian@...

Blog Post

An easy technique for creating a floating column chart in Excel

November 27, 2012 11:23am PST

This quick Excel technique turns an otherwise complicated charting requirement into a simple task.

11 Latest comment by gobrannan@...

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