Excel Expert Needed to Build a Planner, Caseload Tracker and Dashboard

Posted yesterday

Worldwide

Summary

About Us - We are a platform that develops practical resources for school counselors. We are looking to create a premium Microsoft Excel planning and documentation system. We already have an Excel workbook that demonstrates the general style and functionality we like. This workbook is for inspiration only - we are looking for an original workbook designed specifically for our brand and requirements. Project Overview - We are seeking an experienced Microsoft Excel developer to build a professional, intuitive workbook that combines planning, documentation, reporting and data dashboards into one system. The workbook should be visually appealing m(using our brand colors/theme), easy to use and designed for professionals who may only have basic to intermediate Excel knowledge. Required Features Interactive Dashboard The dashboard should automatically display key statistics including: Individual counselling sessions Group counselling sessions Classroom lessons delivered Students seen Caseload overview Parent/carer contacts Referrals Follow-up reminders Time spent in different activities Monthly and yearly summaries Caseload Management Student list Grade level Presenting concerns Support tier Status Referral information Follow-up dates Notes Individual Session Log Each session should allow documentation of: Date Student Grade Presenting concern Session focus Intervention used Duration Outcome Follow-up required Notes Group Session Log Group name Session topic Students attending Number of participants Session duration Activities completed Outcomes Follow-up notes Time Tracker The workbook should allow users to record time spent across different responsibilities including: Individual counselling Group counselling Classroom lessons Parent consultation Teacher consultation Meetings Administration Professional development Crisis response Automatic calculations and summaries are required. Curriculum Map - One of the major components will be a curriculum planning section that includes: Year level Month Week Theme Learning objectives Resource used Delivery status Notes Ideally this information should integrate with the dashboard where appropriate. Functionality The workbook should include: Professional design Easy navigation Linked worksheets Drop-down menus Conditional formatting Automatic formulas Filters Dashboard charts Protected formulas where appropriate Clean layout suitable for commercial distribution Important - We require full commercial rights to the completed workbook. The finished workbook should be fully editable and supplied without passwords or restrictions. To Apply - Please include: Examples of advanced Excel work you have created. Dashboards or planning systems you have built. Estimated timeframe. Any recommendations you believe would improve this project. NOTE - We are hoping to build a long-term working relationship with the right developer. In addition to this project, there will be opportunities for ongoing work, including updates, new features, additional planners and other Excel-based tools for our educational platform.

  • Hours to be determined
    Hourly
  • < 1 month
    Duration
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Microsoft Excel
Data Visualization
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:4 hours ago
  • Interviewing:
    1
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Aug 3, 2026
  • Australia
    10:21 PM

Explore similar jobs on Upwork

Property Intelligence PartnerHourly‐ Posted 2 weeks ago
Customer Service
Data Entry
Bibliometric Analysis on Scopus DatabaseFixed-price‐ Posted 1 month ago
Data Analysis
Quantitative Analysis

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo