Problem with Excel template

Sandhya108k

Commendable
May 26, 2016
1
0
1,510
hi, I have tried many paid as well as free excel templates but i am really fed up with those template. I can't make more changes. Please suggest me any templates useful for payroll activities
 
Solution
Design your own custom template in Excel.

Payroll applications are all very much the same - mostly identical data entry and calcuations. Usually the end user interface is what varies to some degree or another.

That is free and you can certainly customize your own spreadsheet as is necessary. Excel has quite a few functions that may make it all the easier now.

And you might consider using a database instead. Access would be a good start and there may even be a template out there already. Or use an open source database package. Most will now link to or import/export data from Excel or other data formats.

For example:

http://www.instructables.com/id/Create-Ms-Access-Database-software-to-prepare-sala/

There are others...
Design your own custom template in Excel.

Payroll applications are all very much the same - mostly identical data entry and calcuations. Usually the end user interface is what varies to some degree or another.

That is free and you can certainly customize your own spreadsheet as is necessary. Excel has quite a few functions that may make it all the easier now.

And you might consider using a database instead. Access would be a good start and there may even be a template out there already. Or use an open source database package. Most will now link to or import/export data from Excel or other data formats.

For example:

http://www.instructables.com/id/Create-Ms-Access-Database-software-to-prepare-sala/

There are others....

Plus it is very easy, as the next step, to build reports, forms, menus, and buttons to automate your payroll functions.

 
Solution