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 Form I-9: Documents and Policies that Ensure ICE I-9 Co…
Claude AI For CPAs & Finance Professionals: Best Practices …
Secrets Of Psychology - Why People Do The Things They Do
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
Project Management For Administrative Professionals
Elevate Your Workplace Wellness: 10 Critical Wellness Facto…
Onboarding is NOT Orientation - How to Improve the New Empl…
Managing Complex Projects - Project Management
Utilizing HR Metrics to Illustrate & Improve Human Resource…
Negotiating Skills For Professional Results - Winning Strat…
NEW Nacha Rule - Third-Party Sender (TPS) Roles and Respons…
FDA Technology Modernization Action Plan (TMAP) and Impact …
Paying and Receiving Payments for Referrals: You Can Go to …
Validation Statistics for Non-Statisticians
Human Factors Usability Studies Following ISO 62366 and FDA…
Construction Lending And Real Credit Administration: Evalua…
Excel Power Skills: Master Functions, Formulas, and Macros …
Thriving in a Hybrid Workplace: Keys to Leadership and Team…
Batch Record Review and Product Release
Discover how Emotional Intelligence turns AI from a technic…
Female to Female Hostility @Workplace: All you Need to Know
Copilot and HR: An Introduction for HR Professionals
ChatGPT for HR - Build HR Policy Framework and Strategy
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
The Perfect Storm Coming to Healthcare: Value Based Care Me…
Language is Code - Intro to AI - Generative AI - ChatGPT an…
Major cGMP Issues: FDA Concerns in 2026
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…