Copilot with Microsoft Excel: Achieve More with Your AI Assistant (Video)

Get ahead of the curve with Copilot for Excel to maximize productivity and extract meaningful data insights.

Overview:

Copilot is Microsoft's AI-powered assistant designed to help users with a wide range of tasks. Within Excel, Copilot enhances productivity and data analysis capabilities and helps with key tasks such as generating formulas, data insights, data formatting, advance analysis, natural language queries, etc.

This course will transform your Excel skills with the integration of Copilot, an advanced AI assistant designed to enhance your data handling capabilities. From sorting and filtering data to complex formula writing and insightful data analysis, Copilot elevates your Excel experience by automating tasks and providing intelligent recommendations.

In this course, you'll learn the different types of Copilot, and leverage its capabilities for research and problem-solving within Excel. By the end of the course, youll be proficient in using Copilot to write formulas, generate charts, and uncover valuable insights from your data, making your workflow more efficient and impactful.

Skill Level:

• Beginner

Learn How To:

• Get assistance with everyday Excel tasks using natural language
• Boost efficiency in Excel with Microsoft Copilot
• Employ Copilot to write, explain, and debug complex Excel formulas
• Leverage Copilot for intelligent data analysis and generating actionable insights
• Speak to your data (No more traditional search engines for help)

Course requirement:

• Basic to intermediate knowledge of Excel and some familiarity with Excel functions and formulas.

Who Should Take This Course:

• Data Analysts
• Accountants
• Business Analysts
• Developers

About Pearson Video Training:

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Prentice Hall, Sams, and Que Topics include: IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more.  Learn more about Pearson Video training at  http://www.informit.com/video.

Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.

Table of Contents

Introduction

Lesson 1: Fundamentals of Copilot with Excel (40 minutes)

1.1 Unveil Copilot and What it Offers

1.2 Understand the Different Microsoft Copilots Available

1.3 Learn the Copilot Interfaces

1.4 Get Assistance from Your Everyday Copilot

1.5 Use Copilot in Microsoft Excel

1.6 Compare Copilot with Classic Search Engines

1.7 Exercise: Use Copilot as Your Excel Assistant

Lesson 2: Manage your Data with Copilot (30 minutes)

2.1 Sort and Filter Data with Copilot

2.2 Highlight What Matters in a Table

2.3 Use Copilot for Complex Conditional Formatting Rules

2.4 Manage Conditional Formatting Rules

2.5 Exercise: Use Copilot with Your Excel Data

Lesson 3: Let Copilot Write Your Formulas (50 minutes)

3.1 Write Formula Columns with Copilot

3.2 Apply Text Operations with Copilot Formulas

3.3 Produce Multiple Results from a Single Copilot Prompt

3.4 Perform Calculations with Dates

3.5 Write Formulas That Use Other Tables

3.6 Implement Lookup Formulas and Comparing Tables

3.7 Exercise: Use Copilot for Excel Formulas

Lesson 4: Clean, Prepare, and Automate Data with Copilot (40 minutes)

4.1 Clean Data Suggestions with Copilot in Excel Online

4.2 Use Copilot to Sanitize Data in Excel Files

4.3 Extract Data from PDF Files to Excel

4.4 Generate Power Query M Code with Copilot

4.5 Create VBA Code using Copilot for Automation

4.6 Exercise: Use Copilot to Clean and Prepare Data

Lesson 5: Data Analysis with Copilot in Excel (40 minutes)

5.1 Get Suggested Insights on Data from Copilot

5.2 Use Natural Language Questions for Data Insights

5.3 Produce PivotTables and PivotCharts

5.4 Perform Text Analysis with Copilot

5.5 Exercise: Analyze Data with Copilot

Summary

If you find an error, you can report it to us through our Submit errata page.