Module 08 · Tell the story, maintain & fix

When something breaks

The four most common symptoms and their fixes, including the empty Vendor column in the November file.

Step by step7 minLesson 36 of 37 Members

Sooner or later something will break: a refresh fails, months sort alphabetically, or a column suddenly goes empty. The good news is that almost every problem follows a few familiar patterns, and each one has a clear fix. In this lesson you learn to recognise the four most common symptoms, then fix one that is genuinely hidden in your practice files: the November file.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

  • 5 steps with a numbered picture
  • All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
  • A new Excel & dashboard template every day, with resell rights
  • Take paid client projects on the Project Board

One payment for 12 months, no automatic renewal. Back to the free lessons