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

setting up annual leave

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

ResolvedVersion 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)

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 31 Jul 2025: Automatically marked as resolved.

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.