Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
  • Social Media Excel Dashboard
Originally published: 03/08/2018 14:35
Last version published: 22/03/2019 07:29
Publication number: ELQ-42240-3
View all versions & Certificate
certified

Social Media Excel Dashboard

This Social media KPI dashboard displays a range of online metrics (actual v plan v prior ) in a clear succinct summary.

Description
The file shows a range of track able online metrics, social media followers by geographic region, revenues, expenses and leads, website hits by search type and many more. The dashboard has a slicer, option buttons, a combo box which spins year to date by month. There is a heat map which changes focus (the region changes on the worksheet) from the Americas, Africa, Asia Pacific to Europe and lights each country up each country in the region based on actual versus plan. The output draws on my one cell to rule them all methodology to change every element of the report.

The data is structured in a logical format with the file flowing from left to right - Inputs - Calculations - Outputs. The file uses a range of tables, charts and shapes to display a compelling story. There are 15 charts which update based on region chosen and month so data can be compared going forward or backwards showing year do date comparisons.

Users will gain the maximum benefit from this file if they are already competent spreadsheets users. The file is designed for people who use Excel on a regular basis, and are comfortable with using its tools and functions. Incorporation of new data should be plug and play considering the calculations you wish incorporated.

This business tool includes
1 Excel File (15 Tabs)

Acquire business license for $99.00

Add to cart

Add to bookmarks

Discuss

Further information

To create a highly visual, elegant report, which can be updated quickly and easy and spun on a range of different metrics which can be swapped in or out at will.

Data display with normalised data feeding the calculations pages. This report would make a great addition to any management reporting suite.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Marcus Small

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Social Media Excel Dashboard?

The user community and author are here to help. Go ahead!

please wait...