susan harkins

Blog Post

Highlight the minimum and maximum values for Excel subsets

May 29, 2012 8:00am PDT

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.

9 Latest comment by pradeepbhat92

Blog Post

Display the slideshow name on all your PowerPoint slides

May 24, 2012 6:50am PDT

Use this simple VBA macro to display your presentation's name on all your PowerPoint slides.

4 Latest comment by pptcrafter

Blog Post

Office solution: Clearing up that wacky date problem when copying sheets

May 23, 2012 10:27am PDT

This week, learn the solution to the last Office challenge: Why does Excel change dates when I copy a sheet to a new workbook?

Blog Post

A quick Word trick for typing text into a scanned document

May 22, 2012 8:07am PDT

This quick trick will have you up filling in scanned paper forms in less than two minutes.

44 Latest comment by psauve

Blog Post

Use COUNTIFS() to evaluate multiple count and criteria ranges

May 21, 2012 10:37am PDT

Excel's COUNTIFS() function is flexible enough to handle different ranges and data types.

4 Latest comment by jbenton@...

Blog Post

Use Word macros to save your place in a document

May 17, 2012 8:19am PDT

Use these two simple Word macros to temporarily bookmark a spot you want to return to later.

25 Latest comment by uri1090

Blog Post

Challenge solution: How to set all workbooks to R1C1 referencing

May 16, 2012 10:46am PDT

This week, learn the solution to the recent challenge: Can you help a user who wants all workbooks to default to R1C1 referencing?

Downloads

10 essential items for your presentation kit

May 16, 2012 12:00am PDT

This simple checklist will help you pack all the items you need for a glitch-free presentation.This download is also available as an entry in our 10 Things blog.

Provided by: Susan Harkins

Blog Post

Implement a search offset in an Access form

May 15, 2012 8:14am PDT

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.

Blog Post

Use COUNTIFS() to compare two data sets in Excel

May 14, 2012 7:59am PDT

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.

Blog Post

A quick way to select an Excel data range

May 10, 2012 11:19am PDT

Here's a quick method, and the equivalent keyboard shortcut, for selecting an entire data range.

5 Latest comment by ssharkins@...

Blog Post

Office challenge: Why does Excel change dates when I copy a sheet to a new workbook?

May 9, 2012 7:37am PDT

This week, test your Excel skills by identifying and remedying this troublesome date behavior.

12 Latest comment by dogknees

Blog Post

Select multiple objects in a PowerPoint slide

May 8, 2012 8:51am PDT

Select multiple objects so you can move, format, and even delete related objects at the same time.

Blog Post

Tutorial: How to create and correctly employ Word tabs

May 7, 2012 7:56am PDT

Learning how to use tabs correctly is the best way to ensure that columnar data stays where you put it.

11 Latest comment by ssharkins@...

Blog Post

Reduce start up tasks by customizing the way Excel launches

May 3, 2012 10:44am PDT

Reduce tedious and repetitive start up chores by customizing the way Excel launches.

6 Latest comment by ssharkins@...

Blog Post

Office challenge: Can you help a user who wants all workbooks to default to R1C1 referencing?

May 2, 2012 7:35am PDT

This week, text your Excel skills by providing a permanent solution for a user's R1C1 referencing preference.

8 Latest comment by hkammann

Blog Post

Create easy access to the subscript and superscript font effects

May 1, 2012 7:27am PDT

Users have two efficient methods for applying superscript and subscript fonts. They can use a keyboard shortcut or add the effect to the Quick Access toolbar.

2 Latest comment by Deadly Ernest

Blog Post

Change Word's default table properties to suit the way you work

April 27, 2012 10:45am PDT

By default, Word inserts a table with borders. If that's not your preference, change these default settings.

5 Latest comment by ssharkins@...

Blog Post

Office solution: How to get percentages from integer values

April 26, 2012 8:17am PDT

This week, learn the simple solution to last week's challenge: Can you avoid re-entering integer values that are supposed to be percentages.

1

Blog Post

A clever trick for filtering odd and even rows in Excel

April 26, 2012 8:12am PDT

If you want to see only odd or even rows in an Excel worksheet, use this quick filtering trick.

11 Latest comment by sanjyn