Office Management Utility Tool

Home Forums Excel Utility Office Management Utility Tool

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #100237
    Surajit@1992
    Participant

    1. A utility tool that will enable me to make Diary/Docket digitally on daily basis, like “E OFFICE”in which I can fill the necessary fields and saving the information it will appear in a Different data sheet , with a search bar where saved data will be shown as “DOCKETED”. I tried to make one in Excel, I am sharing the snap of that one.
    2. If possible a automated Memo Register by which I can provide Memo No. Filling the mandatory fields like, Memo No., Date, To whom it is given, subject, File No etc.
    3. A stock register and dead stock register where all the usefull and unused items will be put by opening and closing balance along whit automaed calculation if any item is given or added to any staff.
    4. Service Book register, by which we can update all the service book related matters of employees, like confirmation, service verification, MCAS etc.
    5. Cash book and subsidiary cash book ( G.O related allotment, its uses, opening balance, fefund, closing balance etc.)in which we can entry all the data as we put in manhal cash book with automated calculation.

    Attachments:
    #100239
    wbxpress
    Keymaster

    As per my understanding you need 5 different types of excel utility having different functionalities.

    I would suggest the following for each case:-

    1. Create a Google Form to collect necessary data from user input and save the data submitted through google form in a Google sheet. From the Google sheet you can sort, find etc. from the database.

    2. Create a Google sheet with an auto increment column for Memo No.

    3. This is also can easily achieved using google sheet.

    4. Create google sheet with necessary columns e.g. employee name, DOB, DOJ, Designation, Scale of Pay, Increment, Nominations, leave etc.

    5. Google sheet here also can be used to maintain cash book register.

    I personally use google sheet to save lot of information so that i can easily access it through various devices online.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.