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
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.
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.
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.
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.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for