How to Make an Agenda in Excel

Written by colby stream
  • Share
  • Tweet
  • Share
  • Email

While Excel spreadsheets are predominately known for tracking money, they can also serve as a meeting agenda. Once formatted correctly, the agenda can include a title, tasks that need to take place during the meeting and a way to calculate how much time you have attributed to each task. Once you've created a template, you can use it to enter your agenda information quickly for every meeting.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Open a blank Microsoft Excel 2007 spreadsheet. Highlight the "1" cells from "A" through "E." Press the "Merge Cells" button on the tool bar. This looks like a square box with an lower-case "a" in it, with arrows pointing to the left and right away from the letter. Type "Meeting Agenda" in this new space. Center it, change the font and size according to your specifications.

  2. 2

    Type "Title" in the B2 column. Underneath it, type "Location:" and "Date:" in B2 and B3. Next to the "Title" and "Location" cells, highlight from the "C" column through the "D" column. Merge them so that both "Title" and "Location" each have a longer cell.

  3. 3

    Extend the "D" column at the top of the spreadsheet by clicking and holding on the divider between "D" and "E." Drag it to the right until it lines up with the divider between "G" and "H." This will make it longer. Highlight all the cells starting with A7 and dragging your cursor to E10. Right-click and select "Format." Enable the lines to appear around all the cells. Click in column A7 and type "Start." Type "End" in the next column over, "Time" in the next, "Item" in the next (the longer "D" column) and "Contact" in the last.

  4. 4

    Highlight all rows of time selections, from "Start" through "Time." This means selecting the "A," "B" and "C" columns under these categories. Click the "Home" tab and select the arrow next to "Number Format" in the "Number" group. Click "More Number Formats." Choose "Custom" from the "Category" list. Choose "h:mm" to give you the difference in hours and minutes between the times. Close the box.

  5. 5

    Type "=B8-A8" in the C8 cell and press enter. This will give you the difference between time in the two cells. Repeat this process for each cell in the "C" column, substituting the appropriate numbers next to the "B" and "A" as necessary. Click the Microsoft Office button in the upper left hand corner. Choose "Save." Save in a place where you will find it easily, title it "Template" and save it with a template extension. Enter your agenda into your new template. Be sure to "Save As" a new document so that you don't overwrite your template.

Tips and warnings

  • You can make your agenda bigger by adding more lines, extending as far down as you need.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.