247Compliance appLinks, recordings and certificates
Open
Questions? Call +1-661-336-9555 Group training quotes Get the app
ON-DEMAND Software

Using Copilot in Microsoft Excel

Learn to use Microsoft Copilot in Excel to write formulas, sort and filter data, build PivotTables, clean up lists and find trends, with tips for better prompts.

FormatRecorded sessionWatch any time
Length60 minutes
Craig Brody Speaker Craig Brody Software trainer and consultant · Craig Brody, LLC · Trainer for Wharton and Penn Carey Law
Talk to an expertAsk an expertQuestions about this topic

Overview

Copilot, Microsoft's AI assistant, can calculate, manage and summarize data for you in Excel. This one-hour Copilot in Excel training shows how it helps you finish reports, spreadsheets, charts and lists in less time.

Through several live demonstrations, you'll see how to write prompts that get useful results, have Copilot suggest and write formulas, sort and filter large lists, work with tables, and summarize data into PivotTables and PivotCharts. The session also shows Copilot formatting and cleaning data, finding trends, patterns and duplicates, and using Copilot Chat to create new Excel files from existing ones.

Why attend: Many routine Excel tasks take longer than they should. Seeing Copilot at work on real tasks helps you decide where it can save you time and raise your productivity. The session suits managers, business professionals, administrative staff, legal professionals and Excel users from many other fields.

What’s covered

  • Overview and benefits of Copilot in Excel
  • Tips for writing effective Copilot prompts
  • Automating tasks in Excel with Copilot
  • Having Copilot suggest and write formulas
  • Sorting and filtering data in a large list
  • Working with tables
  • Summarizing data into PivotTables and PivotCharts
  • Formatting and cleaning up data in a list
  • Finding trends, patterns and duplicates
  • Using Copilot Chat to create new Excel files from other files

Who should attend

ManagersBusiness professionalsAdministrative personnelLegal professionals

What you get

CertificateEmailed to each attendee after the session.
HandoutsSlides and checklists to reuse with your team.

About the speaker

Craig Brody
Craig Brody
Software trainer and consultant · Craig Brody, LLC

Craig Brody operates Craig Brody, LLC, a business that provides software training and consulting services. Craig has trained numerous employees, managers, executives, and students in various application software, including Microsoft 365 Copilot and Adobe Acrobat Pro. He conducts and facilitates in-person, online, and recorded training workshops for professionals in accounting, business, management, and law. Craig also conducts workshops, classes, and consulting services for the University of Pennsylvania's Wharton Business School, Penn Carey Law School, law firms, accounting associations, and accreditation providers. His services include spreadsheet analysis, design and troubleshooting, software programming, consulting, published course guides, recorded courseware videos, and other reference materials.

All webinars by Craig Brody →
From$219On-demand · watch any time Enroll now