Blog
Blog posts from members of the Microsoft community.
Most upvoted posts
No upvotes in this period yet.
- From Spreadsheets to Dataverse: A Field App Blueprint for Construction Teams · Radhika P. · 2026-11-16
How a builder running 40+ communities on separate spreadsheets moved to Dataverse and a Power Apps Canvas field app: the architecture, three hard lessons, and a phased MVP plan you can reuse in any industry. - What oversharing in SharePoint Online really is · Mirko Peters · 2026-11-15
Oversharing in SharePoint Online means content is reachable by more people than intended. Learn how sharing links and permissions cause it and which native Microsoft features to check first. - Adding an LLM Layer to a .NET Backend with Semantic Kernel · Reliqio · 2026-11-12
How we add AI features to existing .NET backends: Semantic Kernel, RAG on Azure AI Search, tested prompts, logging and a few guardrails. - XLOOKUP in Excel: Syntax, Examples and How It Beats VLOOKUP · Mirko Peters · 2026-11-12
XLOOKUP in Excel explained: the syntax, each argument, examples for exact, wildcard and last matches, multiple columns, and how it differs from VLOOKUP. - Windows 11 Safe Mode: How to Start It, Use It and Get Out Again · Mirko Peters · 2026-11-12
Windows 11 safe mode explained: three ways to boot into it, the F4, F5 and F6 choices, what to fix there, and how to leave it if the PC keeps booting back in. - Windows 11 ISO Download: The Official Way, Step by Step · Mirko Peters · 2026-11-12
Windows 11 ISO download from Microsoft: pick the right option, choose edition and language, verify the SHA-256 hash and stay away from unofficial copies. - Windows 11 Bootable USB: How to Create One Step by Step · Mirko Peters · 2026-11-12
Create a Windows 11 bootable USB with Microsoft's Media Creation Tool or by hand, fix the 4 GB file problem, and boot a PC from the drive without surprises. - What Is a Smart Factory? A Plain Explanation for Plant Managers · Mirko Peters · 2026-11-12
What is a smart factory? A plain explanation of what makes a plant smart, how the layers fit, what technology is involved and how a plant manager can start. - What-If Scenario Analysis in Production Planning: A Method · Mirko Peters · 2026-11-12
What if scenario analysis production planning means copying the plan, changing one assumption and comparing results. Learn the steps, data, tools and checks. - Top Value Stream Mapping Software: Criteria That Matter · Mirko Peters · 2026-11-12
What makes top value stream mapping software? Criteria on method, data, collaboration and scale, plus vendor questions and red flags for operations managers. - Smart Factory Technologies: A Plant Manager's Starter Guide · Mirko Peters · 2026-11-12
Smart factory technologies explained as layers: sensing, connectivity, data, analytics, models and security. A plain guide for plant managers on where to start. - Smart Factory Software ERP Integration: A Plant Manager's Guide · Mirko Peters · 2026-11-12
Smart factory software ERP integration comes down to which data moves, in which direction and how fast. A plain guide for plant managers with a checklist. - How to Set Up Microsoft Authenticator (Personal and Work Accounts) · Mirko Peters · 2026-11-12
Set up Microsoft Authenticator for a personal or work account: QR code steps, what to do if scanning fails, and how backup and a new phone work, step by step. - Production Simulation for Disruptions and Product Mix Changes · Mirko Peters · 2026-11-12
Production simulation disruptions: test breakdowns, absences, late material and product mix changes in a model before they hit your line. A practical guide. - Production Planning and Control Software: What to Look For · Mirko Peters · 2026-11-12
Production planning and control software plans, schedules and tracks orders. See what it covers, where ERP stops and how planners can choose the right tool. - Product Mix Planning in Manufacturing: Decide What to Make · Mirko Peters · 2026-11-12
Product mix planning in manufacturing decides what to build, how much and in which pattern when capacity is limited. Learn the method, the checks and the traps. - Power Query in Excel: Import, Clean, Merge and Refresh Data · Mirko Peters · 2026-11-12
Power query in Excel imports and cleans data without formulas. Learn where to find it, From Table/Range, Applied Steps, merge vs append, loading and refresh. - Power Automate formatDateTime: Syntax, Format Strings and Examples · Mirko Peters · 2026-11-12
Power Automate formatDateTime explained: syntax, the format strings that matter, time zones with convertTimeZone, and the mistakes behind wrong dates and times. - Outlook Search Not Working? Fixes That Actually Work · Mirko Peters · 2026-11-12
Outlook search not working or showing no results? Check scope, indexing status and Windows Search, then rebuild the search catalog and repair damaged data. - Outlook Dark Mode: How to Turn It On and Fix White Emails · Mirko Peters · 2026-11-12
Outlook dark mode explained: how to turn it on in new Outlook, classic Outlook, the web, Mac and mobile, and how to fix a white message background in dark mode. - OneDrive Not Syncing? Fixes for Stuck, Pending and Paused Sync · Mirko Peters · 2026-11-12
OneDrive not syncing? Read the icon first, then check pause, sign-in, open files, names, path length and big files before you reset OneDrive as a last step. - OEE Software: How to Choose It and Roll It Out Without Regret · Mirko Peters · 2026-11-12
OEE software records stops, speed and scrap per machine. Learn how to pick it, pilot it, connect it to ERP and older machines and avoid the common traps. - MRP vs APS: What Each Does and When MRP Is Not Enough · Mirko Peters · 2026-11-12
MRP vs APS: MRP works out what material to order and when, APS works out what the plant can actually run. See where MRP breaks and how to add APS in steps. - Modular Production Planning Software: Which Modules to Add First · Mirko Peters · 2026-11-12
Modular production planning software lets a growing factory add planning layers step by step. See which modules exist, what they share and what to add first. - Map Network Drive in Windows 11: File Explorer, net use and PowerShell · Mirko Peters · 2026-11-12
How to map a network drive in Windows 11 with File Explorer, net use or PowerShell, keep it after sign-in, fix common errors and roll it out to many users. - Manufacturing Simulation Software: How to Evaluate and Choose · Mirko Peters · 2026-11-12
Manufacturing simulation software is easier to choose with a scorecard than a ranking. Criteria, test questions and a fair comparison method for plant managers. - Manufacturing Simulation KPI Tracking: Compare Scenarios Fairly · Mirko Peters · 2026-11-12
Manufacturing simulation KPI tracking starts with a few KPIs defined like your plant defines them. Learn how to run scenarios, read results and report them. - Manufacturing Optimization in Aerospace: What to Optimize First · Mirko Peters · 2026-11-12
Manufacturing optimization in aerospace starts with hard constraints, clear goals and explainable plans. A guide for managers choosing optimization software. - Manufacturing KPI Dashboard: What to Show and How to Build It · Mirko Peters · 2026-11-12
A manufacturing KPI dashboard works when each number has an owner and an action. Learn which KPIs to pick, how to define them and how to build it in Power BI. - Install the Exchange Online PowerShell Module (Step by Step) · Mirko Peters · 2026-11-12
Install the Exchange Online PowerShell module with Install-Module ExchangeOnlineManagement: requirements, scope, version check, updates and error fixes. - INDEX MATCH in Excel: Formula, Examples and Common Errors · Mirko Peters · 2026-11-12
INDEX MATCH in Excel explained: the formula, how each function works, left and two-way lookups, multiple criteria and common errors, plus a VLOOKUP comparison. - How to Use SharePoint: A Beginner's Guide to Sites and Files · Mirko Peters · 2026-11-12
How to use SharePoint as a beginner: what it is used for, how sites, libraries and lists fit together and the ten first tasks, from upload to sharing. - How to Use Power Automate: Build, Test and Fix Your First Flow · Mirko Peters · 2026-11-12
How to use Power Automate: pick a flow type, build a cloud flow with a trigger and actions, test it, read the run history and fix the most common failures. - How to Use Copilot in Excel: Prompts, Formulas, Charts and Fixes · Mirko Peters · 2026-11-12
How to use Copilot in Excel: open it, pick a mode, ask for insights, formulas, charts and PivotTables, and fix the case where the Copilot button is missing. - How to Upgrade to Windows 11: Steps, Requirements and Rollback · Mirko Peters · 2026-11-12
How to upgrade to Windows 11 from Windows 10: check requirements, use Windows Update, the Installation Assistant or install media, and roll back within 10 days. - How to Unhide All Rows in Excel (Including Row 1) · Mirko Peters · 2026-11-12
How to unhide all rows in Excel: select the whole sheet, then Home, Format, Hide & Unhide, Unhide Rows. Also row 1, filtered rows, a macro and stubborn cases. - How to Turn Off Copilot in Word (Windows, Mac and Admin Options) · Mirko Peters · 2026-11-12
How to turn off Copilot in Word: the Enable Copilot checkbox on Windows and Mac, what it affects, what to do with a work account, and how admins control it. - How to Take a Screenshot on Windows 11: Every Method Explained · Mirko Peters · 2026-11-12
How to take a screenshot on Windows 11: Windows+Shift+S, Print Screen, Snipping Tool, delay, video clips, editing, and fixes when a screenshot goes missing. - How to Sync OneDrive: Set Up, Choose Folders, Files On-Demand · Mirko Peters · 2026-11-12
How to sync OneDrive on Windows: sign in, pick the folder location, choose which folders sync, use Files On-Demand and sync a SharePoint library the right way. - How to Share Your Outlook Calendar: Permissions, Edit and Delegate · Mirko Peters · 2026-11-12
How to share Outlook calendar access in new Outlook, on the web, on Mac and mobile: pick the right permission, share outside your organization and stop sharing. - How to Set Out of Office in Outlook: Steps for Every Version · Mirko Peters · 2026-11-12
How to set out of office in Outlook with automatic replies: steps for Windows, web, Mac and mobile, plus shared mailboxes and fixes when replies don't send. - How to Schedule an Email in Outlook: Every Version Explained · Mirko Peters · 2026-11-12
How to schedule an email in Outlook: Schedule send in new Outlook, web and Mac, Delay Delivery in classic Outlook, where drafts wait, and when scheduling fails. - How to Reset OneDrive on Windows: The Command and What Happens · Mirko Peters · 2026-11-12
How to reset OneDrive on Windows with the onedrive.exe /reset command: when to use it, what it does to your files, what to do afterward and how to unlink. - How to Remove Duplicates in Excel: Command, Formulas, Power Query · Mirko Peters · 2026-11-12
How to remove duplicates in Excel: use Data, Remove Duplicates, or keep the original data with UNIQUE, formulas and Power Query. Steps, limits and mistakes. - How to Record a Teams Meeting: Steps, Rules, Storage · Mirko Peters · 2026-11-12
How to record a Teams meeting: start and stop it, who may record, where the file is saved, how to share it, and what to check when the Record button is missing. - How to Recall an Email in Outlook: Windows, Mac, Web and Mobile · Mirko Peters · 2026-11-12
How to recall an email in Outlook: the exact steps for new Outlook, classic Outlook, Mac and mobile, who can use recall, and what to do when it fails. - How to Password Protect an Excel File (and Sheets) Step by Step · Mirko Peters · 2026-11-12
How to password protect an Excel file: File, Info, Protect Workbook, Encrypt with Password. Plus sheet and workbook protection, lost passwords and sharing tips. - How to Open BIOS in Windows 11 (UEFI Firmware Settings) · Mirko Peters · 2026-11-12
How to open BIOS in Windows 11: use Settings and Advanced startup, the boot key at power-on or Surface buttons, and what to do if Windows won't start. - How to Merge Cells in Excel (and Unmerge Without Losing Data) · Mirko Peters · 2026-11-12
How to merge cells in Excel with Merge & Center, what happens to your data, how to unmerge safely, and what to use instead, such as CONCAT and TEXTJOIN. - How to Make an Email Group in Outlook (Contact List Steps) · Mirko Peters · 2026-11-12
How to make an email group in Outlook with a contact list or contact group: steps for new Outlook, classic, web and Mac, and when a Microsoft 365 group fits. - How to Lock Cells in Excel: Protect Formulas, Allow Input · Mirko Peters · 2026-11-12
How to lock cells in Excel: unlock the input cells, then use Review, Protect Sheet. Also hide formulas, let people edit set ranges, and fix common problems. - How to Integrate MES with ERP: A View From the Shop Floor · Mirko Peters · 2026-11-12
How to integrate MES with ERP from the MES side: what the floor needs from ERP, what ERP needs back, how to match master data and which project traps to avoid. - How to Freeze a Row in Excel: Top Row, Several Rows, Columns · Mirko Peters · 2026-11-12
How to freeze a row in Excel: use View, Freeze Panes, Freeze Top Row or select the cell below the rows you want to keep. Also columns, unfreezing and fixes. - How to Factory Reset Windows 11: Every Method Explained · Mirko Peters · 2026-11-12
How to factory reset Windows 11 from Settings or recovery: keep or remove files, cloud or local reinstall, BitLocker keys, backup and what to do afterwards. - How to Encrypt Email in Outlook: Purview, S/MIME and Do Not Forward · Mirko Peters · 2026-11-12
How to encrypt email in Outlook with Purview Message Encryption or S/MIME: steps per version, what recipients see and what to check if Encrypt is missing. - How to Enable Secure Boot in Windows 11 (Check, Fix, Verify) · Mirko Peters · 2026-11-12
How to enable Secure Boot in Windows 11: check the current state, open UEFI settings, switch from legacy mode, convert MBR to GPT and verify it in Intune. - How to Enable Macros in Excel (Windows, Mac and Blocked Files) · Mirko Peters · 2026-11-12
How to enable macros in Excel: use Enable Content for one file, Unblock for downloaded files, or the Trust Center for all. Includes Mac, web and policy limits. - How to Disable OneDrive on Windows: Pause, Unlink, Uninstall · Mirko Peters · 2026-11-12
How to disable OneDrive on Windows: pause, quit, unlink or stop folder backup first, then hide or uninstall it, plus the policy admins use to turn it off. - How to Disable BitLocker: Suspend or Decrypt a Drive · Mirko Peters · 2026-11-12
How to disable BitLocker: when to suspend protection, when to decrypt it with Disable-BitLocker or manage-bde -off, and what changes on managed devices. - How to Delete a SharePoint Site and Restore It Within 93 Days · Mirko Peters · 2026-11-12
How to delete a SharePoint site as a site owner or admin, what disappears with it, how the 93-day Deleted sites list works and how to restore a site fast. - How to Delete a Page in Word: Full, Blank and Last Pages · Mirko Peters · 2026-11-12
How to delete a page in Word: select it with Ctrl+G and \\page, clear page breaks and section breaks, and fix the stubborn blank last page that won't go away. - How to Create a Drop-Down List in Excel (Data Validation) · Mirko Peters · 2026-11-12
How to create a drop down list in Excel with Data Validation: build the list, set the source, add alerts, keep it up to date, and fix common problems. - How to Create a SharePoint Site: Team vs Communication Site · Mirko Peters · 2026-11-12
How to create a SharePoint site in minutes: choose a team or communication site, fill in the settings that can't be changed later and add owners and members. - How to Create a Pivot Table in Excel: Steps, Fields and Refresh · Mirko Peters · 2026-11-12
How to create a pivot table in Excel: prepare the data, use Insert > PivotTable, drag fields, add slicers, then refresh and fix problems. Steps for beginners. - How to Create a Folder in SharePoint: Steps, Rules and Tips · Mirko Peters · 2026-11-12
How to create a folder in SharePoint: use + New, Folder in a document library, name it, then rename, move and share it. Plus fixes when New Folder is missing. - How to Change Your Signature in Outlook on Every Device · Mirko Peters · 2026-11-12
How to change a signature in Outlook on Windows, the web, Mac and mobile, plus defaults, multiple signatures and why an edit sometimes doesn't show up. - How to Change the Default Font in Outlook (Windows, Web and Mac) · Mirko Peters · 2026-11-12
How to change the default font in Outlook for new messages, replies and plain text on Windows, web and Mac, plus fixes for a font that won't stay set. - How to BCC in Outlook: Show the Bcc Field and Send Privately · Mirko Peters · 2026-11-12
How to BCC in Outlook: show the Bcc field in new Outlook, classic and Mac, check Bcc in Sent Items, and avoid recipient limits, spam flags and reply-all slips. - How to Add OneDrive to File Explorer (and Fix It When Missing) · Mirko Peters · 2026-11-12
How to add OneDrive to File Explorer: start the app, sign in, show the navigation pane, pin the folder and fix a missing OneDrive entry, step by step. - How to Add Copilot to Outlook: License, Setup and Fixes · Mirko Peters · 2026-11-12
How to add Copilot to Outlook: you need a Microsoft Copilot license, a supported Outlook app and an Exchange Online mailbox. Steps, where it appears and fixes. - Find Duplicates in Excel: Highlight, Count and List Them · Mirko Peters · 2026-11-12
Find duplicates in Excel with conditional formatting, COUNTIF flags, UNIQUE, Power Query and cross-sheet checks, plus how to spot near matches before deleting. - Factory Scheduling Software for Shift Planning: How to Choose · Mirko Peters · 2026-11-12
Factory scheduling software and shift planning are two jobs. Learn how they differ, how they share one capacity calendar and what to check before you buy. - Enable Remote Desktop in Windows 11: Setup and Safe Access · Mirko Peters · 2026-11-12
Enable Remote Desktop in Windows 11: which editions can host, the Settings steps, adding users, connecting from other devices and keeping RDP off the internet. - Disable Copilot in Windows 11: Uninstall, Block and Policy Options · Mirko Peters · 2026-11-12
Disable Copilot in Windows 11 by uninstalling the app, blocking it with AppLocker or using the RemoveMicrosoftCopilotApp policy, and why the old policy fails. - Digital Twin vs Simulation Tools: How to Choose for Your Plant · Mirko Peters · 2026-11-12
Digital twin vs simulation tools: what separates them, which questions each one answers, and how plant managers can choose without buying more than they need. - Digital Twin Software for Manufacturing: A Buyer's Checklist · Mirko Peters · 2026-11-12
Digital twin software for manufacturing keeps a model in sync with live data. A checklist to compare platforms, packaged tools, security, cost and upkeep. - Critical Process Died in Windows 11: Causes and Fixes · Mirko Peters · 2026-11-12
Critical process died in Windows 11 means a core system process stopped and Windows crashed. Fix it in order: safe mode, drivers, updates, SFC and DISM. - Connect to Exchange Online PowerShell: Step-by-Step Guide · Mirko Peters · 2026-11-12
Connect to Exchange Online PowerShell with Connect-ExchangeOnline: requirements, interactive sign-in, MFA, partner and unattended options, and error fixes. - Conditional Formatting in Excel: Rules, Formulas and Examples · Mirko Peters · 2026-11-12
Conditional formatting in Excel colors cells by rule. Learn Highlight Cells, Top/Bottom, data bars, color scales, icon sets, formulas, order and clearing. - How to Clear Teams Cache on Windows and Mac (and When Not To) · Mirko Peters · 2026-11-12
Clear the Teams cache on Windows and Mac for new and classic Teams: what it fixes, what it does not, and which checks to run before you delete anything. - Can't Upgrade to Windows 11? Find the Cause and Fix It · Mirko Peters · 2026-11-12
Why can't I upgrade to Windows 11? Check TPM 2.0, Secure Boot, UEFI, CPU, RAM, storage and the Windows 10 version, with fixes and options if the PC is blocked. - BitLocker Recovery Key: Where to Find It (Account, Entra, IT) · Mirko Peters · 2026-11-12
Find your BitLocker recovery key in your Microsoft account, work account, a printout or a USB drive, and see how admins retrieve it from Entra ID or Intune. - Automotive Production Planning: Leveling, Sequencing, Changes · Mirko Peters · 2026-11-12
Automotive production planning turns customer schedules into a leveled, feasible plan. See the planning levels, leveling, sequencing and change handling. - Audio Renderer Error in Windows 11: How to Fix It · Mirko Peters · 2026-11-12
Fix the audio renderer error in Windows 11, the YouTube message to restart your computer: replug the device, restart audio services, update the audio driver. - APS vs MES: Differences, Overlaps and How They Work Together · Mirko Peters · 2026-11-12
APS vs MES in plain terms: one plans a feasible schedule ahead, the other records and controls execution. See where they overlap and which gap to close first. - Advanced Planning and Scheduling Software: How to Evaluate APS · Mirko Peters · 2026-11-12
Advanced planning and scheduling software builds schedules that respect real limits. Learn how to define your need, compare APS tools and test one on your data. - How to write a test case in plain English that an AI agent can run · Mirko Peters · 2026-11-11
Write test cases in plain English that an AI agent can run: one behavior per test, one action per step, named elements and a clear, checkable expected result. - Who deleted this file? Searching SharePoint audit logs in Purview · Mirko Peters · 2026-11-11
Who deleted a file? The SharePoint audit log in Microsoft Purview answers it: set the date range, search the file operations and read the acting user. - Who should be allowed to create SharePoint sites? · Mirko Peters · 2026-11-11
Who can create SharePoint sites? By default, all users. Learn the three controls to restrict site creation and how to decide who gets the right to create sites. - Which regression tests should you automate first? A decision guide · Mirko Peters · 2026-11-11
Which tests to automate first? Start with business-critical, frequently run, stable regression tests. Use five criteria and a simple scoring matrix to decide. - What can Microsoft 365 Copilot actually see in SharePoint? · Mirko Peters · 2026-11-11
What can Copilot access in SharePoint? Only content the signed-in user can already open. See why oversharing becomes visible, and what to check before rollout. - Unit, integration and end-to-end tests: where AI helps most · Mirko Peters · 2026-11-11
Unit vs integration vs end to end tests: what each checks, how many to write, and where AI helps most, from drafting unit tests to reviewing browser flows. - How to test AI agents and Copilot extensions in a repeatable way · Mirko Peters · 2026-11-11
How to test AI agents in a repeatable way: build a test set, pick graders, score tool calls and track regressions, with a Copilot Studio example for QA leads. - Teams with no owner: how to find them and assign new owners · Mirko Peters · 2026-11-11
Teams with no owner cannot be managed or renewed. Find ownerless teams in the admin center, assign new owners and set the Microsoft ownerless group policy. - Teams shared channels and SharePoint: where the files really live · Mirko Peters · 2026-11-11
Teams shared channel SharePoint basics: each shared or private channel gets its own site, with its own member list. See where files live and who can open them. - Version history is filling SharePoint storage: how to trim it safely · Mirko Peters · 2026-11-11
SharePoint version history storage can be trimmed safely: check the limits, run a what-if report, then trim with Automatic mode while retention stays protected. - SharePoint path length and file name limits: fix them before you migrate · Mirko Peters · 2026-11-11
The SharePoint URL length limit is 400 characters for the decoded file path. Find long paths and invalid names before you migrate with this checklist. - SharePoint unique permissions limit: what happens when you hit it · Mirko Peters · 2026-11-11
SharePoint unique permissions limit: 50,000 per library, 5,000 recommended. Learn how scopes are counted, what happens near the limit and how to stay below it. - Replacing SharePoint subsites with hub sites: a migration guide · Mirko Peters · 2026-11-11
Plan the move from SharePoint subsites to hub sites: why flat sites work better, how to promote each subsite to its own site, and how to connect the new sites. - SharePoint storage full? How to find what is using your quota · Mirko Peters · 2026-11-11
Build a SharePoint storage report: read the quota, rank sites by storage used, check versions and recycle bins, then free space with Microsoft's own options.