Program
How to Use the VALUE Function in Excel
Convert text that represents a number, date, or time into an Excel numeric value, combine VALUE with text functions, and troubleshoot #VALUE! errors.
Latest Program Articles
Program
Analyze CSV and Excel Data with Copilot Studio Code Interpreter
Enable Copilot Studio code interpreter for uploaded or SharePoint CSV and Excel files, then prepare prompts, test calculations, and validate the results.
Program
Add Unstructured Knowledge Sources to a Copilot Studio Agent
Connect OneDrive, SharePoint, supported knowledge bases, or real-time Power Platform connectors to a Copilot Studio agent and test permission-aware answers.
Program
Use Unstructured Data as Copilot Studio Agent Knowledge
Add files, OneDrive or SharePoint folders, and supported knowledge-base connectors to a Copilot Studio agent while preserving permissions and testing retrieval quality.
Program
Copilot Connectors vs Power Platform Connectors in Copilot Studio
Compare indexed Copilot connectors with Power Platform connectors for Copilot Studio knowledge, live data, actions, security, latency, and hybrid agent designs.
Program
Add a Power Platform Knowledge Connector in Copilot Studio
Connect a Copilot Studio agent to supported enterprise data in real time, configure tables and authentication, test permissions, and troubleshoot preview connectors.
Program
Add a Microsoft 365 Copilot Connector to a Copilot Studio Agent
Use an administrator-configured Copilot connector as agent knowledge, set publishing authentication, test permission trimming, and compare indexed and real-time retrieval.
Program
Add Azure AI Search as a Copilot Studio Knowledge Source
Connect one Azure AI Search vector index to a Copilot Studio agent, choose a supported authentication method, configure citations, test retrieval, and account for private-network and permission requirements.
Program
How to Create a File Group in Microsoft Copilot Studio
Group uploaded files into one Copilot Studio knowledge source, add routing instructions, manage its contents, and understand the requirements and deletion behavior.
Program
Upload Files as Knowledge in Microsoft Copilot Studio
Add files as Copilot Studio knowledge, understand Dataverse and security requirements, use supported formats, write better descriptions, and test answers.
Program
How to Add Dataverse Tables as Knowledge in Copilot Studio
Connect Dataverse tables to a Copilot Studio agent, describe the data with synonyms and glossary terms, and configure searchable text and file columns.
Program
How to Rank Values in Excel from Highest to Lowest
Use RANK.EQ or the compatible RANK function to assign positions in Excel, switch between descending and ascending order, and handle tied values.
Program
How to Use the PRODUCT Function in Excel
Multiply numbers, cells, and ranges with Excel's PRODUCT function, compare it with the * operator, and understand how blanks and text are handled.
Program
How to Add SharePoint Knowledge to a Copilot Studio Agent
Connect a SharePoint site or list, preserve user permissions, configure filters and authentication, and use variable URLs for dynamic scope.
Program
Add Public Websites as Copilot Studio Knowledge Sources
Add and scope a public website knowledge source in Microsoft Copilot Studio, follow URL-depth rules, use safe runtime URL variables, and test grounded answers.
Program
How to Add Knowledge Sources in Microsoft Copilot Studio
Add and manage agent-level or topic-level knowledge in Copilot Studio, choose the right source type, write useful descriptions, and test grounded answers safely.
Program
n8n Basics: Nodes, Triggers, Expressions, and Data Flow
Learn how n8n workflows start, how JSON items move between nodes, how expressions reference dynamic values, and how to build and test a simple branching workflow.
Program
Copilot Studio Knowledge Sources: Types, Limits, and Settings
Compare Copilot Studio knowledge source types, understand classic and generative orchestration limits, configure grounding and web search, and test citations and permissions.
Program
How to Select a Preview Response Model in Copilot Studio
Change an agent's primary response model in Microsoft Copilot Studio, confirm administrator and regional access, and test a preview model safely before using it.
Program
How to Use Deep Reasoning in Microsoft Copilot Studio
Enable Deep Reasoning for a Copilot Studio agent, target it with the ?reason? keyword, test the added latency and credit use, and review executions in Activity.