To calculate the sum of squares using Microsoft Excel, you need to input a specific formula into the formula bar of the c. Chron Logo Hearst Newspapers Logo. Skip to main content. Newsletters.