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
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…
Human Error Reduction Techniques for Floor Supervisors
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Your AI Advantage: How HR Professionals Can Use Claude to S…
The Anti-Kickback Statute: Enforcement and Recent Updates
Empowering Conflict Resolution: Letting Go to Gain Control
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Using Copilot to Format Legal Documents in Microsoft Word
Dealing With Difficult People: At Work & In Life
Using Stay Interviews To Improve Employee Retention & Engag…
AI in Word - Smarter Writing and Document Creation with Cha…
FDA Current Trends in Compliance and Enforcement for FDA-Re…
Zero Acceptance Sampling to Reduce Inspection Costs
Why EBITDA Doesn't Spell Cash Flow and What Does?
Mastering Tough Conversations: Turn Conflict into Clarity, …
Enhancing Pivot Tables with Images: Visualize Your Data Lik…
Discover how Emotional Intelligence turns AI from a technic…
Understanding Financial Statements for Non-Financial Profes…
SOPs - How to Write Them to Satisfy those Inspectors
Managing Projects When AI Joins the Team: Human Judgment, A…