Excel allows you to work with all types of data, including dates and times. (This probably isn’t news to you, right?) Understanding all the ins and outs of working with dates and times 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, absolutely free. (This 286-page e-book is a $27.99 value, and it is yours free!) It is a 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 Beginning Word Macros Master Class course, you can choose to register either for the streaming version or for the streaming + video downloads version. Here’s what each version includes, along with the price:
| Streaming Version | Streaming + Video Downloads Version | |
|---|---|---|
| High-quality streaming video for all sessions (almost 3.5 hours of video content) | High-quality streaming video for all sessions (almost 3.5 hours of video content) | |
| Watch videos on multiple devices | Watch videos on multiple devices | |
| Closed-captions (streaming videos only) | Closed-captions (streaming videos only) | |
| Transcripts for each lesson | Transcripts for each lesson | |
| Pause, rewind, and replay videos as many times as you want | Pause, rewind, and replay videos as many times as you want | |
| Watch, work, discover, and learn at your own pace | Watch, work, discover, and learn at your own pace | |
| Online tracking of completed sessions | Online tracking of completed sessions | |
| ExcelTips: Times and Dates (286-page e-book) | ExcelTips: Times and Dates (286-page e-book) | |
| 12 months of access to all course materials online | 12 months of access to all course materials online | |
| Lifetime access to course materials downloaded during your 12-month registration period | Lifetime access to course materials downloaded during your 12-month registration period | |
| Downloadable course video files in 720p high-def format (available 31 days after registration) | ||
| Downloadable course video files in 1080p high-def format (available 31 days after registration) | ||
| Lifetime access to videos downloaded during your 12-month registration period | ||
| Video files sent to you on USB 3.0 drive (upon request, after 31 days) | ||
| Unlimited 24/7 access during your 12-month registration period (as long as you have an internet connection) | 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 during your 12-month registration period | Personalized help in learning dates and times during your 12-month registration period | |
| Certificate of completion suitable for framing mailed to you (upon request) | Certificate of completion suitable for framing mailed to you (upon request) | |
| 100% money-back guarantee during the 30 days following registration | 100% money-back guarantee during the 30 days following registration | |
| Price: $119 (One Time Fee) |
Price: $199 (One Time Fee) |
I’ve structured my 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 registration fee for the courses is a fraction of what in-person events can cost. (I should know—I’ve attended and taught my fair share of such events!)
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 using the order form below. (Be sure to specify the version of class for which you would like to register.)
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 using the form shown just a bit earlier on this page.
Do you have other questions about the Using Dates and Times course? E-mail me (allen@usingoffice.com) and I’ll get you helped out as quickly as I can.
