+ Reply to Thread
Results 1 to 2 of 2

Advice on building a dashboard

  1. #1
    Registered User
    Join Date
    01-23-2016
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Office 2016
    Posts
    36

    Advice on building a dashboard

    Hey Excelers,

    With the help of this forum, I now have a very helpful Holiday/Leave tracker. For the next step, I want to build a dashboard for this spreadsheet that shows me trends (such as who's taken the most/least sick leave, holiday, etc) and leave forecasts for the upcoming months that could show the entire company and also could be filtered to show specific departments. This dashboard would also be used by department managers when planning their staff for the upcoming months, which is where filtering the data by department will come in handy.

    Can you please give me advice on where I should start with building the dashboard. This is the first time for me and I am conscious that I haven't always been approaching my data handling in the best way, so would love to get some good advice on where to start. I am also vaguely aware that I may need to use pivot tables, but I've never used these before either.

    I have attached a sample version of the spreadsheet and hope this helps but I am happy to answer any follow up questions.

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    01-23-2016
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Office 2016
    Posts
    36

    Re: Advice on building a dashboard

    Anyone?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Freelancers for Dashboard building
    By Katherine82 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-13-2015, 02:13 PM
  2. Dashboard Advice Sought: How Would You Improve This?
    By The_Snook in forum Excel General
    Replies: 1
    Last Post: 03-06-2012, 09:08 PM
  3. help building a dashboard or graph !
    By masond3 in forum Excel General
    Replies: 1
    Last Post: 01-12-2012, 11:29 AM
  4. Duty Schedule i'm building, looking for advice
    By tlbliss in forum Excel General
    Replies: 1
    Last Post: 03-07-2011, 08:29 PM
  5. building invoice - strategy advice
    By in forum Excel General
    Replies: 0
    Last Post: 01-03-2005, 10:06 AM
  6. [SOLVED] building invoice - strategy advice
    By in forum Excel General
    Replies: 0
    Last Post: 01-02-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1