Excel Tutorial - Calculating Percentages | Summary and Q&A

6.4K views
May 28, 2018
by
The Organic Chemistry Tutor
Excel Tutorial - Calculating Percentages

TL;DR

Learn how to calculate percentages in Excel, including finding the total, average, and percentage change between values.

Install to Summarize YouTube Videos and Get Transcripts

Q: How do I calculate the total sales for a set of values in Excel?

To calculate the total sales, use the SUM function. Simply enter "=SUM(range)" and replace "range" with the cells containing the sales values. Press Enter to get the total sales.

Q: Can I calculate the average revenue in Excel using different methods?

Yes, you can calculate the average revenue using the AVERAGE function or manually dividing the total revenue by the number of months. Both methods should yield the same result.

Q: How do I calculate the percentage of a specific month's revenue compared to the total revenue?

Divide the monthly revenue by the total revenue using the formula "=monthly revenue/total revenue". Format the result as a percentage to get the percentage value.

Q: How can I calculate the percentage change between months in Excel?

Subtract the previous month's revenue from the current month's revenue, then divide by the previous month's revenue. Format the result as a percentage to get the percentage change.

Summary & Key Takeaways

• This video tutorial demonstrates how to calculate percentages in Excel using a sample monthly revenue data set.

• The tutorial covers expanding columns, entering sales data, finding the total and average revenue, and calculating the percentage of each month's revenue compared to the total.

• It also explains how to calculate the percentage change between months and format the results as percentages.