Make Excel easier using Copilot, the Microsoft AI tool built for Microsoft Office. Tasks that take hours to complete can be done in minutes and using natural language AI prompts. Know what tasks Copilot can do, how the tasks work, and how to generate prompts that will get the results you need. Succinct, colorful, and in an outline style format for finding answers fast, this 6 page laminated guide shows you the fantastic time-saving tools, plus how far Copilot can go with info on other AI options for deeper analysis. Author Andrew McLeod, a writer, and statistics and computer science expert working in AI since 2022 uses his Excel and AI knowledge to help you with the best notes an expert can give for a great price. Add this desktop reference to your workplace AI toolbox.
6 page laminated reference guide includes:
What is Copilot? Chat Interface Three Interacting ComponentsFeaturesCapabilitiesCopilot in Excel vs. Copilot App Desktop vs. Excel for the Web Copilot in Excel Edit with Copilot Model Selection Select Sources WebWorkReferencingCells & RangesTables WorksheetsChartsOperations Formula creation Column creation AggregationData retrieval & querying Summarization & explanation Other CapabilitiesData RequirementsM365 Copilot Excel Agent NotebooksPagesOffice Agent Translate Business Intent into AI Formulas Core Prompt Components Prompt construction example IterationBest Practices for Prompting Prompt Gallery SpecificityConstraint Framing Structured Inputs Role Assignment Output & Source Validation LimitationsCopilot in Excel Web Connectivity Office Agent NotebooksPagesUpdatesCopilot Analyst Copilot Researcher Beyond Copilot Add-ins ChatGPTClaude by Anthropic for Excel Shortcut AI Julius