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 SHOULD YOU 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.
AREA 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
LEARNING OBJECTIVES
- Explain the benefits of using Copilot in Excel
- Write effective prompts to get accurate results
- Use Copilot to suggest and write formulas
- Sort, filter, format and clean data with Copilot
- Summarize data into PivotTables and PivotCharts
- Find trends, patterns and duplicates in your data
- Create new Excel files from existing files with Copilot Chat
WHO WILL BENEFIT?
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals
- Many different Users from many Fields
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.
- 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
- Explain the benefits of using Copilot in Excel
- Write effective prompts to get accurate results
- Use Copilot to suggest and write formulas
- Sort, filter, format and clean data with Copilot
- Summarize data into PivotTables and PivotCharts
- Find trends, patterns and duplicates in your data
- Create new Excel files from existing files with Copilot Chat
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals
- Many different Users from many Fields
Speaker Profile
Craig Brody
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 …
Upcoming Webinars
NEW Nacha Rule - Third-Party Sender (TPS) Roles and Respons…
Paying and Receiving Payments for Referrals: You Can Go to …
FDA Technology Modernization Action Plan (TMAP) and Impact …
Human Factors Usability Studies Following ISO 62366 and FDA…
Validation Statistics for Non-Statisticians
Construction Lending And Real Credit Administration: Evalua…
Thriving in a Hybrid Workplace: Keys to Leadership and Team…
Excel Power Skills: Master Functions, Formulas, and Macros …
Discover how Emotional Intelligence turns AI from a technic…
Batch Record Review and Product Release
Tattoos, hijabs, piercings, and pink hair: The challenges …
Handbook Overhaul 2026: Compliance, OBBB Act & Beyond
Copilot and HR: An Introduction for HR Professionals
Female to Female Hostility @Workplace: All you Need to Know
ChatGPT for HR - Build HR Policy Framework and Strategy
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
Major cGMP Issues: FDA Concerns in 2026
The Perfect Storm Coming to Healthcare: Value Based Care Me…
Fostering a Culture of Respect: Eliminating Gossip, Rumour…
Language is Code - Intro to AI - Generative AI - ChatGPT an…
Excel + AI: The Smart User's Guide to Faster, Easier Work w…
The Importance of the first 5 seconds when presenting
Managing Difficult Employee Conversations
ChatGPT and Project Management: Leveraging AI for Project M…
I-9 Audits: Strengthening Your Immigration Compliance Strat…
Pivot tables beginner to advanced + 20 advanced Pivot table…
Emotional Intelligence: Mastering the Emotions of Great Lea…
2026 Nacha Rules Changes (Part 1): Fraud Monitoring & Ops B…
Accounting For Non Accountants : Debit, Credits And Financi…
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Human Error Reduction Techniques for Floor Supervisors