Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
  • Data Trends by Month Dashboard Excel
Originally published: 09/07/2018 13:06
Publication number: ELQ-60966-1
View all versions & Certificate
certified

Data Trends by Month Dashboard Excel

This dashboard shows a range of operational, financial and HR information with comparison, trend and variance to plan.

Description
The report provides a range of data with a high amount of detail. Some of the metrics covered include revenue v plan, expenses v plan on a region by region basis. Project spend, customer satisfaction, website visitors by department, 24 month trend analysis for revenue by employee, volume by employee, cultural diversity, attendance, risk, market growth, leads and product lines.

There are a number of charts including some high level gauge charts, a waterfall chart, customer satisfaction, employee satisfaction, change in FTE and an interesting look at projects by size comparing current year to the same period (n ) years ago. The report contains a range of interesting infographics which tie in well with the underlying dataset.

The report uses a slicer to spin the dashboard by region and the details by country will change accordingly. There is a combo box which allows the monthly aspects of the report to change showing YTD data seamlessly.

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

Provide highly detailed summary of key financial and non financial metrics in a succinct one page report.

Organisations or individuals who wish to incorporate operational data and make financial comparisons actual v plan and a range of key organisational data.
The file has a clean clear finish and is well laid out from inputs, calcs to outputs. The model is simple to follow and update.

Reviews

  • Mike DiNardo(last updated: 26/04/2019 14:32)
    I love them all!
    Keep them coming, Marcus! I love them all!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Marcus Small

See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Data Trends By Month Dashboard Excel

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

  • Marcus Small
    * comment deleted *
    arrow_drop_uparrow_drop_downReply reply
    • Brett Valentine
      I am getting the following error, any thoughts?

      Sub Rotation() 'Rotates the shapes on the speedo charts
      Dim shp As Shape
      Dim ar As Variant
      Dim i As Integer

      ar = [{"Group 5","Group 77","Group 149"}] 'Change to suit
      Application.ScreenUpdating = False
      For i = 1 To 3
      Set shp = ActiveSheet.Shapes(ar(i)) 'Dash tab
      shp.Rotation = Sheet4.Range("D" & 22 + i) * 228
      Next i

      Application.ScreenUpdating = True
      End Sub
      arrow_drop_uparrow_drop_downReply reply
      • Marcus Small
        Hi Brett

        I thought I was commenting on a different tool - sorry - OK so what is the line that fails in the above? The Chart Sheet needs to have the data starting from line 22. That is the percentages. If these move then there may be an issue.

        My offer stands if you want to send me the file I can tell you what has changed and how it can be rectified permanently.

        Take care

        Marcus
        arrow_drop_uparrow_drop_downReply reply
      please wait...