MM0062 - How To Analyse Times And Dates In Excel
Working with dates and times in Excel can be a nightmare! But, things can get a lot easier when you understand how Excel expresses time and learn some basic formulae for working with time and dates. In this stream, we undertake a real-world task involving analysis of shift lengths, and aim to produce a helpful visualisation for our 'customer'. We almost get there!
Topics
- | Steve Joins The Stream
- | Problem Description - Dates In Excel
- | How Good Is Excel Online?
- | View A Time As A Value
- | How Excel Understands Time As A Decimal
- | View Times And Decimal Equivalents
- | Different Cell Clear Options
- | How Excel Understands Days As Numbers
- | What Is Today's Day Number?
- | TODAY
- | SECOND; MINUTE; HOUR
- | DAY; WEEKDAY; WEEKNUM
- | ALT & H & 9 Shortcut - Reduce Decimal Places
- | ALT & A & S & S Shortcut - Sort Data
- | FREQUENCY
- | AVERAGEIFS
- | How To Adjust Chart Series
1 Lesson