←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Tips on my Dashboard Summary and Sales Tracker

Hi everyone,

I can't figure out on my last part doing my dashboard summary.I need help creating a dynamic monthly dashboard in Excel.

I have a Sales Tracker sheet where all my data is recorded (dates, orders, totals, etc.), and I want to build a Dashboard Summary where:

  • I can select a month (e.g., January, February, etc.)
  • Then the dashboard will automatically show:
    • Total orders
    • Total sales
    • (and possibly filtered data from that selected month)

I’m not sure what’s the best approach to use. Basically, I want the dashboard to update based on the selected month from a dropdown.

If possible, I’d appreciate: Step-by-step guidance, sample formulas or a sample file structure

Thanks in advance!

submitted by /u/Da_urs
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#rows.com
#cloud-based spreadsheet applications
#Dashboard Summary
#Sales Tracker
#Excel
#dynamic monthly dashboard
#Total orders