Working With Date And Time Functions: Intermediate Excel

     

Working With Date And Time Functions: Intermediate Excel
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Learn Excel’s Date and Time Functions to Calculate, Format, and Analyze Time-Based Data Efficiently.

What you’ll learn

Apply custom date formats for clear and professional presentations.

Calculate date differences and accurately determine ages.

Use WORKDAY and WORKDAY.INTL functions to calculate workdays.

Leverage NETWORKDAYS and NETWORKDAYS.INTL to calculate business days.

Apply EDATE and EOMONTH to manipulate dates for scheduling and reporting.

Requirements

Basic computer skills.

Familiarity with entering and editing data in cells.

Comfortable working with numbers, including fractions and decimals.
Access to Microsoft Excel.

Description

Overview

Section 1: Dates and Time

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Files

Lecture 4 DOWNLOAD ME: Exercise Files

Lecture 5 Understanding How Dates are Stored in Excel

Lecture 6 Applying Custom Date Formats

Lecture 7 Using Date and Time Functions

Lecture 8 Using the WORKDAY and WORKDAY.INT Functions

Lecture 9 Using the NETWORKDAYS and NETWORKDAYS.INT Function

Lecture 10 Tabulate Date Differences with the DATEDIF Function

Lecture 11 Calculate Dates with EDATE and EOMONTH

Lecture 12 Exercise

Lecture 13 Course Close