Excel DATE & TIME Functions for HR Data Analysis | #excel for #hranalytics
Key Takeaways
Teaches Excel DATE and TIME functions for HR data analysis
Original Description
In this video tutorial, I covered some of the powerful Excel functions specifically designed for HR data analysis. 📌Download the FREE Video Resources here - https://segunakiode.com/excelhranalytics
#hranalytics #analytics #hranalytics #excel
⏰Timestamps
00:00 - Introduction
00:25 - Excel DATE & TIME Function
01:18 - Excel TODAY Function
04:35 - Excel NOW Function
05:34 - Excel YEAR Function
07:15 - Find EMPLOYEE AGE Using Excel YEAR Function
08:18 - Find LENGTH OF SERVICE Using Excel YEAR Function
09:37 - Excel NETWORKDAYS Function
12:03 - Find EMPLOYEE AGE Using Excel DATEDIF Function
📌Do you need someone to talk to as regards your career aspirations? You can book a FREE 30-mins Career Clarity Session with Segun Akiode with this link: https://segunakiode.com/clarity-call/
📲 Remember to subscribe to my channel @segunakiode for more videos.
🎀You may be interested in the other parts of the Excel Functions for HR Data Analysis series:
📌 Excel DATE & TIME Functions for HR Data Analysis - https://youtu.be/123lEtqKLrA
📌 Excel DATE & TIME Functions for HR Data Analysis - https://youtu.be/Yob5QrAcuGk
📌 Excel AGGREGATE Functions for HR Data Analysis - https://youtu.be/rQS62MLY08U
★☆★ CONNECT WITH ME ON SOCIAL MEDIA ★☆★
🐦Twitter: - @segunakiode - https://twitter.com/segunakiode
📸 Instagram: - @segunakiode - https://instagram.com/segunakiode
🎙️ Podcast: https://anchor.fm/segunakiode
🌍 Website: https://segunakiode.com
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
More on: Excel & Spreadsheets
View skill →Related Reads
📰
📰
📰
📰
Tracking Macroeconomic Indicators with the Finance Toolkit
Dev.to · Jeroen Bouma
Pydantic for Data Engineering: Schema Validation in ETL & Pipeline Contracts
Dev.to · Gowtham Potureddi
Half of Data Engineering Jobs on LinkedIn Aren't Real
Dev.to · DataDriven
Evolutionary Data Through Schemaboi: Achieving Forward, Backwards, and Sideways Compatibility
InfoQ AI/ML
Chapters (9)
Introduction
0:25
Excel DATE & TIME Function
1:18
Excel TODAY Function
4:35
Excel NOW Function
5:34
Excel YEAR Function
7:15
Find EMPLOYEE AGE Using Excel YEAR Function
8:18
Find LENGTH OF SERVICE Using Excel YEAR Function
9:37
Excel NETWORKDAYS Function
12:03
Find EMPLOYEE AGE Using Excel DATEDIF Function
🎓
Tutor Explanation
DeepCamp AI