Description
Learn how to work with times and dates in Excel
Two of the most frequently occurring and important fields in databases or project documents are times and dates. In Excel you can further analyse these aspects but many Excel users struggle to do so. This webinar will teach you the functions and formulas that will help you carry out correct date and time calculations.
Content
Part 1: layout options for dates
- The concept of date and time in Excel
- Standard layout via the Ribbon
- Advanced layout via Format Cells
Part 2: basic calculations using dates and time
- Counting with dates
- Counting with time
Part 3: date and time functions
- TODAY and NOW
- Splitting and combining dates and time
- NETWORKDAYS
- DATEDIF
