Excel 2013: Master Date Time Calculations in 1 hour
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013: Master Date Time Calculations in 1 hour to your Wishlist.

Add to Wishlist

Excel 2013: Master Date Time Calculations in 1 hour

Learn all there is about Date and Time calculations in Excel in just under 1 hour.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Created by Adnan Ejaz
Last updated 2/2015
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand Date and Time Logic in Excel
  • Effectively use Excel's built-in DateTime Functions
  • Calculate Date Time Differences
  • Manipulate DateTime Values using the INT Function
  • Master the Date and Time Calculations in Excel
View Curriculum
Requirements
  • Students only need to have a very basic understanding of Excel
Description

Ever had trouble with Dates and Times in Excel? Ever subtracted dates or times and ended up with gibberish? Ever wanted to learn how to calculate Date and/or Time differences once and for all? Well then....this course is for you!

After this course you'll never need to consult any other help file or tutorial. I'll give you the Big Easy on Date Time calculations. Whether its Dates, Times or DateTime Values, you'll feel confident in using Excel's built-in functions to manipulate them. And where Excel does not have "good" functions to help you, I'll teach you tricks simple-yet-powerful to get your desired result.

I assure you, this is your one stop junction for acquiring Mastery in Date and Time data types in Excel 2013.

So let's head!

Who is the target audience?
  • Anybody who has ever had difficulties in understanding Date and Time values in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 5 Lectures Collapse All 5 Lectures 58:13
+
Date Time Basics
3 Lectures 35:45

Date Time: Understanding the Logic Behind
05:44

Date Time: Useful Functions
17:32
+
Calculating Date Time Differences
2 Lectures 22:28
How to Calculate Date Time Differences
18:00

Using Int Function to Calculate Differences
04:28
About the Instructor
Adnan Ejaz
4.5 Average rating
12 Reviews
318 Students
4 Courses
Telecommunications Engineer

I am a telecoms engineer with major in Software and Office Automation. I have a knack of teaching difficult subjects in the most intuitive manner, or so I've been told. I have ventured into some online training courses that I have prepared on subjects of common interest between students and professionals.

I am a Microsoft Office aficionado. Word, Excel, Powerpoint, Visio etc. are my forte. I have designed many macros in VBA for automation too.

I am both a developer and designer. I have programming experience for desktop as well as the web. Vb.net, asp.net, jquery, css and html have all been my companions through out my development years. Lately, I have developed some websites in wordpress/php as well. As a designer; Photoshop, InDesign, Fireworks, Flash etc. have been my tools of the trade.

I have a firm grasp of the English language and am adept in both the spoken and written formats. I have used various software and computing tools to make my online courses graphically rich and intuitive. I hope you'll benefit from them.