Microsoft Excel: Master Date and Time Functions and Formulas

Focused View

6:05:12

0 View

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

1 - Course Overview.mp4

02:57

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

2 - Resources.html

2 - Foundations of Dates and Times in Excel

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

3 - Formatting Dates and Times

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

4 - Basic Date and Time Functions

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

5 - Advanced Time Functions

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

6 - Advanced Date Functions

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

7 - Workday and Date Difference Calculations

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

8 - Advanced Date and Time Calculations

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

9 - Course Review and Whats Next

40 - Conclusion.mp4

02:55

Description

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

What You'll Learn?

Enter and format dates and times in various styles and regional formats
Use essential date and time functions like TODAY, NOW, DATE, and DATEVALUE with confidence
Extract specific components from dates (day, month, year) using specialized functions
Perform complex date calculations, including finding the difference between dates and calculating workdays
Format dates and times using both pre-set and custom formatting options
Convert between text and date/time values seamlessly
Use advanced functions like YEARFRAC, WORKDAY, NETWORKDAYS, etc. for business day calculations
Create dynamic reports and dashboards that automatically update based on the current date
Apply date and time functions to solve real-world business problems and improve data analysis

Who is this for?

Professionals who work with date-based data in Excel (e.g., project managers, financial analysts, HR professionals)

Excel users who want to improve their efficiency in handling date and time calculations

Students or job seekers looking to enhance their Excel skills for better career prospects

Small business owners and entrepreneurs who use Excel for scheduling and planning

Anyone who wants to master date and time functions in Excel, from beginners to intermediate users

What You Need to Know?

Basic knowledge of Excel (ability to navigate the interface, enter data, and use simple formulas)

Access to Microsoft Excel (any version from 2010 onwards)

A willingness to learn and practice with the provided exercise files

Basic understanding of general date and time concepts (e.g., knowing what a month or year is)

More details

Description
Master Excel Date and Time Functions: Boost Your Data Analysis Skills
Unlock the power of Microsoft Excel for advanced date and time management! This comprehensive course is perfect for beginners and intermediate users ready to supercharge their Excel proficiency in data analysis and project management.

What You'll Master in This Excel Date and Time Course:
Excel Date Formatting Mastery: Transform raw data into professional, customized date formats.
Critical Excel Date Functions: Harness the power of TODAY, NOW, DATE, DATEVALUE, WORKDAY, NETWORKDAYS, DATEDIF, and YEARFRAC.
Advanced Excel Date Calculations: Perform complex date arithmetic and workday analysis with ease.
Project Timeline Optimization: Track progress and calculate workdays precisely for better project management.
Automated Age Calculation: Instantly compute ages from birthdates for time-sensitive analysis.
Interactive Excel Dashboards: Build dynamic, date-driven reports for data-backed decision making.

Course Highlights: Excel Time Management Simplified
In-Depth Excel Date Training: Cover everything from basics to advanced features like WORKDAY.INTL and NETWORKDAYS.
Real-World Applications: Tackle actual business scenarios using Excel's date and time capabilities.
Efficiency Boosting Techniques: Learn time-saving Excel formulas and automation strategies.
Practical Excel Projects: Solve authentic business problems to sharpen your Excel analytics skills.
Troubleshooting Expertise: Master solutions for common date and time challenges in Excel.

Key Takeaways: Your Path to Excel Date and Time Mastery
After completing this course, you'll confidently:
Automate complex date-based calculations in Excel
Generate self-updating reports using dynamic functions
Uncover insights from time-series data analysis
Streamline project timelines and deadline management
Who Will Benefit from This Excel Date Functions Course?
Business professionals aiming to enhance their Excel toolkit
Data analysts seeking advanced date and time manipulation skills
Excel enthusiasts eager to explore advanced functions
Professionals looking to boost productivity with Excel time management
Project managers requiring better timeline tracking tools

Prerequisites: Basic Excel familiarity. No advanced knowledge needed.
Why Choose This Course?
Comprehensive curriculum covering all essential Excel date and time functions
Step-by-step tutorials with real-world examples
Hands-on projects to reinforce learning
Time-saving tips and tricks from an Excel expert
Lifetime access to course updates and resources
Elevate your Excel skills today! Enroll now and transform the way you work with dates and times in Excel.
Who this course is for:
Professionals who work with date-based data in Excel (e.g., project managers, financial analysts, HR professionals)
Excel users who want to improve their efficiency in handling date and time calculations
Students or job seekers looking to enhance their Excel skills for better career prospects
Small business owners and entrepreneurs who use Excel for scheduling and planning
Anyone who wants to master date and time functions in Excel, from beginners to intermediate users

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Formulas and Functions

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.