Skip to content Skip to site navigation Skip to service navigation

Excel Dates and Times Unleashed: Unlock Analytical Power and Productivity

New session times will be displayed below upon confirmation.

Most Technology Training classes will be delivered online until further notice.

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.

Excel analysts know that a simple column of dates in an Excel spreadsheet conceals a goldmine of valuable information that, when uncovered, can give your reports incredible analytical power and fresh new perspectives on data. 

If you believe you can benefit from improving your skills and knowledge in this domain, this class will help you discover all you need to know for success with dates and times in Excel: from flexible formatting to powerful formulas. 

Thanks to this training, you will feel better prepared 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.

Class goals include: 

  • A full understanding of the date-and-time system in Excel
  • Clarity of how Excel records, stores and formats dates and times
  • Sorting and filtering datasets based on dates
  • Techniques for entering dates and times in spreadsheets
  • Using the auto-fill tool to enter date time information
  • Transforming date-and-time with Text to Columns
  • Dates, times and Flash Fill
  • Custom formatting of dates and times: mastering number-formatting codes
  • Use the TEXT function to create values based on formatting codes
  • Date and time in formulas and functions:
    •    Calculate the year, the quarter and the month for a date
    •    Calculate dates if years, months and days are stored separately
    •    Calculate the fiscal year, the fiscal quarter and the fiscal month number from a date - automatically
    •    Calculate the academic quarter from a date
    •    Calculate the difference between dates
    •    Calculations based on dates stored as text strings
    •    How to separate dates and times in timestamp data
    •    Time calculations
    •    How to create custom functions and simplify your formulas
    •    Calculations with workdays, days off and holidays.
  • Dates and times in Pivot Tables
  • Useful productivity tips and shortcuts

The class will arm you with knowledge, tools, and techniques for solving common problems and scenarios you may face when working with date and time information in Excel.

Igor Ovchinnikov

Igor Ovchinnikov has been teaching software productivity classes for over 20 years. Stanford staff have enjoyed his training since around 2007. His training philosophy stems from a strong belief that learning is a perpetual cycle of new discoveries and improvement.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.