To calculate the sum of squares using Microsoft Excel, you need to input a specific formula into the formula bar of the cell you're working with.