Print

Training >> Browse Articles >> Applications

+50

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

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