How to Be an Excel Detective: Finding and Highlighting Formulas
Hi everyone, I recently wrote a blog post on some simple, yet powerful, techniques for anyone who works with Excel spreadsheets, especially those with complex data. I wanted to share a summary of it with this community, as it might be helpful to others who are looking to understand and protect their work. The post covers two main things: Quickly Revealing All Formulas: A simple keyboard shortcut (Ctrl + `) or the "Show Formulas" option can instantly reveal all formulas in a worksheet. This is a great way to quickly see how a spreadsheet is structured. Permanently Highlighting Formulas: The article shows how to use the "Find & Select" > "Formulas" feature to select all cells containing formulas and then permanently highlight them with a fill color. This visual cue can help prevent accidental edits and protect your data. Watch This in Action: For a step-by-step guide on how to use these techniques, you can watch the video on my https://www.youtube.com/@BIGurus. 🔗 https://youtu.be/1x-1dbqlWXk You can also read the full article here: https://medium.com/@anandsharad/how-to-be-an-excel-detective-finding-and-highlighting-formulas-fe9d4fdbc1b1 I'd be happy to answer any questions you have or discuss other Excel tips and tricks in the comments!
How to practice SC-200 content on an empty tenant
Hello, I am following the SC 200 course on Microsoft Learn. It is great and everything but my m365 business tenant is empty. I don't have VMs, logs, user activity or anything. I learned some KQL and microsoft provides some datasets for practice. Are there any such data I can load on my tenant for threat hunting and other SC-200 related practices or is there an isolated simulation environment I can use for learning?M365 Copilot Prompt-a-thon: A Hands-On Event for Government Innovators
Ready to supercharge your workflow with AI? Join us for Power Your AI Transformation with Microsoft Cloud — a dynamic, hands-on workshop designed exclusively for government professionals! Discover how to harness the power of Copilot in Microsoft 365 GCC to tackle real-world mission scenarios, boost productivity, and collaborate with experts and peers.🚀 Microsoft Edge Gets Smarter: Copilot with GPT-5, AI Podcast Creation & Advanced Security!
Big news for productivity and creativity lovers! 🎯 The latest Microsoft Edge update brings some game-changing features: ✅ Copilot Smart Mode powered by GPT-5 – Your AI assistant just got even smarter. 🎙 Create Podcasts with Copilot – Turn ideas into audio content effortlessly. 🎨 Generate Images & Videos directly in Edge – No extra tools needed! 🛡 AI-Powered Shield Against Scareware – Stay safe while you browse. I’ve created a detailed video on my YouTube channel where I explore these features in action and share tips on how to make the most of them. 👉 Watch it here: https://youtu.be/73KEDh2MDow What do you think about these updates? Which feature excites you the most? Let’s discuss in the comments! #MicrosoftEdge #Copilot #AI #Productivity #CyberSecurity #GPT5Register for the Cloud and AI Platforms FY26 Partner Playbook Walkthrough Replay and Q&A session
Join us for a replay and exclusive Q&A session on September 11, at 8:00 AM Pacific Time or 5:00 PM Pacific Time to learn about the exciting go-to-market (GTM) priorities and initiatives planned for FY26 across the Cloud and AI platforms solutions area, aligned to the System Integrator partner audience. We are excited to invite you to an exclusive session where we will unveil the FY26 Cloud & AI Platform Partner Playbook and guide you through any Q&A. This comprehensive guide is designed to help you leverage Microsoft's latest investments and strategies to grow your business and enhance customer engagement. What to Expect: Business Overview: Gain insights into the FY26 investments and strategic priorities. Customer Opportunities: Understand the growth drivers and market opportunities for FY26. Solution Plays: Learn how to migrate and modernize your estate, innovate with Azure AI apps and agents, and unify your data platform. Partner Skilling: Discover opportunities for partner skilling and certifications to enhance your capabilities. Why Attend? Exclusive Insights: Get a detailed overview of the playbook and how it can benefit your business. Interactive Sessions: Participate in discussions and Q&A sessions to address your specific needs and questions. We look forward to your participation and collaboration in driving mutual growth and success. Please register now to secure your spot. Can’t attend the live event? Register anyway to get notified when the event content is available on demand. Register here for the morning and evening session! When you join this meeting, your name, email address and/or phone number may be viewable by other session participants in the attendee list. By joining, you’re agreeing to this experience. Learn more at https://go.microsoft.com/fwlink/?LinkId=521839. This event may be recorded and shared publicly with others, including Microsoft’s global customers, partners, employees, and service providers. The recording may include your name and any questions you submit to Q&A. You may submit questions anonymously.Virtual Event | Becoming Frontier: Pitch and land the AI transformation story
Join us for a hands-on training designed to sharpen your AI transformation pitch. Over three days, you will dive into Microsoft’s latest executive, platform, business services, and security conversations, learn how to bring the Copilot and agentic story to life, and practice landing it with impact. With expert-led sessions, practical pitch decks, and live Q&A, you will leave with the confidence to guide customers through their AI journey and earn a shareable digital badge along the way. Americas | Tuesday, October 14, 9:00 AM - Thursday, October 16, 12:00 PM PDT Asia | Wednesday, October 15, 9:00 AM - Friday, October 17, 12:00 PM IST EMEA | Wednesday, October 15, 9:00 AM - Friday, October 17, 12:00 PM BST Register today!
EXCEL FORMULA HELP
I need help. I have attached the sheet I'm working on. I need to pull the data in column B (CLIENT) from the MAIN sheet to the respective individual sheet based on column E (PREPPER). For example, if the data in B4 says 'Jason Smith' and E4 says 'Jon'; I need it to go to the JON sheet in cell B4 but not show up on sheets JANE or MARLA. Help please!! Thank you! :)GPT-5 in Azure AI Foundry: The future of AI apps and agents starts here
OpenAI’s GPT-5 is available today in Azure AI Foundry. GPT-5 adds advanced capabilities to support agentic workflows, complex code synthesis, and safer, more flexible integrations. Ideal for: Unified reasoning + chat for end-to-end problem solving Agentic task mastery with multi-step tool use and auditable decisions, Frontier coding with minimal prompting Developer controls for depth, speed, verbosity Free-form function calling (no rigid JSON schemas) Safer completions for sensitive prompts Learn more here!
