Next time you need to brush up on your spreadsheet skills or are in need of pivot table inspiration, look no further than r/excel. Learn more about the community below.
Post ni Reddit, Inc.
Higit Pang May Kaugnayang Post
-
Cloud | Digital | AI-ML | AZURE | Automation | Innovation | Delivery expertise
Dear Friends, I'm a big fan of Microsoft Excel, and I enjoy writing Excel functions. A few days back, one of my colleagues asked me how to solve this in in Excel. The problem: Given a table of Sub IDs, Group IDs, and Years, they wanted to get all the Sub IDs for a given Group ID and Year into a single column. I helped them solve the problem by using a combination of the following Excel functions: UNIQUE: to derive the unique GroupID-Year combination FILTER: to filter the Sub IDs based on the GroupID-Year combination TEXTJOIN: to convert the array of Sub IDs to a single value Here's a step-by-step : 1. Derive the unique GroupID-Year combination using the UNIQUE function: This will return a new column with the unique GroupID-Year combinations. 2. Filter the Sub IDs based on the GroupID-Year combination using the FILTER function: =FILTER($B$3:$B$11,($E$3:$E$11=G3)) This will return an array of Sub IDs for the given GroupID-Year combination. 3. Convert the array of Sub IDs to a single value using the TEXTJOIN function: =TEXTJOIN(":",TRUE,FILTER($B$3:$B$11,($E$3:$E$11=G3))) This will return a single value with all the Sub IDs separated by a colon. #Excel #ExcelTips #ExcelFunctions #ExcelMagic #Learning #tips #Filter #functions
-
-
📊 Dive into the World of MS Excel: Mastering the Basics! 📊 Hello #ExcelEnthusiasts, Are you ready to unlock the world of Microsoft Excel, the ultimate tool for organizing and interpreting information? Let's get started on your journey to becoming an Excel pro! 🚀 What's Next: Stay tuned for upcoming posts where we'll delve into more Excel features. You'll soon be navigating Excel with confidence! Ready to start your Excel journey? Let's do this! 💪 Feel free to share this post with friends who are looking to get a solid grasp of Excel basics. #MicrosoftExcel #ExcelMagic #SpreadsheetSkills
-
Microsoft MVP | 4 x Best-selling Excel Book Author | Founder of MyExcelOnline.Com | Excel Pro
⏳ Excel Time Magic: Transforming Clocks to Numbers! ✨ Join me in the time-travel adventure, where seconds become decimals and spreadsheets tell a numerical tale! ⬇️ Click below to get better at Microsoft Excel & stand out from the crowd with our FREE Excel Keyboard Shortcuts Cheat Sheet! ⬇️ 📁 SAVE this post! ❤️ SHARE the love with your friends/colleagues, like 👍 and comment below so we can provide you with more FREE Excel resources ✍️ 👉 FOLLOW us @myexcelonline for more Excel tips and goodies 🎁 #excel #msexcel #MicrosoftExcel #careerdevelopment #exceltips #exceltipsandtricks #excel101 #worksmarter #excelshortcuts #MyExcelOnline https://lnkd.in/d7V9X85Y
-
I've learned Excel Essentials (Microsoft 365), which helped me to know How and Why we're using Excel. Added to me Valuable informations like the meaning of Ribbon, Quick access tool bar, shortcut menus, mini toolbar and the formula bar. Also, How to use simple formulas and functions (Max,Min,Sum and Average), how to (insert, delete ,hide and unhide) rows and columns (headings). Finally, the usage and types of different charts. Thanks for #linkedinlearning for this Simple Excel basics helped me a lot to build my initial step in Excel.♥️
-
-
Assistant Professor and Assistant Dean, Faculty Affairs and Academic Operations, LM Thapar School of Management, Thapar University
Hello LinkedIn, Unlock Your Excel potential with "The Power of Excel" Channel! Are you ready to take your Excel skills to the next level? Look no further! Join thousands of professionals who are mastering Excel with "The Power of Excel" YouTube channel (https://lnkd.in/dfUfR4Zv) Whether you're a beginner or an advanced user, our channel offers invaluable tips, tutorials, and insights to help you excel in your career. From basic functions to advanced data analysis techniques, we've got you covered! Discover efficient workflows, time-saving shortcuts, and best practices to optimize your Excel experience and elevate your productivity. Subscribe now and embark on a journey of Excel mastery: [The Power of Excel YouTube Channel](https://lnkd.in/dfUfR4Zv) Don't miss out on the latest updates, tutorials, and Excel hacks. Subscribe, share, and excel with "The Power of Excel" today! #Excel #DataAnalysis #Productivity #ExcelTips #ThePowerOfExcel #CareerDevelopment
The Power of Excel - YouTube
youtube.com
-
Data Analyst || Cyber Security Analyst || Campus Ambassador at International MUN || P2E Task Force Member at UNICEF
Unleash the power of Excel with these CTRL shortcuts! 💻✨ Boost your productivity and become a spreadsheet wizard. 🔮 Use #ExcelMagic to share your favorite shortcuts! 1. **CTRL+C**: Copy data effortlessly. 2. **CTRL+V**: Paste with precision. 3. **CTRL+Z**: Undo mistakes in a blink. 4. **CTRL+S**: Save your masterpiece instantly. 5. **CTRL+A**: Select all cells like a pro. 6. **CTRL+Shift+L**: Filter your data seamlessly. 7. **CTRL+Arrow Keys**: Navigate swiftly through your sheet. 8. **CTRL+Page Up/Page Down**: Toggle between sheets effortlessly. Mastering these shortcuts will turn you into an Excel maestro! 🚀 Share your own favorites using excel shortcuts and let's create a community of efficient spreadsheet enthusiasts! 💼📊 #ProductivityHacks #ExcelTips #DataMastery
-
-
Make a Table of Contents for too many tabs in your Excel spreadsheet
Too many tabs in your Excel spreadsheet? Let me help you make a Table of Contents…⤵️ 🔸Use =SEQUENCE to create a list of numbers equal (or more) to your tabs. 🔸In the cell next to the sequence enter =SHEETNAME(A2) (if that’s where the first number is located). 🔸In the next column of cells enter =HYPERLINK( "#'"&B2&"'!A2", "Go To Sheet" ). 🔸Fill that formula down. Boom. 💥 Done. ✅ Now you have a hyperlinked table of contents that takes you right to the sheet you want. No more endlessly scrolling through your sheets! Have you tried this yet? Let me know! Want to learn more Excel? Then check out The Excel Dojo! 1000’s are learning Excel every week, and so can you! Check it out by clicking on the link on my profile. #excel #exceltips #learnexcel
-
Here's a nifty trick to help you effortlessly tally up the 𝗳𝗿𝗲𝗾𝘂𝗲𝗻𝗰𝘆 𝗼𝗳 𝘃𝗮𝗹𝘂𝗲𝘀 in Excel! Ever wondered how many times a specific word or letter pops up in a cell? 🤔 Well, you're in luck! Thanks to Leila, here’s a short formula to get this done easily. TEXTSPLIT is available in Excel for Microsoft 365. For older Excel versions check out this video: https://lnkd.in/dXueeQCz Want more time-saving tips like this? Subscribe to our 𝗳𝗿𝗲𝗲 𝗻𝗲𝘄𝘀𝗹𝗲𝘁𝘁𝗲𝗿 and have them delivered straight to your inbox. 👉 https://lnkd.in/gc5Duyzn #excel
-
I’ve been using Excel for over 25 years and I still believe there is so much to explore. Here are a few ways to keep up with the latest…⤵️ 👨🎨 Follow great creators: So many to name - make sure you jump on board and keep up with their content daily! 📰 Newsletters: Subscribe to Excel-focused newsletters to receive timely updates on new functionalities. I really great one is The Excel Dojo. You can find it at: https://lnkd.in/e7_RjbPY 🔎 Official Updates: Visit Microsoft's official Excel update logs or blogs to stay informed on the latest changes. 🧑🔧 Practice: Dedicate time weekly or monthly to explore and try out newly introduced features in Excel. 📖 Books: Buy the latest Excel guidebooks which are frequently updated with the latest version details. I have a stack I reference CONSTANTLY. 🧪 Trial & Error: Don't be afraid to experiment with unfamiliar tools or buttons to learn their functions. What are some ways you keep up with the world of Excel? Let us know in the comments below as we continue to build this amazing community! 💬 #excel #exceltips
-