Question: how to calculate percentage of total revenue in excel?
Answer: Select a cell next to the first revenue cell. Type an equals sign. ...  Type the forward slash (/) sign. ...  Press the F4 key. ...  Press Ctrl+Enter to enter the formula and stay in the current cell. ...  To use the format 9.2% (that is, one decimal place) instead of 9%, choose the Increase Decimal icon.