How to Calculate Operating Expenses in Excel. An Excel spreadsheet is designed to automate the task of repetitive calculations. It can be an invaluable tool for ascertaining the income, capital ...