Microsoft Excel: From Basics to AI-Powered Workflows

Microsoft Excel: From Basics to AI-Powered Workflows

Instructor: Anton Voroniuk

Access provided by Alliance University

2,257 already enrolled

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

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

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.