Training >> Browse Articles >> Applications


10 Excel Secrets Every Admin Should Know

AdminSecret and Richard Rinyai

2. Creating Call Logs

I used to track calls for one of my past employers, when I used to work at a securities firm as an Investment Advisor Assistant. The way I would do it is that I would create a Microsoft Excel spreadsheet for the month. I say month, since I would create a sheet for each week, having the “from” and “to” dates in the sheet name.

Then I would create worksheets within each sheet with headings such as:

  • Name

  • Time of Call

  • Reason for Call

If you work for more than one manager or you need to track calls for more than one person, you might want to create a heading that states something like “Person Receiving Call” or something along the lines of this.

Remember to create a filename for each year, so you can keep yourself organized. Also, remember to archive these files, just in case you need to go back and check who called when for what reason. You can purge the files as needed, depending on your company’s situation and/or policy.

AdminSecret School Finder

Save time in your search for a degree program. Use AdminSecret's School Finder to locate schools online and in your area.

* In the event that we cannot find a program from one of our partner schools that matches your specific area of interest, we may show schools with similar or unrelated programs.

Recent Activity

romanico received the quiz result of "21-50% correct: Good effort", about 2 years ago.
tmiller received the quiz result of "Satisfactory", about 2 years ago.
new2admin gave a thumbs down to The Article "6 Ways Finding a Dream Job Is Like Finding Your Soul Mate", about 2 years ago.
kinsh1987 received the quiz result of "Legal Secretary ", about 2 years ago.
LoraJ commented on: "Lora Coats", about 2 years ago.