Companies Home Search Profile

Excel Date & Time Functions & Formatting in 30 Minutes

Focused View

Excel Classes

27:22

16 View
  • 1 Introduction.mp4
    01:06
  • 2 The Fundamentals of Dates & Times in Excel.mp4
    02:41
  • 3 How to Format Dates & Times in Excel.mp4
    03:14
  • 4 Date & Time Functions You Need to Know.mp4
    05:35
  • 5 Using the TEXT Function with Dates & Times.mp4
    02:00
  • 6 Example Insights with Dates & Times.mp4
    04:49
  • 7 Example Project Timings.mp4
    04:10
  • 8 Example Tracking a Budget.mp4
    03:30
  • 9 Next Steps.mp4
    00:17
  • Answers - Excel - Dates & Times.xlsx.xlsx
  • Excel - Dates & Times.xlsx.xlsx
  • Description


    This class will teach you how to work effectively with date and time data in Microsoft Excel. Understanding how to work with dates and times in Excel is essential as data analysis so often involves date and time values. The class covers: 

    • How Excel treats date and time values
    • Formatting approaches and best practices
    • Popular date and time functions
    • Example use cases and tips

    Who is this class for?

    This class is for people who already have a foundational understanding of how to use Excel (e.g. you understand basic formulas, functions, and formatting), and want to get better at working with dates and times.

    If you're completely or very new to Excel and want to get started learning, then my 'Excel for Beginners: Learn The Essentials in 50 Minutes' is a better place to start.

    What will I get out of this class?

    • You'll gain core knowledge about how Excel treats date and time data, that a lot of Excel users don't have!
    • You'll be able to work with dates and times more efficiently, saving you time and energy!
    • You'll be less likely to make common mistakes when working with dates and times
    • You'll be able to conduct more detailed analysis around dates and times

    Interested in learning more about Excel? Check out my other classes:

    What You'll Learn?


      • Business
      • Spreadsheets
      • Excel
      • Productivity
      • Microsoft Excel
      • Microsoft Office
      • Microsoft

    More details


    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Excel Classes
    Excel Classes
    Instructor's Courses

    Hello, I'm Julian. 

    I'm a digital marketing consultant with 10+ years experience in using and teaching Excel, having worked for a number of agencies and international brands.

    I'm passionate about teaching Microsoft Excel in a simple and straightforward way. Check out my classes today to learn more about Excel :)

    Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.
    • language english
    • Training sessions 9
    • duration 27:22
    • English subtitles has
    • Release Date 2024/03/04

    Courses related to Excel

    The Excel Master Class
    UdemyThe Excel Master Class
    9:45:28
    06/10/2023
    Subtitle
    Top 15 Most Useful Excel Formulas
    UdemyTop 15 Most Useful Excel Formulas
    1:21:38
    English subtitles
    05/20/2024
    Subtitle
    Microsoft excel from beginner to expert
    Udemy Dr. Rasheed
    Dr. Rasheed
    Microsoft excel from beginner to expert
    6:59:59
    English subtitles
    02/29/2024