- 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
A few ways to customize Excel to increase your productivity
April 25, 2012 9:05am PDT
Working with Excel's out-of-the-box defaults can waste your time. Change default settings to work more productively and efficiently.
13 Latest comment by sawriters@...
-
Blog Post
How to find the latest (or earliest) date and a corresponding value
April 24, 2012 7:25am PDT
Use this combination of Excel functions to find the latest date and return a corresponding value.
2 Latest comment by DBlayney
-
Blog Post
Two ways to build dynamic charts in Excel
April 19, 2012 11:48am PDT
Users will appreciate a chart that updates right before their eyes. In Excel 2007 and 2010 it's as easy as creating a table. In earlier versions, you'll need the formula method.
13 Latest comment by chip_long@...
-
Blog Post
Office challenge: Can you avoid re-entering integer values that are supposed to be percentages?
April 18, 2012 10:32am PDT
In this week's challenge, test your Excel skills by helping a user avoid re-entering integers that should be formatted as percentages.
3 Latest comment by v_balaj@...
-
Blog Post
Adjust settings to print index cards using Word
April 18, 2012 10:27am PDT
Word can quickly adjust to printing index cards. Simply choose the right document size and format as needed.
4 Latest comment by ssharkins@...
-
-
Blog Post
Troubleshoot page and section breaks in Microsoft Word
April 17, 2012 11:57am PDT
Word's page and section breaks often confound users. They often enter them when they don't mean to, creating structural problems that the user doesn't know how to eliminate.
1
-
Blog Post
Add a pie chart to a Word document without opening Excel
April 13, 2012 10:47am PDT
You can bypass Excel and insert a pie chart into a Word document, from inside Word. Susan Harkins explains.
3 Latest comment by dhays
-
Blog Post
Insert a shortcut that will quickly end your PowerPoint presentation
April 13, 2012 10:41am PDT
If rushed for time, you can use this technique to quickly end a presentation, without looking like you've shortchanged the audience.
9 Latest comment by ssharkins@...
-
Blog Post
Office solution: Why Excel sometimes displays dates instead of values
April 11, 2012 1:43pm PDT
This week, learn the possible solutions to last week's challenge: Why is Excel displaying a date instead of a numeric value?
1
-
Downloads
10 cool conditional formatting techniques: Excel demo files
April 11, 2012 12:00am PDT
These sample Excel workbooks (xls and xlsx versions) illustrate the creative conditional formatting techniques described in this 10 Things blog post.
Provided by: Susan Harkins
-
Blog Post
Avoid this potential gotcha when using add-ins to distribute Excel macros
April 10, 2012 10:51am PDT
Learn how to easily avoid this gotcha when distributing Excel macros via an add-in.
2 Latest comment by ssharkins@...
-
Blog Post
A quick and dirty way to compare columns of Excel data
April 6, 2012 11:41am PDT
Using this little-known feature in Excel, you can quickly compare one column of data to another.
25 Latest comment by HAL 9000
-
Blog Post
Office challenge: Why is Excel displaying a date instead of a numeric value?
April 5, 2012 8:31am PDT
This week, test your Excel skills by solving this common but peculiar and annoying formatting snafu.
16 Latest comment by Marshwiggle
-
Blog Post
Accommodate different headers and footers in a Word document
April 3, 2012 12:36pm PDT
To change a document's header or footer in a Word document, you should add a section break first.
-
Blog Post
How to pull a paragraph in Word into the left margin
April 2, 2012 11:38am PDT
It's easier than you might think to pull text into the left margin. Doing so is as simple as setting a format option, but in an unusual way.
2 Latest comment by jonc2011
-
Blog Post
Office solution: When a looping introduction refuses to stop
March 29, 2012 8:29am PDT
This week, learn the possible solutions to last week's challenge: When you can't get a looping introduction to stop.
4 Latest comment by Centennial00
-
Blog Post
Set PowerPoint's default view to a setting that suits you
March 29, 2012 8:19am PDT
Reset PowerPoint's default view setting to one that matches your work habits and current needs.
-
Blog Post
How to repeat pivot table headings when printing Excel documents
March 28, 2012 11:03am PDT
A pivot table that spans more than one printed page will be confusing without its column headings. Use this tip to print column headings on every sheet.
3 Latest comment by jensqox@...
-
Blog Post
Count the number of Excel records that fall between two dates
March 26, 2012 8:38am PDT
Using Excel's COUNTIFS() function, you can quickly count records that fall between two dates.
11 Latest comment by N / A
-
Blog Post
Office solution: When a presentation doesn't play a music file
March 23, 2012 7:53am PDT
This week, learn the possible solutions to last week's challenge: Why doesn't my presentation play music?
