Microsoft Excel: Master Date and Time Functions and Formulas

سرفصل های دوره

Excel Date and Time Mastery: Boost Productivity with Advanced Functions for Data Analysis and Real-World Applications

1 - Setting the Stage for Excel Dates and Times Functions Mastery

1 - Course Overview

2 - Dates-and-Time-Course-resources.zip

2 - Resources.html

2 - Foundations of Dates and Times in Excel

3 - Introduction

4 - Entering Dates in Different Formats in Excel

5 - Entering Times in Different Formats in Excel

6 - Entering Dates and Times Together in Excel

7 - How to identify if Dates are Entered as Text

8 - Learn How to Add and Subtract Dates in Excel

9 - Learn How to Add and Subtract Times in Excel

3 - Formatting Dates and Times

10 - Formatting Dates Time in Excel Part 1 Introduction

11 - Formatting Dates Time in Excel Part 2 Custom Date Formatting

12 - Formatting Dates Time in Excel Part 3 Custom Time Formatting

4 - Basic Date and Time Functions

13 - Mastering the DATEVALUE Function in Excel

14 - How to Construct a Date and perform calculation Using the DATE Function in Excel

15 - Mastering the NOW Function in Excel

16 - Mastering the TODAY Function in Excel

17 - Extracting the Day of the Month from a Date with DAY Function in Excel

18 - Extracting the Month from a Date Using the MONTH Function in Excel

19 - Extracting the Year from a Date Using the YEAR Function in Excel

20 - Extracting DateTime Elements in Excel Using INT and MOD Functions

5 - Advanced Time Functions

21 - How to Use TIMEVALUE to Convert Text to Time in Excel

22 - How to Use the TIME Function to Construct Time Values in Excel

23 - How to Use the HOUR Function to Get the Hour from a Time in Excel

24 - How to Use the MINUTE Function to Get the Minute from a Time in Excel

25 - How to Use the SECOND Function to Get the Second from a Time in Excel

26 - Date Time Shortcuts

6 - Advanced Date Functions

27 - How to Use the WEEKDAY Function to Identify Weekdays in Excel

28 - How to Use EOMONTH to Find the Last and First Day of a Month in Excel

29 - How to Use EDATE to Find Dates by Adding or Subtracting Months

7 - Workday and Date Difference Calculations

30 - How to Use the DAYS Function to Find Date Differences in Excel

31 - How to Use the WORKDAY Function for Business Day Calculations in Excel

32 - How to Use WORKDAYINTL to calculate Workdays with Custom Weekends and Holidays

33 - NETWORKDAYS Calculate Workdays Between Dates Excluding Weekends and Holidays

34 - NETWORKDAYSINTL Calculate Workdays with Custom Weekends and Holidays

35 - How to calculate Date Differences with YEARFRAC Function in Excel

8 - Advanced Date and Time Calculations

36 - How to calculate Date Differences with YEARFRAC Function in Excel

37 - How to Use DATEDIF Legacy Function to Find Date Differences in Years Months

38 - Project Calculate Age and Upcoming Birthday with Excel Date Functions

39 - How to convert Month Text to Month Number in Excel

9 - Course Review and Whats Next

40 - Conclusion

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy