Copilot in Excel: Supercharge Your Productivity (2023)

Copilot in Excel: Supercharge Your Productivity (2023)

13mGeneral2023-09-21

Authors

Jess Stratton

Jess Stratton

LinkedIn Learning Staff Author, Tech Consultant

Course details

Imagine being able to create sophisticated Excel spreadsheets and charts—and quickly glean insights for your stakeholders—using nothing more than a simple chat prompt. With Microsoft 365 Copilot, which brings the power of large language models (LLMs) to your favorite productivity apps, this can be your reality today. Join Jess Stratton as she shows beginners and experts alike how to use Copilot to radically simplify common Excel workflows.

Learning objectives
Learn how to get started with prompts, as well as what needs to be in place before you can activate Copilot.
Perform common Excel tasks (including sorting, filtering, and formatting) with chat prompts.
Get answers about your data using natural language queries.
Add columns using formulas.
Create charts, PivotCharts, and PivotTables using Copilot.

Skills covered

Microsoft CopilotAI Productivity ToolsSpreadsheetsMicrosoft ExcelArtificial Intelligence for BusinessBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off

Concepts

Excel and Microsoft 365 Copilot

  • Copilot, your own personal data advisor (now in Excel )
  • Get started and analyze your data
  • Insert columns with formulas
  • Insert charts and PivotTables
  • Avoid common gotchas