Скачать или смотреть Excel: Ultimate HR Tracker for Sickness & Lateness

Say goodbye to employee attendance issues forever with the most efficient Excel HR Tracker you'll ever use! This is a Microsoft Excel tutorial covering, how to create a HR tracker, conditional formatting, Countif function and charts. The tutor starts off by explaining how the tracker works. Once the explanation is completed the tutor starts to recreate an example of the tracker. The days of the month are typed out with an area for the HR data to be entered below each day. The tutorial demonstrates four options for the tracker, late, sick, absent, and hols. Each element displays a different colour when entered. The second part of the video covers how to analyse the data using the CountIF function. The whole month is summarised and represented in a chart. Great tool for tracking sickness, lateness, absent days and holidays.
#hrtracker
#msexcel

Join this channel to get access to perks:
   / @itseasytraining1st  

Most popular video at the moment: Spill error

If you want to support me, check this out:   / itseasy  

Online training courses:

https://itseasytraining.teachable.com/
https://www.udemy.com/course/microsof...
Playlists for this channel:

Access:    • Unleash the POWER of SUBMACROS in Access!  

Excel:    • Link web based data into Microsoft Excel  

Word:    • How to use Microsoft Word's mail merge fea...  

Visio:    • How to create a basic network diagram in M...  

Project:    • How to use Baselines and custom reports in...  

PowerPoint:    • Zoom feature in Microsoft PowerPoint, New!...  

Publisher:    • How to set or create Business information ...  

OneNote:    • OneNote Overview, linking into Outlook tas...  

Office 365:    • Видео  

#itseasytraining

Classroom based courses can be arranged at https://www.itseasy.co.uk/

Courses are available through Microsoft Teams, Online and Face to face in the UK

Online courses at https://itseasytraining.teachable.com/

Udemy Courses https://www.udemy.com/user/stephen-sa...

Training Guide Books

Excel for New Managers
https://www.amazon.co.uk/Excel-New-Ma...

Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr...

Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi...

Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv