Excel allows you to work with all types of data, including times and dates. (This probably isn’t news to you, right?) Understanding all the ins and outs of working with times and dates in Excel can be confusing, however. You can remove the confusion, if you just have the right information.
That’s where my Using Dates and Times course can help. It shows you exactly how Excel implements dates and times and how you can work with them most effectively. Consisting of almost three-and-a-half hours of focused, informative videos, Using Dates and Times leads you step by step to a better understanding of how best to work with times and dates in Excel. In 35 individual lessons you gain mastery of this basic and essential area of using the program and developing your own worksheets and formulas. The course allows you to learn at your own pace, exactly the way you want.
What the Course Covers
The Using Dates and Times course is packed with great information designed to help you develop the understanding necessary to working with both dates and times in Excel. The course is divided into sections, each covering a major topic area. Each section is further divided into a series of lessons crafted to help you expand your understanding.
There is a tremendous amount of information in this course, designed to take you from the level of an absolute beginner, completely unfamiliar with dates and times in the Excel world, all the way to an advanced level. The course is designed to help you progress and succeed at your own pace.
Here’s a quick rundown of the sections in the course:
- Section 100: Course Introduction (3 lessons)
- Section 101: Date and Time Basics (7 lessons)
- Section 102: Working with Date and Time Functions (5 lessons)
- Section 103: Calculating with Dates (6 lessons)
- Section 104: Calculating with Times (4 lessons)
- Section 105: Converting Dates and Times (4 lessons)
- Section 106: Formatting Dates and Times (4 lessons)
- Section 107: Wrapping Up (2 lessons)
That’s a grand total of 35 lessons. (As I said—packed with information!) If you want an even more detailed outline of the course, you can download it by clicking or right-clicking on this link. The detailed outline shows the title of each section, title of each lesson, and the length for each lesson.
Supplement and Extend Your Course
To make this course even more valuable, when you register for the Using Dates and Times course, you also receive your own copy of the 9th edition of my ExcelTips: Times and Dates e-book. This is a 286-page treasure trove of tips, tricks, and instruction on how you can use times and dates in your worksheets. This is a great resource that supplements what you discover in the course and can help you extend your skills.
At 286 pages, I can’t provide a full outline on this page, but if you would like to see what is contained in ExcelTips: Times and Dates, 9th Edition, you can download the Introduction to the e-book by clicking or right-clicking on this link. It contains a complete table of contents for this valuable resource.
A Sample Lesson
To give you a taste for how I present information in the course, I want to share one of the lessons with you. Below is the video for lesson 101-1, “How Excel Stores Dates and Times” (Hint: You may want to maximize the video so it fills your screen. I find this helpful when viewing lessons.)
I hope that gives you an idea of how I conduct my courses—I try to be clear, concise, and complete when discussing any particular topic. Note that for this particular lesson, the supplemental materials include a full transcript. In fact, each lesson in the course includes a full transcript, and supplemental materials are available on each lesson’s page once you register for the course.
What Your Course Registration Includes
If you decide to sign up for the Using Dates and Times course, here’s what registration as a class member gives you:
|All the videos in the course (there is a video for each of the 35 lessons in the course—almost 3-1/2 hours of video instruction!)|
|The ability to watch videos on multiple devices|
|A transcript for each lesson|
|Closed-captioning subtitles available for each streaming video|
|The ability to pause, rewind, and replay the videos as many times as you want|
|The ability to watch, work, discover, and learn at your own pace during the registration period, without any artificial deadlines|
|The ability to mark each lesson as completed, online, so you can easily track your progress in the course|
|Your own copy of ExcelTips: Times and Dates, 9th Edition, a 286-page e-book to help supplement and extend what you discover in the course|
|12 months of full access all online course materials, including videos and supplemental materials|
|Unlimited 24/7 access, as long as you have an Internet connection|
|Support from me (Allen Wyatt) as you learn to work with dates and times in your own work|
|A certificate of completion (mailed to you) available at the end of the course, upon request|
|100% 30-day money-back guarantee (You get plenty of time to try out the course)|
I’ve structured Using Dates and Times course so that it is easy to develop the skills you need. Plus, I’ve done my best to pack the course with features and benefits that make it an absolutely awesome value.
The Price for this Awesome Value?
The registration fee for the course depends on whether you want the course in streaming format, or if you want the ability to download the video files in addition to streaming. Both options provide the exact same content; I just know that some people like to have the video files on their own computers. Here’s what each course option provides:
|Course||Course + Downloads|
|Almost 3.5 hours of streaming video in 35 lessons|
|Ability to watch videos on multiple devices|
|Downloadable course video files in 720p high-def format (see notes, below)|
|Downloadable course video files in 1080p high-def format (see notes, below)|
|Video files sent to you on USB drive (upon request; see notes, below)|
|Closed-captions (streaming video only)|
|Transcript for each lesson|
|Pause, rewind, and replay videos as many times as you want|
|Watch, work, discover, and learn at your own pace|
|Self-controlled online tracking of lessons you’ve completed|
|ExcelTips: Times and Dates, 9th Edition (286-page e-book)|
|12 months of access to all course materials online|
|Lifetime access to course materials downloaded during your 12-month registration period|
|Unlimited 24/7 access during your 12-month registration period (as long as you have an Internet connection)|
|Personalized help in learning dates and times|
|Certificate of completion suitable for framing (upon request)|
|100% money-back guarantee during the 30 days following registration|
|Using Dates and Times Registration Fee||Only $119||Only $199|
Important Note: Those who choose to register for the Course+Downloads option receive, 31 days after signing up, access to a download page that provides the video files (without closed-captioning) in two formats: 720p high-def and 1080p high-def. High-quality video files are HUGE, so I also provide the opportunity for Course+Downloads registrants to have the video files sent to them in both formats on a USB 3.0 flash drive at no additional cost, upon request. Access to the video files and requests for the USB drive are available 31 days after registering because the first 30 days constitute the “kick-the-tires” period where any registrant can ask for a refund of the course registration fee.
I’d love you to take advantage of my Using Dates and Times course; you can secure your place in the course by clicking the button that represents the version of the course you need:
Still Can’t Decide?
If you are still on the fence about participating, consider a few things:
- The full outline for the course is fantastic. I provided a quick overview of the outline, above, but you can check out the full outline by clicking or right-clicking on this link.
- I’ve actively tried to provide more support materials to class participants than other online courses.
- I make myself available to course participants, through this website and via e-mail, after the course starts. (In other words, you won’t be left on your own as you work through the course—I’ll be there to help you.)
I’ve spent an immense amount of time and resources to put together the Using Dates and Times course. In the course I show you, in a hands-on way, that knowing more about dates and times can benefit you as you develop and work with your own data in Excel. And, I do it in an approachable, achievable way. If you decide to register for the course, I want you to acquire real skills you can use regularly. It will take work on your part, but I’m there to help you out as you master and apply the concepts I present.
I’m confident you won’t be disappointed in the course but, even so, there is no risk on your part. As I mentioned earlier, the Using Dates and Times course is covered by a 100% 30-day money-back guarantee, the same as all my other products. If you don’t like what you see or it’s not working out for you, just e-mail me and request the refund. My only requirement is that you do it within 30 days from when you register for the course. (That gives you plenty of time to “kick the tires” and try everything out.)
Are you ready to expand your knowledge about dates and times in Excel? I’m ready to help you gain the skills you need. All you need to do is register by clicking the button below:
Do you have other questions about the Using Dates and Times course? E-mail me (firstname.lastname@example.org) and I’ll get you helped out as quickly as I can.