Master Excel Dates and Times - Excel 2016 (Udemy.com)

Master Microsoft Excel dates and times in an afternoon! Excel 2016, Excel 2013, and Excel 2010 dates and times.

( 8 Reviews )

Created by: Tom Meservy

Produced in 2016

What you will learn

Manipulate Excel dates and times like a master
Perform complex calculations with Excel dates and times

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 96 / 100

Course Description

Have you done date and time calculations in Excel but keep running into weird problems? Do the dates and times in your Excel spreadsheets look off? Do you need to calculate date and time values in Excel but just aren't getting results?
Do you want to master Excel dates and times? This course is for you!

Master Excel Dates and Times in this Comprehensive Course
In just over an hour you will learn to effectively use Excel dates and times including:

Knowing how Excel dates and times are stored as serial numbers
How to format dates and times
Appropriately formatting dates and times
Effective use of date functions
Effective use of time functions
Calculating recurring dates like holidays
Calculating differences between dates including only counting workdays
Displaying current date and time in a variety of ways
Summing times that exceed 24 hours
and more!

Learn Excel Dates and Times by Doing
Throughout the course, you can follow along with the numerous concise examples that illustrate the nuances of Excel dates and times using the included worksheets. Further, practice problems are provided to allow you to apply these same concepts to another data set so that you can know that you have mastered the concepts.

We are professional instructors who have helped thousands of students Master Excel Dates and Times and become even more effective at work. We invite you to join us on a short journey to advance your career. Enroll today!Who this course is for:

Intermediate users of Excel who want to be able to effectively use dates and times

Time: 1h

Instructor Details

Tom Meservy

4.8 Rating
8 Reviews

I'm a professor of Information Systems. I enjoy extracting business value out of technology. Over the years I have been a software developer, database administrator, systems administrator, systems analyst, and more. I've done training/consulting with Fortune 100 companies and the DOD. I'm the founder of Tech Mountain Consulting that provides world-class training, software development, and consulting. I love the outdoors. I've roasted marshmallows over a volcano!

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

More courses by Tom Meservy

Master Excel Pivot Tables - Excel 2016 (2016)
4.5 (405 Reviews)

- Provider: Udemy
- Time: 1.5h

$11.99

Master Microsoft PowerShell (2016)
4.4 (305 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

All courses by Tom Meservy

Reviews

4.8

8 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Senna Mohan

Nice content, which everyone needs but do not know.

By Veronica Turnage

Learned a lot from this course! Thanks!!

By David P

This course was a great way to quickly ramp up on Excel dates and times. The instructor explains things well. It's a short course, but I learned a lot. There are some good exercises that help reinforce the points learned. It will help me use the Excel dates and times better.

By Michael o Lenenkokuai