Monthly Sales Report Spreadsheet Creation

I need a comprehensive, user-friendly sales report spreadsheet designed for monthly data tracking.

Key Data:
- Revenue: The primary focus of the report
- Sales Rep Tracking: This includes new business, contract renewals, and lost business

Required Functionalities:
- Automated Calculations: To reduce manual input and errors
- Data Visualization: Charts and graphs to provide visual insights into the data
- Summary Sheet: A separate sheet that auto-populates with a summary of all data

Ideal Skills:
- Proficiency in Excel or Google Sheets
- Experience with sales reporting
- Skills in data visualization and analytics

I plan to update this spreadsheet on a monthly basis.