susan harkins

Blog Post

Three easy ways to use color in an Excel worksheet

March 11, 2013 10:44am PDT

These simple color tips for Excel can help you add a bit of color to designate purpose or task.

6 Latest comment by marj@...

Blog Post

Three ways to guide users through an Excel input range

March 7, 2013 8:20am PST

Susan Harkins describes three ways to ease the data input process in Excel.

3 Latest comment by Marshwiggle

Blog Post

How to find duplicates in Excel

March 5, 2013 10:56am PST

You'll need more than one trick up your sleeve to find duplicates in Excel.

8 Latest comment by thanhonap

Blog Post

Excel's Auto Outline quickly hides data details to simplify viewing

February 28, 2013 7:49am PST

Excel's Auto Outline feature quickly hides detail noise so you can view just a summary of your data.

Blog Post

An easy way to manage Word's list of styles

February 19, 2013 12:09pm PST

By default, Word's list of styles is much larger than you need. You can easily reduce it to display just the styles you're using.

11 Latest comment by bd1235

Blog Post

View web pages inside Outlook

February 11, 2013 1:20pm PST

View some web pages from inside Outlook's Mail window by adding a new folder to your configuration.

8 Latest comment by ssharkins@...

Downloads

10 steps to creating a custom list for sorting in Excel: Demo files

February 6, 2013 12:00am PST

These sample Excel workbooks (xls and xlsx versions) illustrate the custom sorting technique described in this 10 Things blog post.

Provided by: 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@...