Excel now does far more than store and calculate data. With Copilot and AI in Excel, the spreadsheet can automate routine tasks, surface insights and help forecast trends. This 120-minute Copilot in Excel training makes these features approachable for every user.
Working through real-world scenarios, you'll see why converting lists into tables matters, how to write clear, detailed prompts that get good results, and how Copilot can help with complex functions, extract values and compare lists. You'll also build PivotTables and charts with AI, apply conditional formatting with natural language, and automate tasks without writing VBA yourself.
The session closes with the requirements and limitations of Copilot, a comparison of Copilot and ChatGPT, and an honest look at whether Copilot is right for you.
WHY SHOULD YOU ATTEND?
Whether you are a beginner or an advanced user, and whether you work in accounting, administration or data analytics and visualization, Copilot can help you solve Excel problems without asking colleagues for help. You may already be using some AI features in Excel without realizing it.
The session suits accountants, auditors, financial, data, business, sales, marketing and HR analysts, payroll specialists, assistants, office and project managers, recruiters, managers at all levels and small business owners.
AREA COVERED
- Why you should convert lists into tables
- Writing clear, detailed prompts for the best results from AI tools
- Getting help with complex functions from Copilot
- Automating tasks without knowing VBA
- Conditional formatting with natural language queries
- PivotTables and charts with AI
- Requirements and limitations of Copilot
- Comparing Copilot and ChatGPT
- Is Copilot for me?
LEARNING OBJECTIVES
- Recognize AI features in Excel you may already be using
- Use Copilot in Excel to solve real-world data analytics problems
- Create functions, extract values and compare lists with AI
- Build PivotTables and charts using AI
- Automate tasks with Copilot-generated VBA code, even if you have never written any
- Explain the requirements and limitations of Copilot
- Compare Copilot with ChatGPT
WHO WILL BENEFIT?
• Accountants and auditors
• Financial Analysts
• Payroll Specialists
• Data Analysts / Business Analysts
• Administrative or Executive Assistants
• Office Managers / Project Managers
• Sales Analysts / Marketing Analysts
• HR Analysts
• Recruiters (for data tracking)
• Managers (all levels)
• Small Business Owners
Whether you are a beginner or an advanced user, and whether you work in accounting, administration or data analytics and visualization, Copilot can help you solve Excel problems without asking colleagues for help. You may already be using some AI features in Excel without realizing it.
The session suits accountants, auditors, financial, data, business, sales, marketing and HR analysts, payroll specialists, assistants, office and project managers, recruiters, managers at all levels and small business owners.
- Why you should convert lists into tables
- Writing clear, detailed prompts for the best results from AI tools
- Getting help with complex functions from Copilot
- Automating tasks without knowing VBA
- Conditional formatting with natural language queries
- PivotTables and charts with AI
- Requirements and limitations of Copilot
- Comparing Copilot and ChatGPT
- Is Copilot for me?
- Recognize AI features in Excel you may already be using
- Use Copilot in Excel to solve real-world data analytics problems
- Create functions, extract values and compare lists with AI
- Build PivotTables and charts using AI
- Automate tasks with Copilot-generated VBA code, even if you have never written any
- Explain the requirements and limitations of Copilot
- Compare Copilot with ChatGPT
• Accountants and auditors
• Financial Analysts
• Payroll Specialists
• Data Analysts / Business Analysts
• Administrative or Executive Assistants
• Office Managers / Project Managers
• Sales Analysts / Marketing Analysts
• HR Analysts
• Recruiters (for data tracking)
• Managers (all levels)
• Small Business Owners
Speaker Profile
Nabil Mourad
Nabil Mourad, a name synonymous with Excel expertise. With the distinguished title of Microsoft Excel Most Valuable Professional and over 15 years as a Microsoft Certified Trainer, Nabil brings a wealth of knowledge. He's a college professor in Toronto, a partner at OfficeInstructor Training Centre, and a published author of several Excel textbooks. His dedication to education is further exemplified by his highly successful YouTube channel, OfficeInstructor, which has surpassed 100,000 subscribers, And looking ahead, he's currently working on his first LinkedIn Learning course, set to launch in Summer 2025. Please join me in welcoming Nabil!
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