Problem with Excel template

Sandhya108k

Commendable
May 26, 2016
1
0
1,510
0
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
 

Ralston18

Splendid
Moderator
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.

 

Ralston18

Splendid
Moderator
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.

 
Thread starter Similar threads Forum Replies Date
B Apps General Discussion 0
paymanz Apps General Discussion 0
R Apps General Discussion 3
Scrob07 Apps General Discussion 0
F Apps General Discussion 5
J Apps General Discussion 0
P Apps General Discussion 4
I Apps General Discussion 3
kikani.kautik Apps General Discussion 2
synoptic12 Apps General Discussion 3
S Apps General Discussion 5
L Apps General Discussion 5
V Apps General Discussion 2
A Apps General Discussion 1
C Apps General Discussion 1
L Apps General Discussion 12
E Apps General Discussion 1
jbosari Apps General Discussion 0
Karlos123 Apps General Discussion 1
jnkweaver Apps General Discussion 5

ASK THE COMMUNITY