How can I track meeting attendance?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably something simple, but I'm such a novice I don't know where
to start. I want to track my attendance at monthly meetings. I have five
defined (don't know if that's the right term) plus numerous miscellaneous
meetings I attend every month. I would like to be able to track them by date
and category and see a running total of each category for the year. I would
also like to be able to integrate new categories of meetings in as they come
along.

I don't know if this is enough info to help me get started or if this
question even makes sense, but thanks for your help!
 
Makes perfect sense.
Row 1 is your headings only (use Alt+Enter to enter a paragraph return if
your heading needs to be 2 lines).
You can use data validation to choose the meeting type in column A (select
A2 to A65536):
See:
http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm
Then, put Date in column B. (select the column and Format-->Cells and choose
a date format.)
Enter all your current meetings.
Use Autofilter when you only want to see a certain meeting type:
http://www.officearticles.com/excel/using_autofilter_in_microsoft_excel.htm
Use Subtotals to "count" the meetings by meeting type:
http://www.officearticles.com/excel/getting_subtotals_in_microsoft_excel.htm
That should give you a really good start. :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com
 
Thank you very much for the great information!

Anne Troy said:
Makes perfect sense.
Row 1 is your headings only (use Alt+Enter to enter a paragraph return if
your heading needs to be 2 lines).
You can use data validation to choose the meeting type in column A (select
A2 to A65536):
See:
http://www.officearticles.com/excel/drop-down_using_data_validation_in_microsoft_excel.htm
Then, put Date in column B. (select the column and Format-->Cells and choose
a date format.)
Enter all your current meetings.
Use Autofilter when you only want to see a certain meeting type:
http://www.officearticles.com/excel/using_autofilter_in_microsoft_excel.htm
Use Subtotals to "count" the meetings by meeting type:
http://www.officearticles.com/excel/getting_subtotals_in_microsoft_excel.htm
That should give you a really good start. :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com
Click to expand...
 
Back
Top