Suggestions to Ensure a Work Development Tracker is Easily Usable Each New Professional Year
Our take
Hi all,
Apologies in advance if this isn’t clear - I’m not super savvy, but I’ve created a Development Tracker for managers to use for their direct reports to aid progression and skill documentation. I’m wondering if anybody has any suggestions for this to easily be used year on year (i.e. 2025 skill/courses inputs are now outdated, but 2026 skills build on 2025’s), whilst maintaining or documenting previous text inputs somehow. I want people to be able to maintain it themselves easily, without adding extra work for them haha.
My current options are below - any better suggestions?
- manually create a copy and label that 2025, so last year’s info isn’t lost.
- create a vba macro and button that automatically copies the file, renames it, and saves it in the relevant location upon a click (reduces manual steps for users)
- create an extra tab per direct report for previous years (not ideal: there’d be endless tabs)
- suggest that the manager screenshots the inputs and save that image lol.
For context, the tracker houses:
- a ‘master’ control tab which details all names, and a table where when an “x” is added, which flows into the relevant direct report’s tab as a table
- an individual tab for each direct report
- quantitative data on the right hand side
- a heap of formulas calculating percentages based on available inputs
- qualitative data on the left hand side
- cells that automatically show and/or are hidden when a certain job title is added in a specific cell
- cells that automatically show and/or hidden based on whether they’re on the promotion radar, again, specified in a specific cell.
Some managers don’t want to delete previously added text in the “skills/training courses” section, but I don’t want people to constantly need to add entire rows, since it’ll disrupt the formulas
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Looking for project tracking ideasHi, As the title suggests I’m trying to create an Excel sheet that tracks the progress of various projects. Essentially, I was given a messy excel document to look after. I don’t have particularly advanced skills and nor do I want to spend too much time on this. So… One sheet lists projects as rows and they all have a reference code. There is a column designated for “action updates” where people overwrite progress each month. Other columns exist for project status, dates etc. My idea was to create another sheet which also lists the projects but acts as an action/change history log. I attempted to have a drop down through grouped cells that would act as a historic list of all changes and action updates around each project. The row with the corresponding project number would act as a “live view”, so using an X look up to display this data on the original sheet. Is there a better way to create something like this? There must be loads of ways to do something like this, but I just can’t think which way to do it!! Thank you for any help!!! submitted by /u/Formal_Disk_3760 [link] [comments]
- Need Excel Help – Investor Distribution Comparison (High Visibility Project)Hi everyone, I’m an accountant in the real estate industry, and I’ve been given a high-visibility project that I really want to knock out of the park. For the past ~2 years, I’ve been manually calculating and distributing investor returns using a QFR-based Excel process. This feeds into our accounting system (Sage Intacct) and ultimately into our ACH distributions. Recently, our company developed new portal functionality that allows investor distributions to be processed automatically with the click of a button. Before this goes live, I’ve been asked to validate it by comparing historical distributions (January & February) against what the portal generates. What I Have So Far My initial thought was to create a basic comparison like: Historical Amount Portal Amount Variance (=B2 - C2) But that feels way too basic for something this important. I want to elevate this into something management can actually gain insight from—not just a simple variance check. What I’m Trying to Build I’d love help or ideas on how to make this spreadsheet more robust and “presentation-ready.” Specifically: 1. Comparison Tab Clean layout comparing historical vs. portal data Meaningful variance analysis (not just raw differences) Flags or indicators for material discrepancies Anything that helps quickly identify issues at a glance 2. Summary / Dashboard Tab High-level view for management Total distributions (historical vs portal) Total variance and % variance Count of mismatches or exceptions Any visual elements (charts, conditional formatting, etc.) that improve clarity 3. Edge Cases / Notes Tab I also need a third tab that outlines nuances the developers need to consider before production, such as: JE import creation requirements Rounding issues Wire vs. ACH needs for custodians Investor-specific scenarios I understand the logic behind these items, but I’m struggling with how to present them in a clean, structured way. My Skill Level I’d say I’m beyond a beginner in Excel, but definitely not advanced—I know the basics well but haven’t fully leveraged things like dashboards, advanced formulas, or more polished presentation techniques. What I’m Looking For Specific formulas or features I should incorporate Layout or structure suggestions Ideas to make this more insightful for management Anything that would make this feel like a “senior-level” deliverable This is a big opportunity for me to stand out, so I really appreciate any advice you can share. Thanks in advance, I'm excited to dive into the community! 🙏 submitted by /u/Affectionate_Net3153 [link] [comments]
- Personal life tracker : data structure and essential functionsThis might be silly… but I want to get better at Excel and I figured the best way to do that is to "gamify" my life. I’m planning to build one massive workbook to track everything: -Personal Finances: Budgeting vs. actual spend. -Media Tracker: Books read, movies watched, and ratings. -Health/Habits: Gym days, water intake, or sleep. Has anyone else done this? I’d love to hear your tips on structure. Specifically: -Do you keep everything in one giant file or separate ones? - What are some "must-have" functions for a dashboard like this? - Any screenshots or templates you’re proud of and willing to share? I’m not new to excel, I use it for work and school already, but trying to get better submitted by /u/arabellys [link] [comments]
- Is there any way to make a relational DB like thing in excel?For context, my work involves maintaining a lot of excel trackers. Basically we maintain these to track project details for a client like project deliverables, project codes (for employee clock-ins), project milestones, project assigned to PMs or not, etc - all in different excel files. This might sound like simple info, but we capture a lot of details related to project in all those files - like the main tracker will have bascially columns for capturing info from every section of the contract signed with client. The clock-in codes tracker will have its name, parent account ID, clock-in category, project ID, and a few other columns. Just adding one project's details to all trackers takes about 30-50 mins right now (depending on complexity and category of the project). However, maintaining multiple files leads to a lot of duplication effort - basically you add name of the project, project ID, PM name etc so many times. Anyway this can be changed? Like we add all data in one sheet and maybe pull it into different views for different purposes? I have done some research with gpt and on youtube, but they suggest going the power apps/ power BI way, but I am not too well-versed with those. And I was thinking if there is another solution that can be done in excel itself? Or if power BI is the way, then maybe can you guide me to a starting point for that? Thanks in advance. submitted by /u/WorldlyDot_1 [link] [comments]