Excel and Copilot Fundamentals

Excel and Copilot Fundamentals

This course is part of multiple programs.

Instructor: Microsoft

Access provided by L&T Corp - ATLNext

106,866 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

319 reviews

Beginner level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

5 modules

Gain insight into a topic and learn the fundamentals.

319 reviews

Beginner level

Recommended experience

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

What you'll learn

Activate and effectively use Excel Copilot for basic tasks and queries.
Navigate the Excel interface and utilize basic features efficiently.
Apply fundamental Excel formulas and functions to perform calculations and data manipulation.
Develop basic prompt engineering skills for Copilot in Excel.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

20 assignments¹

AI Graded see disclaimer

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

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 5 modules in this course

This course introduces you to the basics of Microsoft Excel and its powerful Copilot feature, equipping you with essential skills for efficient data handling and analysis. You will learn to navigate Excel’s interface, apply fundamental formulas and functions, and develop prompt engineering techniques to leverage Excel Copilot for various tasks. By the end of this course, you will have a strong foundation in Excel, enabling you to perform basic data manipulations and utilize Copilot to streamline your workflow.

By the end of the course, you’ll be able to: - Activate and effectively use Excel Copilot for basic tasks and queries. - Navigate the Excel interface and utilize basic features efficiently. - Apply fundamental Excel formulas and functions to perform calculations and data manipulation. - Develop basic prompt engineering skills for Excel Copilot. Tools you’ll use: - Microsoft Excel - Copilot in Excel Required Course Materials: A Copilot license is required to complete this course. If you don’t have a Microsoft 365 Personal or Family license, you can start a free 30-day trial using the link provided in the course.

This module covers the activation and basic usage of Copilot in Excel, helping you understand its environments and how to effectively utilize it for various tasks.

What's included

12 videos11 readings4 assignments

12 videos Total 81 minutes

Activating Excel Copilot 7 minutes
Performing basic tasks with Copilot 7 minutes
Hands-on activity debrief: Activating Copilot 8 minutes
Hands-on activity debrief: Create a travel budget 4 minutes
Optimizing workflows with Excel Copilot Part 1 of 2 5 minutes
Optimizing workflows with Excel Copilot Part 2 of 2 7 minutes
Using conditional formatting with Copilot 6 minutes
Enhancing data presentation with Excel Copilot 5 minutes
Hands-on activity debrief: Optimize workflows with Copilot 7 minutes
Evaluating Copilot performance 7 minutes
Improving Copilot performance through customization 8 minutes
Hands-on activity debrief: Evaluating Copilot performance 9 minutes

11 readings Total 127 minutes

Welcome to Excel and Copilot fundamentals 10 minutes
Introduction to the Coursera Community 10 minutes
Getting started with Copilot in Excel 2 minutes
How to Get Started with Microsoft Copilot 10 minutes
Guide to performing basic tasks using Copilot in Excel 10 minutes
Hands-on activity: Activating Copilot 20 minutes
Hands-on activity: Create a travel budget 5 minutes
Using Excel add-ins to extend functionality 10 minutes
Hands-on activity: Optimize workflows with Copilot 20 minutes
Copilot performance metrics 10 minutes
Hands-on activity: Evaluating Copilot performance 20 minutes

4 assignments Total 63 minutes

Quiz: Introduction to Copilot in Excel and activation 30 minutes
Quiz: Performing basic tasks using Copilot in Excel 12 minutes
Quiz: Optimizing workflows with Copilot 12 minutes
Quiz: Copilot performance 9 minutes

This module introduces the Excel interface and its basic features. You will become familiar with the layout, essential elements, and basic functionalities to use Excel efficiently and be able to compare these functionalities to the abilities of Copilot.

What's included

11 videos8 readings4 assignments

11 videos Total 82 minutes

Introduction to Excel: Basic navigation 6 minutes
Introduction to Excel: Backstage view and shortcuts 7 minutes
Creating and managing Excel workbooks 7 minutes
Hands-on activity debrief: Navigating and using basic features 14 minutes
Introduction to data types 5 minutes
Converting data types 6 minutes
Working with data types 7 minutes
Hands-on activity debrief: Understanding data types 9 minutes
Creating lists 6 minutes
Creating tables 7 minutes
Hands-on activity debrief: Creating lists and tables 8 minutes

8 readings Total 105 minutes

Basic features in Excel 10 minutes
Using Excel templates for efficiency 5 minutes
Hands-on activity: Navigating and using basic features 20 minutes
Mastering data types in Excel: Tips and tricks for effective data management 10 minutes
Hands-on activity: Understanding data types 20 minutes
Guide to Excel tables and best practice 10 minutes
Hands-on activity: Creating lists and tables 20 minutes
Discussion: Customizing the Excel interface 10 minutes

4 assignments Total 84 minutes

Quiz: Excel interface and basic features 30 minutes
Quiz: Excel interface customization 18 minutes
Quiz: Data types 18 minutes
Quiz: Lists and tables 18 minutes

This module focuses on Excel formulas and how to do this with Copilot as well as functions, covering essential arithmetic operations and key functions to manipulate and analyze data effectively.

What's included

9 videos10 readings4 assignments

9 videos Total 69 minutes

Using basic arithmetic in Excel 7 minutes
Applying mathematical functions in Excel 7 minutes
Hands-on activity debrief: Practicing arithmetic functions 8 minutes
Applying logical functions in Excel 7 minutes
Combining logical and LOOKUP functions for advanced data analysis 7 minutes
Hands-on activity debrief: Practicing logical and LOOKUP functions 8 minutes
Using conditional, date, and time functions with Copilot 7 minutes
Using nested functions for complex calculations in Excel 8 minutes
Hands-on activity debrief: Practicing conditional, date, and time functions 10 minutes

10 readings Total 130 minutes

Applying BODMAS 10 minutes
Understanding cell references (relative, absolute, and mixed) 10 minutes
Hands-on activity: Practicing arithmetic functions 20 minutes
Using LOOKUP functions overview 10 minutes
Creating and managing named ranges 10 minutes
Hands-on activity: Practicing logical and LOOKUP functions 20 minutes
Applying the date and time functions overview 10 minutes
Understanding Excel's error messages and troubleshooting techniques 10 minutes
Hands-on activity: Practicing conditional, date, and time functions 20 minutes
Discussion: Optimizing patient data analysis with Excel 10 minutes

4 assignments Total 84 minutes

Quiz: Excel formulas and functions 30 minutes
Quiz: Arithmetic functions 18 minutes
Quiz: Logical and LOOKUP functions 18 minutes
Quiz: Conditional, date, and time functions 18 minutes

This module focuses on basic data entry and formatting tasks using Excel Copilot, ensuring you can enter, edit, and format data efficiently.

What's included

9 videos5 readings4 assignments

9 videos Total 70 minutes

Data entry techniques 7 minutes
Using data validation for accurate data entry 7 minutes
Hands-on activity debrief: Practicing data entry techniques 7 minutes
Formatting data in Excel 7 minutes
Creating custom styles and templates in Excel 8 minutes
Hands-on activity debrief: Formatting techniques practice 8 minutes
Enhancing data presentation 8 minutes
Creating basic pivots in Excel 8 minutes
Hands-on activity debrief: Advanced formatting practice 11 minutes

5 readings Total 80 minutes

Overview of shortcuts 10 minutes
Hands-on activity: Practicing data entry techniques 20 minutes
Formatting best practices 10 minutes
Hands-on activity: Formatting techniques practice 20 minutes
Hands-on activity: Advanced formatting practice 20 minutes

4 assignments Total 66 minutes

Quiz: Basic data entry and formatting with Copilot 30 minutes
Quiz: Data entry techniques 12 minutes
Quiz: Formatting techniques 12 minutes
Quiz: Advanced formatting 12 minutes

This module introduces prompt engineering techniques to effectively use Excel Copilot for various advanced tasks.

What's included

10 videos8 readings4 assignments1 peer review

10 videos Total 79 minutes

Engineering prompts for Excel Copilot 8 minutes
Advanced prompt engineering techniques 7 minutes
Hands-on activity debrief: Writing basic prompts 7 minutes
Writing effective prompts 8 minutes
Improving your prompts 6 minutes
Hands-on activity debrief: Practicing effective prompts 10 minutes
Evaluating prompt performance 7 minutes
Optimizing prompts for better results 7 minutes
Hands-on activity debrief: Evaluating prompt performance 9 minutes
Cumulative project debrief: Attendance tracker 9 minutes

8 readings Total 105 minutes

List of Copilot tasks available and starter prompts 10 minutes
Understanding natural language processing (NLP) basics 10 minutes
Hands-on activity: Writing basic prompts 20 minutes
Techniques for effective prompts 5 minutes
Hands-on activity: Practicing effective prompts 20 minutes
Metrics for prompt performance 10 minutes
Hands-on activity: Developing effective prompts 20 minutes
Cumulative project: Discussion 10 minutes

4 assignments Total 57 minutes

Quiz: Introduction to prompt engineering for Excel Copilot 30 minutes
Quiz: Prompt engineering basics 9 minutes
Quiz: Effective prompts 9 minutes
Quiz: Prompt performance 9 minutes

1 peer review Total 35 minutes

Cumulative project: Attendance tracker 35 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(93 ratings)

Microsoft

287 Courses 2,323,864 learners

Offered by

Microsoft

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
65.20%
4 stars
15.67%
3 stars
4.07%
2 stars
4.70%
1 star
10.34%

Showing 3 of 319

Reviewed on Feb 17, 2025

Excellent Skills and knowledge for Microsoft Excel and Copilot Fundamentals

Reviewed on Oct 2, 2025

I found this course too much beneficial and gained too much of expertise.

Reviewed on May 26, 2025

Some of the instructions were unclear and the reading sections were somewhat vague at times. Otherwise, the course was informative and a good introduction to using Copilot.

View more reviews