Master Excel Date & Time Formulas: 2024 Pro Edition
Focused View
6:05:12
1 - Course Overview.mp4
02:57
2 - Dates-and-Time-Course-resources.zip
2 - Resources.html
3 - Introduction.mp4
07:30
4 - Entering Dates in Different Formats in Excel.mp4
09:26
5 - Entering Times in Different Formats in Excel.mp4
07:52
6 - Entering Dates and Times Together in Excel.mp4
05:48
7 - How to identify if Dates are Entered as Text.mp4
10:32
8 - Learn How to Add and Subtract Dates in Excel.mp4
14:12
9 - Learn How to Add and Subtract Times in Excel.mp4
08:37
10 - Formatting Dates Time in Excel Part 1 Introduction.mp4
08:09
11 - Formatting Dates Time in Excel Part 2 Custom Date Formatting.mp4
09:54
12 - Formatting Dates Time in Excel Part 3 Custom Time Formatting.mp4
10:58
13 - Mastering the DATEVALUE Function in Excel.mp4
08:51
14 - How to Construct a Date and perform calculation Using the DATE Function in Excel.mp4
07:54
15 - Mastering the NOW Function in Excel.mp4
02:07
16 - Mastering the TODAY Function in Excel.mp4
05:28
17 - Extracting the Day of the Month from a Date with DAY Function in Excel.mp4
03:15
18 - Extracting the Month from a Date Using the MONTH Function in Excel.mp4
03:09
19 - Extracting the Year from a Date Using the YEAR Function in Excel.mp4
03:08
20 - Extracting DateTime Elements in Excel Using INT and MOD Functions.mp4
08:27
21 - How to Use TIMEVALUE to Convert Text to Time in Excel.mp4
06:49
22 - How to Use the TIME Function to Construct Time Values in Excel.mp4
12:08
23 - How to Use the HOUR Function to Get the Hour from a Time in Excel.mp4
06:06
24 - How to Use the MINUTE Function to Get the Minute from a Time in Excel.mp4
04:08
25 - How to Use the SECOND Function to Get the Second from a Time in Excel.mp4
03:17
26 - Date Time Shortcuts.mp4
04:24
27 - How to Use the WEEKDAY Function to Identify Weekdays in Excel.mp4
10:44
28 - How to Use EOMONTH to Find the Last and First Day of a Month in Excel.mp4
10:28
29 - How to Use EDATE to Find Dates by Adding or Subtracting Months.mp4
08:46
30 - How to Use the DAYS Function to Find Date Differences in Excel.mp4
13:10
31 - How to Use the WORKDAY Function for Business Day Calculations in Excel.mp4
10:44
32 - How to Use WORKDAYINTL to calculate Workdays with Custom Weekends and Holidays.mp4
18:58
33 - NETWORKDAYS Calculate Workdays Between Dates Excluding Weekends and Holidays.mp4
11:05
34 - NETWORKDAYSINTL Calculate Workdays with Custom Weekends and Holidays.mp4
20:09
35 - How to calculate Date Differences with YEARFRAC Function in Excel.mp4
15:55
36 - How to calculate Date Differences with YEARFRAC Function in Excel.mp4
15:55
37 - How to Use DATEDIF Legacy Function to Find Date Differences in Years Months.mp4
25:22
38 - Project Calculate Age and Upcoming Birthday with Excel Date Functions.mp4
18:43
39 - How to convert Month Text to Month Number in Excel.mp4
07:12
40 - Conclusion.mp4
02:55
More details
Course Overview
Unlock the full potential of Excel's date and time functions with this comprehensive training. From basic formatting to advanced business calculations, gain the skills to automate reports, analyze time-based data, and boost your productivity.
What You'll Learn
- Master 20+ essential date/time functions (TODAY, NETWORKDAYS, YEARFRAC, etc.)
- Perform complex business day calculations and dynamic reporting
- Convert between formats and solve real-world scheduling problems
Who This Is For
- Project managers tracking timelines and deadlines
- Financial analysts working with time-sensitive data
- HR professionals managing payroll and schedules
Key Benefits
- Automate time-sensitive reports that update dynamically
- Master business-day calculations with custom weekends/holidays
- Solve complex scheduling problems with advanced formulas
Curriculum Highlights
- Date/Time Fundamentals & Formatting
- Advanced Functions (WORKDAY, NETWORKDAYS, DATEDIF)
- Real-World Applications & Dynamic Reporting
Focused display
Category
- language english
- Training sessions 39
- duration 6:05:12
- Release Date 2025/05/10
