Create an agenda-building ‘cheat sheet’ — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily
  • LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Create an agenda-building ‘cheat sheet’

Get PDF file

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!

{ 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.


Robin January 30, 2012 at 2:13 pm

I agree it doesnt work!0


Keith Hamm January 30, 2012 at 12:18 pm

I couldn’t get it to work either.0


Leisa January 30, 2012 at 11:43 am

This formula does not work!0


Leave a Comment

Previous post:

Next post: