Building Templates for Various Use Cases of Spreadsheet

Hey,

Work of finance professionals like us always revolves about numbers. Each and every task we do has in all probability numbers and data included in it.

Spreadsheets and data processors form an integral part of our work routine. In the process we also find that we are doing various tasks on spreadsheets on repetitive basis. 

I am planning to create various spreadsheet templates with the formulas ingrained in it, to make our work easier and reduce time and efforts involved.

I would like to crowdsource ideas for spreadsheet use cases and would be happy to know the most effortful tasks you do on excel. I would be happy to create templates for the same and share it with you all.

 

Thanks,

Darshan Dudhoria 

 

Replies (3)
Quick Summary
Finance professionals often perform repetitive tasks in spreadsheets. To save time and effort, the discussion proposes creating pre-built spreadsheet templates with ingrained formulas. Ideas are being crowdsourced for common, effortful tasks, with a specific example of copying invoice details into Excel without manual typing.

How to copy invoice details (date, invoice number,HSN code, vendor name amount etc) into Excel without typing

@ Golla Prathyusha 

From where do you want to copy these details? Is it from the invoicing system. If yes, which invoicing system is used? 

I enter manually from invoice to excel

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register