admin
639 TopicsFile Attachments
π« Reminder: Do Not Share Real Customer Data or PII in the Community As a friendly reminder to all members of the Excel Community: Please do not post any content that contains personally identifiable information (PII) or real customer data. This includes names, email addresses, phone numbers, account numbers, or any other data that could be used to identify an individual. π Protecting privacy is a shared responsibility. If we suspect that any content contains real customer data, community administrators may remove it without warning to protect privacy and ensure compliance with our policies. Per our Terms of Use : You should only upload content that you have permission to share. If you're sharing examples or screenshots, please use dummy or anonymized data. Clearly indicate in your post that the data is fictitious or anonymized. Letβs work together to keep the Microsoft Tech Community a safe, respectful, and productive space for everyone. If you find a post with content likely to be personal in it then please report the post using the cog in the top right corner. Thank you for your cooperation! Microsoft Tech Community Admin Team1.3KViews6likes0CommentsExcel Community: Simplifying Spaces and Labels
Hi all, As you may have noticed already, we as the Excel Team have done a bit of "spring/summer cleaning" for the community. We have received feedback that the number of "spaces" was simply too many at nine, so we have pared things down. Now, there are three community spaces: Excel: this will be the primary place for posting content, as many of the old spaces have been migrated as labels will find a good home here BI and Data Analysis: this will be a good place for posting about tasks and questions that cut across Excel, Power BI, and other topics in this realm Resources and Community: this will increasingly become a place for folks to share sample files and templates with each other Q: What happened to the other spaces that used to exist? A: They have since been rolled up as "Labels", which you can find in the "More Resources" sidebar under "Labels" of any of the three spaces mentioned above. Look for these on the right side: Please let us know if you have any other questions. Thanks for reading!4.6KViews5likes25CommentsStudent Behaviour Tracker
This is a very cheeky request for help. Now approaching 70 I've forgotten most of what I knew about Excel. I'm a Chair of Governors at an 11-16 school. I receive notifications about pupils who have been suspended (also known as fixed term exclusion). Roughly I have about 200 individual suspensions over 1 year. I want to record and analyse these. The information to record is Name: Last and First (about 30-40 students) Reason for exclusion (usually 1 or possibly 2 out of about 8 categories) Length of exclusion 1 - 15 days Flags e.g. SEND; PP, Year group: 7, 8 , 9 10, 11 Date As many of the students are repeat offenders I'd like to set the spreadsheet up so by either by typing the name or through an editable drop down list the name appears once and then the reason for the suspension and date is entered (as opposed to multiple entries appearing on the same page). I'd then like the spreadsheet to report, using an editable date range: By pupil name; the number of suspensions; total number of days and total number of days for each category of exclusion By suspension category: number of suspensions; total number of days for each category By flag: number of suspensions; total number of days for each category Year group: 7, 8 , 9 10, 11: number of suspensions; total number of days for each category I've looked at some cheap packages e.g. at Etsy but I cant see anything that does this. There are commercial packages, intended for whole school, but cost several hundred - thousand plus, pounds. Thanks in advance if you are interested and my apologies to you if you feel this is an inappropriate request. Regards NickSolved165Views2likes4CommentsQuestion with this forum itself
Why is the "Start a Discussion" button so hard to find. I doesn't show up for me unless I use a really obscure link to get here. What am I doing wrong that that button is nowhere to be found when I come to this site normally? Also the share links on the left side are very obstructive. It blocks text and I cannot get rid of it.186Views2likes12CommentsExcel Tools for Network & Windows
Excel Tools for Network & Windows Some time ago I already shared an earlier version of this project. Since then, I have added several new features. These tools are based on functionalities that already exist in Windows and its associated software. I have consolidated them into a single Excel-based interface, allowing all tools to be executed directly from Excel. The files are free for private use. For business or enterprise environments, a more comprehensive toolbox can be developed, enabling direct support, repair, management, monitoring, and control of users and systems. Everything can be customized according to specific requirements β the scope depends solely on the desired functionality, time investment, and budget. I appreciate any positive feedback, suggestions, or constructive tips. If this project is not of interest to you, please feel free to ignore it. Thank you, and I wish everyone happy holidays.190Views2likes2CommentsHow to limit "Forwarding" of a shared Excel Workbook
Hello, I am trying to understand if this is possible so please bear with me. I have shared access to my Workbook with an individual from another agency, which is working well. They in turn shared it to a coworker without my knowledge. Thankfully there is no inherit confidentiality concerns but it presented a problem. I never received an email about the "forwarding" and was only made aware when Individual A informed me they had shared it with their coworker. They did receive an email that it was "shared" but I did not. Can I limit who shares access to the workbook? The only permissions I am able to see that are changeable are "Edit" and "View" When I am using the word "forwarding", I am thinking of how you can forward a scheduled appointment in Outlook, which sends an email to the host, letting them know the meeting was forwarded. Thank you so much for your help.289Views2likes3CommentsNeed to allocate stock
Hi, here attached my file which i need to allocate my stock. in 1st table i have order number / delivery date / items and required qty . 2nd table i have mentioned closing stock . i need to allocate that closing stock to 1st table items on available qty column based on delivery date ( with delivery date priority- 1st qty for 1st delivery)Solved4.7KViews1like13Comments