Excel spreadsheets must be built and multiple formulas used to calculate a company's WACC, as there is no specific formula that can be entered. Build the Excel Sheet First, enter the following ...

In this example, we displayed two Average functions in the first row. When you want to evaluate the same group, but display a different function, add a new row.

Image: 200dgr/Shutterstock. Applying multiple criteria against different columns to filter the data set in Microsoft Excel sounds difficult but it really isn’t as hard as it sounds.

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...