Microsoft Excel: From Basics to AI-Powered Workflows

Microsoft Excel: From Basics to AI-Powered Workflows

位教师：Anton Voroniuk

访问权限由 Coursera Learning Team 提供

2,257 人已注册

8个模块

深入了解一个主题并学习基础知识。

18 条评论

初级等级

推荐体验

7 小时完成

灵活的计划

自行安排学习进度

8个模块

深入了解一个主题并学习基础知识。

18 条评论

初级等级

推荐体验

7 小时完成

灵活的计划

自行安排学习进度

您将学到什么

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

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

7 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

该课程共有8个模块

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.

涵盖的内容

6个视频1篇阅读材料1个作业

6个视频总计18分钟

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

1篇阅读材料总计10分钟

The Role of AI in Modern Productivity Workflows10分钟

1个作业总计30分钟

Excel + AI Foundations30分钟

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.

涵盖的内容

5个视频2篇阅读材料1个作业

5个视频总计6分钟

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

2篇阅读材料总计20分钟

Data Hygiene: Preparing Tables for AI10分钟
Essential Shortcuts Cheat Sheet10分钟

1个作业总计30分钟

Data Analysis & Excel Essentials30分钟

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.

涵盖的内容

7个视频1篇阅读材料1个作业

7个视频总计10分钟

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

1篇阅读材料总计10分钟

Troubleshooting: Fixing Common Errors10分钟

1个作业总计30分钟

Excel Tables, Functions, and Data Analysis Essentials30分钟

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.

涵盖的内容

4个视频1篇阅读材料1个讨论话题

4个视频总计14分钟

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

1篇阅读材料总计10分钟

AI Tools for Smarter Data Storytelling10分钟

1个讨论话题总计15分钟

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

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.

涵盖的内容

3个视频2篇阅读材料1个作业

3个视频总计8分钟

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

2篇阅读材料总计20分钟

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

1个作业总计30分钟

Final Checkpoint: Excel with AI Integration Mastery30分钟

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

涵盖的内容

8个视频2篇阅读材料1个作业

8个视频总计16分钟

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

2篇阅读材料总计20分钟

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

1个作业总计10分钟

Advanced Analytics & AI10分钟

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