Making Gantt charts in Excel

A tutorial on how to make make a Gantt chart in Excel by using standard graphing tools.

Other sources:


Excel does not recalculate

Problem:
You type in the numbers, but the results in other cells do not change. The numbers seem frozen. You can type in whatever you want, the formulas in the cells are not recalculated.

Reason:
Calculation mode is switched to manual.

Solution:
Formulas -> Calculation -> Calculation Options -> Automatic


Non-breaking characters in MS Word

Use this in MS Word, if you do not want your text break at a space or a hyphen and get partially transferred to the next line.

  • Nonbreaking space: Ctrl + Shift + Spacebar
  • Nonbreaking hyphen: Ctrl + Shift + Hyphen