•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Using Data from Two Sheets to find classes
Our take
Navigating the complexities of Excel can be challenging, especially when trying to combine data from multiple sheets. In your case, you want to merge the training class availability with learner requests to create a clear overview of potential enrollments. By utilizing functions like VLOOKUP or creating a pivot table, you can efficiently display which students can fill available seats. This approach not only simplifies your data management but also enhances your team's ability to make informed decisions about training opportunities. Let’s explore these methods together.
I work in a corporate job and somehow became the person on my team that knows excel best.
I’m okay with excel. Not an expert. But I need help.
I have a spreadsheet that lists available training classes and how many seats the class has and how many are still available.
I also have a sheet of learner requests for classes.
I would love to combine the data and be able to query or pivot to show a list of students that could be enrolled into available classes.
What’s the best method of going about that? Thanks.
If I need to go elsewhere to ask questions like this please direct me. Thanks.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Resources that help you get better at laying out Excel spreadsheets?When I have the opportunity to see someone else's sheets, sometimes I feel like "oh that's a better way to lay out the inputs v data/calcs. I'm comfortable with the data and formulas used, but I always feel like I could use improvement in laying out my information for others to understand. My brain thinks about in one sequence but that may not be the same for others. Are there any resources you've used that helped you get better at synthesizing the building of your workbooks? submitted by /u/brooklyn735 [link] [comments]
- Pulling data out of multiple tables across sheets to a master table?I am seeking to make a workbook that tracks to do lists across multiple different projects at our firm. We have about 50 projects going, so I made a pivot table and created a sheet for each project. Next, I want each sheet to have a list of tasks and deadlines, my thinking is that I need to make a table on each sheet, and then find a way to pull each respective table’s task/deadlines to the master sheet. Each project has different number of entries, or none at all is there a good way to create a table on each sheet without having to do it individually on each sheet? which function do I use to pull the data from each table into the master table? thank you for your explanations & education in excel submitted by /u/randominternetguy3 [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]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#rows.com#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools