Working With Dates and Times in Excel

Buy for 34.99$
Course description
Are you aware that a simple column of dates in an Excel spreadsheet conceals a goldmine of valuable information? When unearthed, it can enrich reports and provide fresh new perspectives on data?A handful of savvy analysts stand out from the crowd by having rich skill sets to uncover this goldmine and tap into the power of date-and-time data. However, a vast majority of business and data analysts just "wing it" and fail to take full advantage of dates and times in spreadsheets. Which is a shame because these skills truly expand the horizon of available options for data analysis. Fortunately, this class helps fill the gap and learn how you can take full advantage of Excel's dates and times in your datasets and reports. If you believe you can benefit from improving your skills and knowledge in this domain, sign up and discover all you need to know for success with dates and times in Excel: from flexible formatting to powerful formulas. As a result of the training, you will feel better equipped to solve almost any problem involving date or time data in Excel. From formatting to calculations, the secrets of Excel's date and time are finally revealed in this class. What you are getting: A full understanding of the date-and-time system in ExcelClarity of how Excel records, stores and formats dates and timesSorting and filtering datasets based on datesTechniques for entering dates and times in spreadsheetsUsing the auto-fill tool to enter date time informationTransforming date-and-time with "Text to Columns"Dates, times and "Flash Fill"Custom formatting of dates and times: mastering number-formatting codesUse the TEXT function to create values based on formatting codesDate and time in formulas and functions: Calculate the year, the quarter and the month from a dateCalculate dates if years, months and days are stored separatelyCalculate the fiscal year, the fiscal quarter and the fiscal month number from a date-automaticallyCalculate the academic quarter from a dateCalculate the difference between datesCalculations based on dates stored as text stringsHow to separate dates and times in timestamp dataTime calculationsHow to create custom functions and simplify your formulasCalculations with workdays, days off and holidays. Dates and times in Pivot TablesUseful productivity tips and shortcutsAnd more…The class will arm you with knowledge, tools and techniques for solving common problems and scenarios that you may face when working with date and time information in Excel. Enroll now!




We have 62183 courses
0 reviews
0 Rating

Udemy is one of the top online learning platforms founded in 2010 currently offering over 175,000 free and paid courses.

Related topics:

On our resource by searching online courses, you can take a course Working With Dates and Times in Excel at the cost of: 34.99. Current material belongs to category Excel from a supplier Udemy, and fits perfectly at the level of difficulty: any level of expertise. Experienced educator without any problem will help you in realizing new professional horizons. You can check out feedback of other users about this online course or share your feedback to help other students make a decision!

How to get new skills with Skillcombo?

Explore courses that align with your interests, dive into detailed descriptions, and browse through reviews to confidently choose your next learning path. Easily use our filters for level, duration, language, and price to find the right option for your goals.

  • 15+ popular course providers
  • 60000+ online courses in catalog
  • 1000+ IT subjects