Master Excel Dates and Times - Excel 365 and Excel 2019
Learn Excel dates & times quickly! Master date & time formulas in Excel 365, 2019 & 2016. Perfect for data analysis & organization.
Course Content
Master Excel Dates and Times - Excel 365 and Excel 2019 is an intermediate-level Udemy course taught by Tom Meservy. It runs 1h 12m, is taught in English, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 23 reviews, with 606 students enrolled. It is a paid course, last updated October 2021.
Unlock the Power of Excel Dates and Times: A Comprehensive Course
Are you struggling with date and time calculations in Excel? Do your Excel dates and times appear incorrect? This course is designed to help you master Excel dates and times and gain control over your data! In just over an hour, you'll learn essential techniques to effectively work with dates and times in Excel.
Here's what you'll discover:
- Understanding Excel Date and Time Storage: Learn how Excel stores dates and times as serial numbers – a fundamental concept for accurate calculations.
- Date and Time Formatting: Master various methods for formatting dates and times to suit your specific needs and reporting requirements.
- Effective Date Functions: Explore and utilize powerful Excel date functions for a wide range of calculations.
- Time Functions Mastery: Learn to manipulate and analyze time components within your Excel spreadsheets.
- Calculating Recurring Dates: Discover how to calculate recurring dates, including holidays and other scheduled events.
- Date Difference Calculations: Accurately calculate the difference between dates, including options to exclude weekends or count only workdays.
- Displaying Current Date and Time: Learn multiple ways to display the current date and time in your spreadsheets.
- Handling Time Over 24 Hours: Understand how to sum times that exceed 24 hours for accurate total duration calculations.
- Hands-on Learning: Follow along with numerous concise examples and practical worksheets to illustrate key concepts.
- Reinforce Your Skills: Apply your newfound knowledge with practice problems using different datasets to ensure complete mastery.
This course is perfect for anyone looking to improve their Excel skills and become more efficient with date and time management. Taught by experienced instructors who have guided thousands of students, this course will empower you to advance your career. Enroll today and take the first step towards becoming an Excel date and time expert!
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.