•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel with PowerAutomat vs List with automation
Our take
Managing a spreadsheet for over 3,000 nursing students can be a daunting task, especially when it requires constant manual updates. Transitioning from Excel to using Microsoft Lists with automation could simplify your process significantly. By leveraging Lists, you can create a dynamic database that automatically notifies Unit Contacts when students are added or their status changes. This approach not only enhances efficiency but also frees up your time for more meaningful data analysis. Embrace this innovative solution to streamline your workflow and improve communication.
So I manage a spreadsheet of nursing students coming into our healthcare system. I update it manually when a student name is added to a rotation in ACEMAPP (our web based student management solution) and I change the status in the spreadsheet to “Approved” when the student has completed their onboarding to be onsite. I am trying to get the spreadsheet to email the Unit Contact to let them know 1) when a student name is added 2) when the status is approved, so they don’t always have to just go check it for changes. I was talking to our SharePoint person and she said I should use Lists instead of trying to learn PowerAutomate for the spreadsheet in Excel. Thoughts? I am a masters prepared nurse who manages incoming healthcare students, but I do a lot of data management and would love to create a living database like this to track our over 3000 students per year. Basically feel free to dumb it down for me, but I am a quick learner with a deep interest in data analysis and management (currently looking at adding an MBA in Project Management to my letters).
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel Power Automation - Sending Emails to Users Based on Sheet CriteriaHi All! My organization currently uses a website called Smartsheets to create task lists. I've created automations that run each morning that send emails to users if a task becomes past due. It fulfills the intended purpose; however, every single month there seems to be some new issue; therefore, I'd like to transfer over to using functionality in native Excel. My research turned me on to Power Automation. I found the tools I needed until I hit a roadblock: P.A. does not look at the contact within the sheet and send a message to that person. It appears to just go to one designated individual. Any thoughts, recommendations, or solutions? I am almost at the end of my rope and ready to just deal with Smartsheets. A screenshot of our task list can be found in the comments. Maybe it provides some reference that I missed. Thanks! submitted by /u/bltsmith [link] [comments]
- Creating an auto-populating visual calendar for multiple departments to view?I coordinate student schedules across multiple hospital units. I log the shifts in an hours log spreadsheet (date, start time, end time, unit, student name, etc.). Every month, I need to send each unit a schedule showing who is coming in and when so they can review and plan coverage. Right now, this part is very manual, and does not lend to tracking any data like how many students on each units, hours, etc., which we need as a department. We have over 100 students each month, so as much automizing as possible would be helpful as its a big process. Ideally, I’d like something that: Pulls directly from the hours log (no retyping or copy/paste) Is easy to read at a glance for unit managers Can handle many units, many months, and many students Lets me filter by unit + month I'm not really an excel genius, and I've been using copilot to help me with some of this and formulations, but It's not providing me with accurate formulas for the actual calendar conversion. If there are any resources on what formulas to use, what platforms that I could maybe look into for how to do this, or just honestly any advice at all. We've gotten the data tracking mostly drafted up and it's able to pull from pivot tables and show the analytics, but the calendar is my biggest hurdle at the moment. submitted by /u/JuggernautFlashy6489 [link] [comments]
- using MS forms with excelHello! I have a massive spreadsheet that I need to use for lots of reporting. I've tried to pare it down as much as possible for those who have to do the actual data entry, but they are still very overwhelmed by it (they really don't understand how to even use filters to narrow down the scope) and so the data coming out is not reliable. I've never used MS forms in conjunction with excel, but I'm thinking that if I create a form for them just to enter the basics, I would at least have correct data for my analysis piece. The only thing I'm concerned about is that there are updates to entries that need to be made (ie- someone earns an additional level of certification or they drop out of the program). Can this be accomplished with forms? Or am I barking up the wrong tree. I was hoping to get some advice before I start really teaching myself how to use MS forms (any suggestions for good tutorials would be great too). Thank you in advance! submitted by /u/bluellama314 [link] [comments]
- Can I "link" different spreadsheets together and make them "communicate"?i am new to excel but hoping to get a quick answer to my question as I am having trouble finding this on the web. i have Spreadsheet A where new hires get added to a list by someone else. This include their name, division, email, etc. I manage education and compliance in Spreadsheet B which includes me having to manually go through spreadsheet A and pulling all the info over. other than this inconvenience, the trouble is the person managing spreadsheet A deletes these people from her spreadsheet after she is done with their on boarding process so if i dont catch it, its a pain in the ass for me to get that info lol. is there a way for me to have my spreadsheet get updated when she updates hers, but not have that information deleted if she were to delete something from it? submitted by /u/AbleKaleidoscope877 [link] [comments]
Tagged with
#Excel alternatives for data analysis#big data management in spreadsheets#generative AI for data analysis#enterprise data management#cloud-based spreadsheet applications#automation in spreadsheet workflows#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#natural language processing for spreadsheets#conversational data analysis#data analysis tools#Excel compatibility#Excel alternatives