Resampling to Hourly Averages with HOUR & AVERAGEIFS
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Timestamps & Sampling Intervals: Finding the GapsFree
- Resampling to Hourly Averages with HOUR & AVERAGEIFS Pro
- Threshold Excursions: Count, Minutes & the Longest Excursion Pro
- Sensor Uptime & Data Completeness % Pro
- Calibration Drift vs a Reference Sensor: SLOPE & FORECAST Pro
- Smoothing: Moving Average vs Raw Noise (with a Chart) Pro
- Alert Rules with Hysteresis: ON above X, OFF below Y Pro
- Compliance Report: Daily Status, Time in Range, MKT & a Chart Pro