setting up annual leave

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Setting up an annual leave spread sheet

Setting up an annual leave spread sheet

· Urgent Priority · Version 365

Jacqui has attended:
Excel Introduction course

Setting up an annual leave spread sheet

I would like info on this, as I need to create a new spread sheet for the new financial year for 8 colleagues. I have one which was set up previously for last year, but I believe I need to start the new one from scratch

RE: setting up an annual leave spread sheet

Hi Jacqui,

Thankyou for your question to the forum.

To make a start with doing annual leave deductions, here is a link on how to do these calculations based on deducting annual leave on an hourly or daily basis:

https://buddypunch.com/blog/calculate-vacation-hourly-employees/

Hope this helps. Please let me know if you need any more support giving more details around what exactly you need to calculate as regards annual leave entitlement

Kind regards
Martin Sutherland
(IT Trainer)


 

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips


Server loaded in 0.08 secs.

✓ w3speedster