• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Create an agenda-building ‘cheat sheet’

by on
in Excel Training,Meeting Management,Office Management,Office Technology

The monthly department meeting is next week, and you've already heard from four people who want to appear on the agenda. You expect a few more to chime in.

It's your job to create an agenda that affords adequate time for each item, as well as to make sure the meeting runs smoothly and ends on time.

Your best approach? Annette Marquis, co-owner of TRIAD Consulting, recommends building an adjustable meeting-agenda template in Excel.
Why reinvent the wheel? Any time you stare at a blank page and ask yourself, "Now how did I do that last time?" you've missed an opportunity to use Microsoft Office's greatest tools: templates. Learn how to make templates that work for you time and again with ...
Microsoft Office Templates and Forms: Repeating Success in MS Word & Excel

This simple worksheet automatically manages start and end times, she says. When you add a speaker at the last minute, time allotments for other items adjust automatically.

Here's how to build one:

  • Create your title and headings (location, date, etc.) for the top of your template.

Enter column headings, beginning with "Start," "End" and "Time" (or "Length"). You might also wish to add columns titled "Item" and "Presenter."

  • Select the Start, End and Time cells in the worksheet's first row.
  • Click Cells on the Format menu.
  • Click Time in the Category list on the Number tab.
  • Click 1:30 p.m. in the Time list, and click OK, so the cells will display time entries.
  • Click the first cell in the End column and enter this formula: =IF(ISBLANK(C8),"",A8+C8). This formula will calculate end times for each agenda item, based on how long each item will take.
  • Click the cell in the second row of the Start column, and enter this formula: =IF(ISBLANK(B8),"",B8)
  • Copy (or fill) the formula in cell B8 to cell B9.

Before adding formulas to subsequent rows, test the work sheet. Enter a start time in the first cell under "Start." Then, enter a time value under "Time."

Example: If the meeting start time is 2 p.m., and the first agenda item will take 20 minutes, enter 2:00 p.m. and 0:20. You should see 2:20 p.m. appear in the "End" cell of the first row and in the "Start" cell of the second row.

book coverNo matter which version of Office you use, you'll find success with templates and forms — and you'll repeat that success every time.

Stop wasting your time retyping, copying and pasting, or struggling to collect data. Microsoft Office Templates and Forms will have you creating data sets as easily as you save a file.

Get more time-saving templates that you can put to use immediately!

Get your copy today!

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/13984/create-an-agenda-building-cheat-sheet "

{ 4 comments… read them below or add one }

Delia September 28, 2012 at 3:43 pm

Format cells to “Custom” “[h]:mm” instead of “Time” “2:30 PM”.
Assuming your column headers are on row 1, change all instances of “A8″, “B8″, and “C8″ to “A2″, “B2″, and “C2″ respectively. The formula will then work.

Reply

Robin January 30, 2012 at 2:13 pm

I agree it doesnt work!0

Reply

Keith Hamm January 30, 2012 at 12:18 pm

I couldn’t get it to work either.0

Reply

Leisa January 30, 2012 at 11:43 am

This formula does not work!0

Reply

Leave a Comment