Summing a table in MS Word

by jonathan on January 28, 2010

Its obvious in retrospect, but for years I have always manually added up figures in columns I was working on in Microsoft Word (e.g. a payment schedule in a contract).

This week I was getting sick of recalculating figures every time I made a change, and googled the problem.

Word Tips has just what I needed: Summing a Table Column .

  1. Click the table cell you want the formula in
  2. Click the Layout tab on the ribbon.
  3. Click the Formula tab in the Data group. Word displays the Formula dialog box.
  4. Insert your formula , default is “=SUM(ABOVE)” which sums all the cells above.
  5. Click on OK.
If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter

{ 0 comments }

Happy 2010

by jonathan on December 31, 2009

Dear readers,

I just wanted to to wish you a very happy and prosperous new year.

Kind regards,

Jonathan

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter

{ 0 comments }

Design Thinking

December 13, 2009

I am currently crunching through Steve Litt’s brilliant series of books on Troubleshooting. I am hugely into general problem solving frameworks and his Universal Troubleshooting Process (UTP) is one of my favourites.
Today, whilst clearing my backlog on Instapaper I came across this Wired.com piece on legendary design firm IDEO. They use a simply process [...]

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter
Read the full article →

Featherbedding

October 28, 2009

“Featherbedding is a pejorative term for the practice of hiring more workers than are needed to perform a given job, or to adopt work procedures which appear pointless, complex and time-consuming merely to employ additional workers. The term “make-work” is sometimes used as a synonym for featherbedding.
The term “featherbedding” is usually used by management to [...]

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter
Read the full article →

Rave Review for Change By Design

September 28, 2009

Bob Sutton notes a rave review of EDEO CEO Tim Brown’s new book “Change by Design: How Design Thinking Transforms Organizations and Inspires Innovation“. Bob writes:
The review, called “Redefining a Profession,” concludes that Tim has successfully avoided one of the biggest risks in a book like this one – coming across as too much of [...]

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter
Read the full article →

50 more ways to improve your business

September 27, 2009

Master consultant and all round business genius Gerald Wienberg has sorted the best of Jerry Weinberg’s (no relation) “50 things to improve business”:
2. back up everything
4. Rule: do nothing, revised with 3 caveats: a) don’t do it if there’s someone that can do it better; b) don’t do it if there’s someone that can do [...]

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter
Read the full article →

When Murphy comes calling

July 10, 2009

There is a good article in Projects@Work about what to do when a risk you chose not to mitigate materialises, and how to handle it.
From Projects@Work – A Guy Named Murphy:
Widely accepted risk management theory says that doing nothing is an appropriate response to some risks. But what happens on a project when you’ve [...]

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter
Read the full article →

What you really do with OODA loops

June 30, 2009

These are some selections and notes from a brilliant essay by Dr Chester W Richards about OODA loops and the general application of military know how to business. From “What you really do with OODA loops” :
The key to the military notion of time lies in how practitioners of the art of war view strategy. [...]

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter
Read the full article →

Elliot Jaques and Requisite Organisation

June 15, 2009

From the Economist’s Guru section article on Elliott Jaques:
Jaques (1917-2003) decided that jobs could be defined in terms of their time horizon. For example, a director of marketing might be worried about marketing campaigns for next year, while a salesman on the road is worried about reaching his targets for the week. Jaques also believed [...]

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter
Read the full article →

Some great book combinations

June 12, 2009

Here are a few books that compliment each other wonderfully:
“Getting Things Done” and “Getting It Done”

“McMafia” and “Illicit”

“Nudge” and “Influencer” and “Yes”

If you like it, share it…:

If you like it, share it...:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • FriendFeed
  • LinkedIn
  • MySpace
  • StumbleUpon
  • Technorati
  • Twitter
Read the full article →