#exceltricks

Contents
0:00 Introduction
00:12 1. Auto Fill Blanks
02:10 2. Fill Date Series
05:57 3. Add weekday format
07:23 4. Remove Empty Rows
08:32 5. Auto status of due date
13:46 6. Zero prefix
15:30 7. Replace zero by “–”
17:39 8. Text to value