Struggling with Managing 300 Files in Excel? Seeking Advice for Admin Tasks

pujasoniac10
Can anybody please help me maintain files? Is there a format in Excel that helps with file management? I work in the admin department and need to maintain about 300 files.

Thanks and Regards,
Puja Soni
shwe11
Hi,

As such, there is no particular format for this.

I belong to India's biggest retail company. Initially, I have done this for my department:

1. To make a list of file names on Excel and number them accordingly.
2. You can add up the contents of the file in the same Excel sheet.
3. Place them in the cupboard according to the numbers marked on it.
4. On the inner side of the cupboard, you may paste an index sheet stating that file numbers 1 to 20 are in shelf 1.
5. Mark your cupboards with the numbering.
6. After placing all the files, just keep monitoring any new insertions and place them accordingly.

Dear, it is just a one-time task, and then it would be easy for you and your team even in your absence. Try to make the list clear.

You may categorize files into different heads such as Payments, Assets, Employee Database, clearance forms, corporate connections, traveling expenses, etc.

I am attaching the format for you as we did.

Thanks,
Shweta Jaitly
1 Attachment(s) [Login To View]

Ashish Mathur
Hi,

If it is an MS Excel problem, then please post it [here](http://www.merawindows.com/Forums/tabid/324/forumid/90/scope/threads/Default.aspx)
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute