Skillshareallen

Excel Formulas & Functions Part 7: Date & Time Functions

Master Excel date & time formulas! Learn powerful functions to manage dates and times in your spreadsheets. Part of an Excel formulas series.

4.3(6)
518students
48m
Certificate
Chris Dutton
Chris DuttonFounder, Excel Maven

Course Content

Excel Formulas & Functions Part 7: Date & Time Functions is an all-levels Skillshare course taught by Chris Dutton. It runs 48m, is taught in English, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 6 reviews, with 518 students enrolled. It is a paid course, first published May 2017.

Unlock the Power of Time in Excel: Date & Time Formulas

This course is part of a comprehensive 9-part series on Excel Formulas & Functions, taking you from fundamental to advanced levels. Master date and time functions to unlock the full potential of your Excel spreadsheets for time series data and chronological calculations.

In this section, you'll delve into:

  • Real-time Functions: Understand and utilize volatile functions like TODAY and NOW for dynamic data.
  • Data Categorization: Learn how to aggregate data effectively over various time periods using powerful categorization tools.
  • Scheduling & Duration: Explore advanced scheduling functions including EOMONTH, YEARFRAC, NETWORKDAYS, and DATEDIF for precise date calculations.

About the Excel Formulas & Functions Series:

Transform your Excel skills from basic spreadsheet proficiency to a powerful data analytics tool with this in-depth series. We cover 75+ Excel formulas and functions, providing hands-on, contextual demos and practice exercises. This isn't just about memorizing syntax; it's about learning to think like Excel and build practical solutions.

You'll gain the ability to:

  • Build Dynamic Dashboards: Create interactive tools and dashboards to filter, display, and analyze your data effectively.
  • Combine Data from Multiple Sources: Effortlessly join datasets using the versatile LOOKUP, INDEX, and MATCH functions.
  • Integrate Real-time Data: Pull data directly from APIs into Excel using WEBSERVICE & FILTERXML.
  • Manipulate Data with Ease: Master the manipulation of dates, times, text, and arrays.
  • Automate Analytics: Automate tedious and time-consuming analytical tasks – no VBA required!

If you're seeking the ultimate resource to become an Excel expert and master advanced formulas and functions, this is the series for you! Elevate your data analysis capabilities and become an Excel rock star.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(437)
3h 15m
all
skillshare
5.0(302)
38m
intermediate
skillshare
5.0(92)
1h 2m
beginner
skillshare
5.0(28)
2h 31m
beginner
skillshare
skillshare