Microsoft Excel: From Basics to AI-Powered Workflows

Ends soon! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Microsoft Excel: From Basics to AI-Powered Workflows

This course is part of Microsoft Excel & Copilot: From Basics to AI Specialization

Instructor: Anton Voroniuk

Top Instructor

2,474 already enrolled

Included with

Learn more

8 modules

Gain insight into a topic and learn the fundamentals.

18 reviews

Beginner level

Recommended experience

7 hours to complete

Flexible schedule

Learn at your own pace

8 modules

Gain insight into a topic and learn the fundamentals.

18 reviews

Beginner level

Recommended experience

7 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Create smart, structured Excel workflows for budgeting, planning, and data tracking
Use AI tools like ChatGPT, Microsoft Copilot, and automate tasks and generate content
Apply key Excel functions, tables, and formulas to manage and analyze data efficiently
Collaborate in real time using Excel Online and AI-enhanced features to boost team productivity

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

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 part of the Microsoft Excel & Copilot: From Basics to AI Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

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 8 modules in this course

Unlock the power of Microsoft Excel combined with AI to streamline workflows and boost productivity using real-world skills. In this hands-on course, you’ll transform Excel into a smart system enhanced by AI to save time, reduce errors, and drive better decisions.

Master essential functions and advanced data management before diving into professional analytics and intelligent automation. You’ll learn to use tools like ChatGPT and Microsoft Copilot to generate complex logic, automate tasks with scripts, and build dynamic dashboard stories. Beyond simple automation, you’ll discover how AI "reads" your data and master the critical skill of auditing AI logic to ensure professional-grade accuracy. We blend practical training with forward-thinking strategies, including ethical AI practices for handling sensitive business data. By the end, you will create sophisticated workflows for campaign optimization, perform AI-guided hypothesis checks, and turn raw data into persuasive visual narratives. Ready to turn everyday spreadsheets into streamlined, intelligent systems? Enroll now and master the future of Microsoft Excel with AI workflows that save time and help you do more with confidence and clarity.

Introduction to Microsoft Excel & AI Integration gives you a fast, practical start. You’ll learn why Microsoft Excel remains essential, create your first project budget, and explore how AI tools like ChatGPT and Copilot can boost your workflow. By the end, you’ll understand how Excel and AI together can save time and simplify your work.

What's included

6 videos1 reading1 assignment

6 videosTotal 18 minutes

Welcome to the Course3 minutes
Why Excel Still Dominates: Use Cases Across Roles3 minutes
Navigating Excel Interface 4 minutes
Create a Project Budget in Excel2 minutes
Introduction to Generative AI & Workflow Automation3 minutes
Key AI Tools That Complement Excel 3 minutes

1 readingTotal 10 minutes

The Role of AI in Modern Productivity Workflows10 minutes

1 assignmentTotal 30 minutes

Excel + AI Foundations30 minutes

You’ll learn how to navigate efficiently, use templates for planning, format data clearly, and keep your files safe and organized. By the end of this module, you’ll be able to manage business data with confidence and clarity.

What's included

5 videos2 readings1 assignment

5 videosTotal 6 minutes

Navigating Excel Features Efficiently2 minutes
Business Planning Checklist Template in Excel1 minute
Saving and Backing Up in Google Sheets1 minute
Zoom Freezing Rows and Columns 1 minute
Alignment Wrapping and Merging Cells1 minute

2 readingsTotal 20 minutes

Data Hygiene: Preparing Tables for AI10 minutes
Essential Shortcuts Cheat Sheet10 minutes

1 assignmentTotal 30 minutes

Data Analysis & Excel Essentials30 minutes

You’ll learn how to clean, organize, and analyze information using tables, formulas, and essential functions like TODAY and NOW. By the end, you’ll be equipped to manage data accurately and build dynamic sheets that respond to real-time inputs.

What's included

7 videos1 reading1 assignment

7 videosTotal 10 minutes

Removing Duplicates in Excel2 minutes
Converting an Excel Table to a Range1 minute
Mastering Excels TODAY and NOW Functions2 minutes
Excel Table Formulas Simplified1 minute
Naming Ranges in Excel for Enhanced Data Management2 minutes
Protecting a Sheet with a Password1 minute
Data Analysis Process1 minute

1 readingTotal 10 minutes

Troubleshooting: Fixing Common Errors10 minutes

1 assignmentTotal 30 minutes

Excel Tables, Functions, and Data Analysis Essentials30 minutes

Learn how to streamline your daily tasks by combining the power of Excel with modern AI tools. This course covers practical techniques for automating data entry, analysis, reporting, and more—helping you save time and boost productivity.

What's included

4 videos1 reading1 discussion prompt

4 videosTotal 14 minutes

Using ChatGPT to Generate Excel Functions & Scripts1 minute
Leveraging Microsoft Copilot in Excel3 minutes
Google Gemini AI in Sheets6 minutes
Case Studies: Budgeting, Sales Reports, and Project Tracking3 minutes

1 readingTotal 10 minutes

AI Tools for Smarter Data Storytelling10 minutes

1 discussion promptTotal 15 minutes

Share a workflow you’ve automated (or plan to) with Excel + AI.15 minutes

Microsoft Excel’s online features with AI-powered tools. In this module, you’ll learn how to collaborate in real time, share data securely, and integrate intelligent assistants that streamline tasks, generate insights, and enhance team workflows.

What's included

3 videos2 readings1 assignment

3 videosTotal 8 minutes

Collaborative Editing & Sharing with Excel Online2 minutes
Integrating Excel with AI-Powered Tools 3 minutes
Emerging Trends: AI Assistants, APIs, and No-Code Tools3 minutes

2 readingsTotal 20 minutes

Hybrid Work: Online vs. Desktop Excel10 minutes
Low-Code Revolution: Excel as a Data Source10 minutes

1 assignmentTotal 30 minutes

Final Checkpoint: Excel with AI Integration Mastery30 minutes

Learn how to combine Excel and AI tools to automate analysis, optimize workflows, and turn data into actionable business insights.

What's included

8 videos2 readings1 assignment

8 videosTotal 16 minutes

Generate IF Statements Using Prompts1 minute
Creat a Budget Template with ChatGPT1 minute
Naming Ranges for Easy Reference3 minutes
Data Summary Excel Table with Chat GPT1 minute
Efficient Workbook Management2 minutes
Data Analysis & Campaign Optimization3 minutes
Data Storytelling & Final Dashboard Presentation Tips3 minutes
Automating Work Notes with Scripts1 minute

2 readingsTotal 20 minutes

AI Prompting for Pivot Table Insights10 minutes
Ethical AI: Handling Sensitive Business Data10 minutes

1 assignmentTotal 10 minutes

Advanced Analytics & AI10 minutes

Learn how to effectively use Microsoft Copilot in Excel to analyze data, generate insights, and create visualizations while critically evaluating its outputs.

What's included

8 videos2 readings1 assignment

8 videosTotal 30 minutes

How Copilot "Reads" Your Excel Data3 minutes
Excel vs Excel with Copilot: Key Differences and Advantages3 minutes
Perform Hypothesis Checks with Copilot Guidance4 minutes
Data Analysis in Excel2 minutes
Generating Charts & Dashboards5 minutes
Styling, Filtering & Exporting: Taking Visuals to the Next Level5 minutes
When to Use Copilot and When Not To3 minutes
Ask Copilot for Descriptive Statistics5 minutes

2 readingsTotal 20 minutes

Trust but Verify: Auditing Copilot’s Logic10 minutes
The Prompt Gallery: Create, Understand, Edit, Ask10 minutes

1 assignmentTotal 15 minutes

Copilot Integration & Workflow Mastery15 minutes

Microsoft Excel with AI workflow. You'll reflect on your progress, explore real-world uses, and get final tips to keep growing your skills.

What's included

3 videos1 assignment

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

(14 ratings)

Top Instructor

Anton Voroniuk

SkillsBooster Academy

49 Courses19,451 learners

Offered by

SkillsBooster Academy

Explore more from Personal Development

LearnKartS
Master Microsoft Excel with Copilot
Course
Vanderbilt University
ChatGPT + Excel: Master AI-driven Formulas & Visualizations
Course
Coursera
ChatGPT for Beginners: Save time with Microsoft Excel
Guided Project
Macquarie University
Excel for Business with AI: Essentials
Course

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."

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.