How to Build a No-Code Business Workflow in Microsoft 365
In today’s fast-paced digital workplace, organizations are constantly looking for ways to optimize processes without heavy reliance on IT or expensive developers. Luckily, Microsoft 365 offers a robust ecosystem of no-code tools that empower anyone—from business managers to project leads—to design and automate workflows with ease. With tools like Power Automate, Power Apps, SharePoint, and Teams, you can streamline tasks, improve collaboration, and boost productivity without writing a single line of code. Here’s a step-by-step guide to building your first no-code workflow in Microsoft 365. https://dellenny.com/how-to-build-a-no-code-business-workflow-in-microsoft-365/Staying Connected on the Road How Travelers Can Make the Most of Microsoft Teams
Traveling is exciting—new places, new cultures, and new adventures. But if you’re someone who works remotely, studies while traveling, or just needs to stay connected with your team, staying productive on the road can be tricky. That’s where Microsoft Teams becomes a true travel companion. Here’s how I’ve been using Teams to balance work and adventure while hopping across cities and time zones—and how you can do it too: https://dellenny.com/staying-connected-on-the-road-how-travelers-can-make-the-most-of-microsoft-teams/
Extract 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?
Unformatting 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.Advanced 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/Automating 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/Disabling 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 BSC
