Easy Website Metrics Dashboard with Excel - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Wednesday, August 5, 2020

Easy Website Metrics Dashboard with Excel

Easy Website Metrics Dashboard with Excel
Do you run an e-commerce website? You are going to love this simple, clear and easy website metrics dashboard. You can track 15 metrics (KPIs) and visualize their performance. The best part, it takes no more than 15 minutes to setup and use. Here is a preview of the dashboard.
Read on to learn how to use this.
website dashboard - Snapshot
Download Website Dashboard Template

How to use this Website Dashboard?

This dashboard is rather simple to use. Download the file using above link and follow these steps to set it up.
  1. Go to Data worksheet and enter your metrics (KPIs) and corresponding data for 2 weeks. 
  2. For each KPI, specify the type of calculation to use. You can get either total or average in the dashboard.
  3. Flag any 5 KPIs to show in summary tiles section.
  4. Go to Dashboard. It should be set up now.
  5. Format various metrics if needed (for example, currency format)
  6. Type 1 in column B (range B11:B25) to display an alert icon 🔴 next to a KPI
  7. Add any free text comments
That is all. The dashboard is ready to use. Present or print it.
#quantriexcel #kynangmoi

No comments:

Post a Comment