When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel Formulas & Functions Part 7: Date & Time Functions
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
Free
This Course Includes
skillshare
0 (0 reviews )
48 minutes 
english
Online - Self Paced
course
SkillShare
About Excel Formulas & Functions Part 7: Date & Time Functions
Introduction to Date & Time Functions
DATEVALUE: Your New BFF
Date Formatting & Fill Series
TODAY()/NOW()
YEAR/MONTH/DAY & HOUR/MINUTE/SECOND
The EOMONTH Function
The YEARFRAC Function
WEEKDAY, WORKDAY & NETWORKDAYS
The DATEDIF Function
PROJECT SHOWCASE: Designing a Sample Budget Pacing Tool
HOMEWORK: Date & Time Functions
What You Will Learn?
- This course is part 7 of a 9-part series on Excel Formulas & Functions: from basic to advanced..
- Date & time functions are powerful tools that allow Excel to process time series data and chronological calculations. This section will cover real-time volatile functions like TODAY and NOW, introduce categorization tools to aggregate data over different time periods, and explore powerful scheduling tools like EOMONTH, YEARFRAC, NETWORKDAY and DATEDIF..
- About the Excel Formulas & Functions Series:.
- In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel..
- You'll learn how to write complex, powerful functions from scratch, allowing you to:.
- If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!.