Save Rs 588 on a 2-Year Ad-Free CAclubindia Pro Membership. Subscribe Now!

Building Templates for Various Use Cases of Spreadsheet

519 views

Save Share

Join Us Follow Us Add as Source

Darshan Dudhoria

Chartered Accountant

23 Points Posted on 31 March 2021

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.