About This Class

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!