microsoft 365
1871 TopicsExtract user access to Cloud Apps categories.
I’m having some issues with getting report data out of Defender for Cloud App. Short version is I want to get a report (or at the very least an export) of all users accessing sites in the Generative AI category. I can do this manually by following these steps: Open Cloud Discovery Click Discovered apps Enter Gnerative AI in the browser by category I now get a list of discovered sites but to get a list of users who have accessed them I have to: Click each app one at a time In each click Cloud app usage Click Users And finally export all users Imagine how long with would take for a category that has a high amount of usage and how inefficient this would be to provide monthly reporting. I tried to find a way to see in one step user activity for one Cloud App category, but I cannot. Any idea?31Views0likes2CommentsUnformatting Header/Tables on WORD after Updated Build 2508
Unformatting Header/Tables on WORD after Updated to Microsoft® Word for Microsoft 365 MSO (Version 2508 Build 16.0.19127.20192) 64-bit (Current Channel) with OS Windows 11 Pro Version 10.0.26100 Build 26100 Hi Community, I am writing to you today regarding a critical and widespread issue that is currently paralyzing our operations. Over the past two weeks, all of our Microsoft Word documents, including those created as far back as 2014, are displaying significant unformatting problems across every machine in our company. This issue affects our entire document repository and prevents us from reliably converting documents to PDF for our clients, since then we have been manually formatting the headers, tables, with the help of a feature called Gridlines. We have performed extensive internal troubleshooting and have been unable to resolve the issue. Our tests show that this problem is not present in previous versions of the software. We have isolated the issue to our current operating environment, as it affects all user profiles and machines uniformly.8Views0likes0CommentsAdvanced Excel Formulas for Business Analysis
Microsoft Excel remains one of the most powerful tools for business analysis. Beyond simple data entry and arithmetic, Excel’s advanced formulas help analysts uncover trends, automate reporting, and drive better decision-making. Mastering these formulas can save hours of work and unlock insights hidden within raw data. In this blog, we’ll explore some of the most impactful advanced Excel formulas for business analysis, complete with practical use cases. https://dellenny.com/advanced-excel-formulas-for-business-analysis/10Views0likes0CommentsAutomating Data Entry in Excel Using Power Query
Manually entering or cleaning data in Excel can be one of the most repetitive and error-prone tasks in any workflow. Whether you’re consolidating sales reports, transforming survey results, or pulling in system-generated exports, you often spend more time preparing the data than actually analyzing it. That’s where Power Query comes in. Built right into Excel (and also available in Power BI), Power Query allows you to automate data entry, transformation, and consolidation. Instead of repeating the same copy-paste and formatting tasks every week, you can set up a process once and reuse it whenever new data arrives. https://dellenny.com/automating-data-entry-in-excel-using-power-query/13Views0likes0CommentsDisabling Microsoft AutoUpdate
I have a customer with a Mac mini M4 with multiple user accounts. Each user has access to Office 365 apps, Outlook, Word, Excel. I have disabled Automatic Updates in the AutoUpdate app. This has not stopped app from showing updates are available. I want the update app to not open when updates are available. My question is what can I do to stop there update app from opening but still have it available for manual checking and updating. Thanks Len Levin BSC62Views0likes2CommentsBest Practices for Sharing Community Updates with Microsoft 365
Hello, I manage an online community and use Microsoft 365 to keep members informed by posting announcements in Teams, storing patch notes and FAQs on SharePoint, and automating alerts with Power Automate. This workflow worked well for our latest update (shared on [https://nullsbrawl.tech/](https://nullsbrawl.tech/)), but I’d appreciate suggestions on improving SharePoint design for better engagement, automating updates more efficiently, and tracking which members read the announcements.9Views0likes0CommentsHow to Create Reusable Templates in Word, Excel, and PowerPoint
Templates are time-savers. Instead of recreating the same document, spreadsheet, or presentation layout every time, you can design it once and reuse it whenever you need. Microsoft Word, Excel, and PowerPoint all support custom templates, helping you streamline your work and keep your materials consistent. In this post, we’ll walk through how to create and save reusable templates in each application. https://dellenny.com/how-to-create-reusable-templates-in-word-excel-and-powerpoint/18Views0likes0CommentsBeginner’s Guide to Microsoft Teams: Chat, Meetings, and Channels
If you’re new to Microsoft Teams, the platform might feel a little overwhelming at first. It’s packed with tools for messaging, video calls, collaboration, and file sharing—all in one place. But once you get the hang of the basics, it becomes an incredibly powerful tool for work, school, or personal projects. In this beginner-friendly guide, we’ll cover the core features: chat, meetings, and channels. These three areas form the foundation of how Teams works. https://dellenny.com/beginners-guide-to-microsoft-teams-chat-meetings-and-channels/20Views0likes0CommentsMastering Keyboard Shortcuts Across the Microsoft 365 Suite
In today’s fast-paced digital workplace, efficiency is everything. Whether you’re crunching numbers in Excel, drafting a report in Word, analyzing emails in Outlook, or delivering a presentation in PowerPoint, every second counts. That’s where keyboard shortcuts come in. Instead of reaching for your mouse, memorizing a few key combinations can help you navigate Microsoft 365 with ease. Here’s a breakdown of the most useful keyboard shortcuts across the suite. https://dellenny.com/mastering-keyboard-shortcuts-across-the-microsoft-365-suite/20Views0likes0CommentsMoving from Office 2016/2019 to Microsoft 365: What Changes?
Microsoft’s cloud-era strategy has made Microsoft 365 more than just “Office in the cloud” — it introduces a shift in licensing, update cadence, collaborative features, and more. Below are the key differences you’ll notice, the benefits, and also possible trade-offs to consider. https://dellenny.com/moving-from-office-2016-2019-to-microsoft-365-what-changes/9Views0likes0Comments