Spreadsheets are a part of life for just about everyone who works in Payroll, and this site is here to make your lives easier. Excel For Payroll is packed full of useful tips and tricks to help your Payroll Department get the most out of Excel!

Benford’s Testing In Excel Written on November 25, 2010, by Charlie.

In this video, I walk you through Benford’s Testing in Excel

Here’s the file I used in the demo video,and it has the expected frequencies in it, so you can just copy and paste them – Benford’s testing example file

If you’d like to find out more about Benford’s testing, here are some excellent articles:

Benford’s Law @ WIKIPEDIA.ORG

Benford’s Law @ NIGRINI.ORG

Benfords @ TOPCAATS.COM

For more great Payroll Audit Tests, fill in your name and email in the form on the right, and I’ll email you my free report containing 22 tests with step by step instructions.

Read more from the payroll audit test category. If you would like to leave a comment, click here: Comment. or stay up to date with this post via RSS, or you can Trackback from your site.
Social Bookmark : Technorati, Digg, de.licio.us, Yahoo, Blinkbits, Blogmarks, Google, Magnolia.

Expense claims when employees not working Written on November 22, 2010, by Charlie.

In this video I walk you through using VLOOKUP to identify instances where employees are not at work (vacation/sick), but are claiming expenses for those dates:

Read more from the payroll audit test category. If you would like to leave a comment, click here: Comment. or stay up to date with this post via RSS, or you can Trackback from your site.
Social Bookmark : Technorati, Digg, de.licio.us, Yahoo, Blinkbits, Blogmarks, Google, Magnolia.

© Copyright WWW.REINVENTDATA.COM