Udemy Mastering Date and Time Functions and Formulas in Excel

Started by AD-TEAM, Oct 20, 2024, 01:34 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

AD-TEAM


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