3.3 GB | 00:25:22 | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English

Files Included :
1 - Course Overview (18.82 MB)
2 - Dates-and-Time-Course-resources (745.32 KB)
3 - Introduction (60.15 MB)
4 - Entering Dates in Different Formats in Excel (74.12 MB)
5 - Entering Times in Different Formats in Excel (56.41 MB)
6 - Entering Dates and Times Together in Excel (55.52 MB)
7 - How to identify if Dates are Entered as Text (77.92 MB)
8 - Learn How to Add and Subtract Dates in Excel (160.61 MB)
9 - Learn How to Add and Subtract Times in Excel (116.28 MB)
10 - Formatting Dates Time in Excel Part 1 Introduction (87.53 MB)
11 - Formatting Dates Time in Excel Part 2 Custom Date Formatting (86.69 MB)
12 - Formatting Dates Time in Excel Part 3 Custom Time Formatting (135 MB)
13 - Mastering the DATEVALUE Function in Excel (59.26 MB)
14 - How to Construct a Date and perform calculation Using the DATE Function in Excel (77.75 MB)
15 - Mastering the NOW Function in Excel (11.88 MB)
16 - Mastering the TODAY Function in Excel (36.2 MB)
17 - Extracting the Day of the Month from a Date with DAY Function in Excel (15.74 MB)
18 - Extracting the Month from a Date Using the MONTH Function in Excel (18.47 MB)
19 - Extracting the Year from a Date Using the YEAR Function in Excel (15.36 MB)
20 - Extracting DateTime Elements in Excel Using INT and MOD Functions (62.33 MB)
21 - How to Use TIMEVALUE to Convert Text to Time in Excel (44.02 MB)
22 - How to Use the TIME Function to Construct Time Values in Excel (84.55 MB)
23 - How to Use the HOUR Function to Get the Hour from a Time in Excel (38.08 MB)
24 - How to Use the MINUTE Function to Get the Minute from a Time in Excel (25.21 MB)
25 - How to Use the SECOND Function to Get the Second from a Time in Excel (16.99 MB)
26 - Date Time Shortcuts (23.06 MB)
27 - How to Use the WEEKDAY Function to Identify Weekdays in Excel (84.51 MB)
28 - How to Use EOMONTH to Find the Last and First Day of a Month in Excel (76.72 MB)
29 - How to Use EDATE to Find Dates by Adding or Subtracting Months (60.3 MB)
30 - How to Use the DAYS Function to Find Date Differences in Excel (95.44 MB)
31 - How to Use the WORKDAY Function for Business Day Calculations in Excel (84.47 MB)
32 - How to Use WORKDAYINTL to calculate Workdays with Custom Weekends and Holidays (247.24 MB)
33 - NETWORKDAYS Calculate Workdays Between Dates Excluding Weekends and Holidays (118.45 MB)
34 - NETWORKDAYSINTL Calculate Workdays with Custom Weekends and Holidays (272.11 MB)
35 - How to calculate Date Differences with YEARFRAC Function in Excel (180.45 MB)
36 - How to calculate Date Differences with YEARFRAC Function in Excel (180.44 MB)
37 - How to Use DATEDIF Legacy Function to Find Date Differences in Years Months (307.66 MB)
38 - Project Calculate Age and Upcoming Birthday with Excel Date Functions (109.73 MB)
39 - How to convert Month Text to Month Number in Excel (57.52 MB)
40 - Conclusion (41.3 MB)