Forum Widgets
Latest Discussions
creating a separate tab for a common table
My question from a few days ago disappeared and I cannot locate it. I have created an Excel financial spreadsheet for myself that amasses all monthly data from my checking, investments, and credit cards. There are about 20 tabs including each month, each major account and others. Each monthly and account spreadsheets are identical. I created a table that has 3 column of data: Payee, account, and category which, in theory, auto update each spreadsheet. The downside to what I currently have is that every sheet needs an updated table which doesn't always work out to be complete. What I'd prefer is to have a separate tab in the spreadsheet that every tab could reference. I saw this once and know it can be done but, of course, I cannot find it. So, the question is, how can I get each month to find the separate tab (call it Ref or anything else) and input the appropriate data into the sheets? The current formula I am using for assigning the info is: =XLOOKUP(H14,Q:Q,S:S). The column reference are currently being used are because that's where they fit on each monthly spreadsheet. The data example is in the last row of the spreadsheet. All help is appreciated. Steve BackmanMicrosoft office specialist courseware
Hello, Does anyone know what happened with the Microsoft Office specialist official courseware? A week ago, it was available on the instructor recourses page on Microsoft Learn, but right now I can't find it there. The OneDrive links aren't available too; it says that they have expired. Thank you!
Time is Running Out – Complete the MSLE Pulse Survey Today!
We’re counting on your feedback to help shape future MSLE initiatives and ensure we meet your needs. The MSLE Pulse Survey closes October 31st, so don’t miss your chance to share your thoughts! 👉 https://aka.ms/MSLEcustomerpulse Thank you for helping us make MSLE even better!Upcoming event for your students - Fabric Data Days
Hi educators! It's my pleasure to let you know that we have an upcoming event that your students may be interested in. Fabric Data Days is designed to empower students, recent graduates, educators, and early career professionals to build in-demand Data & AI skills, connect with the global Fabric Community, and earn industry-recognized certifications. Give your learners the tools to thrive in today's Data & AI landscape: ✅ Student-specific DataViz Challenge ✅ Career insights from industry experts ✅ Discounted certifications to boost their resumes Join the movement and help your students get engaged, skilled, and certified! 👉 https://aka.ms/fabricdatadays/nextgen Have questions? Ask in the thread here or send me a private message! p.s. there's no license of any kind required to participate!Reminder to complete the MSLE Pulse Survey
Just a friendly reminder to complete the MLSE Pulse survey if you haven't yet done so. Your feedback will help shape future initiatives and ensure we’re aligned with your needs. The survey will remain open until October 31st, so please take a few minutes to share your thoughts. Thank you for helping us make MSLE even better! Link to Survey: aka.ms/MSLEcustomerpulse
The MSLE Pulse Survey is now open!
We’d love your input! The MSLE Pulse Survey is now open and we’re inviting all members of the MSLE Community to participate. Your feedback will help shape future initiatives and ensure we’re aligned with your needs. The survey will remain open until October 31st, so please take a few minutes to share your thoughts. Thank you for helping us make MSLE even better! Link to Survey: aka.ms/MSLEcustomerpulseReminder - The MSLE Pulse Survey is now open!
We’d love your input! The MSLE Pulse Survey is now open and we’re inviting all members of the MSLE Community to participate. Your feedback will help shape future initiatives and ensure we’re aligned with your needs. The survey will remain open until October 31st, so please take a few minutes to share your thoughts. Thank you for helping us make MSLE even better! Link to Survey: aka.ms/MSLEcustomerpulse
