DATE FUNCTIONS FOR DATA ANALYSIS AND MODELLING
Course Curriculum
Available in
days
days
after you enroll
Available in
days
days
after you enroll
- SHORTCUTS - UNDERSTANDING HOW DATE AND TIME WORKS (9:39)
- CUSTOM FORMATS USING TEXT (8:33)
- CONSTRUCT AND DECONSTRUCT A DATE - DAY, MONTH, YEAR (6:07)
- DIFFERENCE BETWEEN DATES - NETWORKDAYS (3:49)
- CALCULATE EXPIRY DATES AND BALANCE - EOMONTH AND EDATE (10:08)
- GOAL SETTING - WORKDAY (2:27)
- HIGHLIGHT WEEKENDS (2:24)
Available in
days
days
after you enroll
- REPLACE POSITION OF DAY AND MONTH (1:24)
- FIND WEEKENDS (1:36)
- ADDING UP HOURS (1:36)
- FIND DATES IN RANGE (7:49)
- FIND END OF QUARTER (9:34)
- FIND RETIREMENT (6:24)
- FIND DIFFERENCE IN MONTHS (3:29)
- FIX INCORRECT DATE (3:56)
- DIFFERENCE IN DAYS, MONTHS AND YEARS (11:03)
- CONVERT DATE INTO STRING (1:53)
- CREATE LIST OF DATES (5:31)
- CREATE LIST OF DATES WITH SINGLE FUNCTION (4:52)
- SCHEDULE (4:15)
- DATE PICKER ADD-IN (2:45)
Available in
days
days
after you enroll
Please purchase from:
https://www.havishmconsulting.com/shop
Login details will be shared immediately once payment is received.