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.
