Revenue Profit analysis 

This Excel sheet was created during my first week of the Data Bootcamp

Executive Summary  

This Excel project compares five years of revenue and profit (2017–2021) using a simple dataset and line chart. Both metrics show steady growth, with revenue rising faster than profit, highlighting strong long‑term financial performance.

Key Insights

• Consistent year‑on‑year growth

• Revenue outpaces profit

• Clear upward financial trend

Skills Demonstrated

• Excel data cleaning

• Line chart creation

• Trend analysis

• Multi‑year summarisation

Dataset Structure  

Year, 12‑Month Profit, 12‑Month Revenue, Grand Totals.

Visualisation  

Line chart showing growth patterns and divergence between revenue and profit.

Purpose  

Showcases financial analysis, visualisation, and insight communication using Excel.

Future Enhancements  

Percentage change, profit margins, conditional formatting, multi‑chart dashboard.

Github Link: OwenMasterson/Excel-revenue-profit-analysis