Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

7 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There is 1 module in this course

Explore Copilot’s integration with Microsoft 365, its capabilities in Excel, and tips for effective use. Learn to reshape data, uncover insights, and even perform advanced automation like using Copilot to run macros. Discover how to ask Copilot the right questions to get the results you want, and how to troubleshoot when you don't. Whether simplifying workflows, creating impactful dashboards, or driving data-driven decision-making, this course equips you to leverage Copilot to transform the way you work in Excel. This course is ideal for professionals and students who work with Excel and want to hop on board the "AI" train to discover greater efficiency and enhance productivity using Microsoft Copilot, Perfect for business owners, sales and financial analysts, managers, and anyone seeking to unlock deeper insights from their data.

This quick "crash course" focuses on how professionals and students experienced in Excel can strategically leverage Microsoft Copilot in Excel to automate data analysis and visualization, transforming and optimizing workflow while achieving professional visuals and actionable insights! Explore Copilot’s integration with Microsoft 365, its capabilities in Excel, and tips for effective use. Learn to reshape data, uncover insights, and even perform advanced automation like using Copilot to run macros. Discover how to ask Copilot the right questions to get the results you want, and how to troubleshoot when you don't. Whether simplifying workflows, creating impactful dashboards, or driving data-driven decision-making, this course equips you to leverage Copilot to transform the way you work in Excel.

What's included

23 videos5 readings7 assignments7 discussion prompts

23 videosTotal 60 minutes

Welcome: What To Expect From This Course2 minutesPreview module
Lesson: Introducing Copilot: Your Partner in Data Analysis and Productivity3 minutes
Lesson: Understand Copilot for Data Management in Excel2 minutes
Lesson: Prompt Like a Professional3 minutes
Lesson: What Questions Can Copilot Answer in Data Analysis?4 minutes
Use Copilot to Analyze Data1 minute
Use Case: Provide Recommendations with Copilot in Excel1 minute
Lesson 2: Reshape Data Using Microsoft Copilot in Excel1 minute
Sort and Filter Data With Copilot 1 minute
Use Copilot to Generate Formula Columns1 minute
Use Case: Rank Categories by Profitability with Copilot in Excel1 minute
Use Case: Summarize Key Metrics with Copilot in Excel2 minutes
Lesson 3: Uncover Insights Through Copilot Suggestions3 minutes
Identify Data Insights with Copilot1 minute
Simplify Budgeting Using Copilot2 minutes
Use Case: Track Profit Trends Over Time1 minute
Lesson 4: Bring Data to Life with Visuals4 minutes
Generate a Chart Using Copilot1 minute
Visualize Your Budget Using Copilot2 minutes
Use Case: Use Copilot to Create a Dashboard2 minutes
Lesson 5.1: Troubleshooting in Copilot: Improve Visual Outcomes with Prompt Adjustments3 minutes
Use Case: Use Copilot to Create Macros in Excel Part 14 minutes
Use Case: Use Copilot to Create Macros in Excel Part 24 minutes

5 readingsTotal 14 minutes

Note about Copilot and Excel Interfaces1 minute
Limited Time Offer! Finish the Course and Get Access to M365 Video Knowledge Library!2 minutes
STOP! Prepare the course practice workbook before proceeding!5 minutes
Lesson 5.2: Dive Into Copilot and Automation4 minutes
Congratulations!2 minutes