Intermediate Excel with AI is a hands-on, intermediate-level course designed to help existing Excel users take their skills to the next level by creating more automated low maintenance worksheets. This course focuses on managing data and generating reports using a range of powerful Excel features combined with practical AI assistance.

Excel for Business with AI: Intermediate
Gain insight into a topic and learn the fundamentals.
Intermediate level
Recommended experience
4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
What you'll learn
Clean, reshape, and prepare data using Flash Fill, text functions, and date calculations to build analysis-ready datasets.
Apply conditional formatting and IF-based functions to build spreadsheets that highlight patterns and support decisions.
Use named ranges, structured tables, VLOOKUP, and XLOOKUP to design scalable, automated spreadsheet models.
Build PivotTables, Pivot Charts, and interactive dashboards with slicers for professional self-service reporting.
Skills you'll gain
- Data Visualization
- Exploratory Data Analysis
- Automation
- Microsoft Copilot
- Excel Formulas
- Data Validation
- Artificial Intelligence
- Data Cleansing
- Data Wrangling
- Data Transformation
- Business Analytics
- People Analytics
- Data Visualization Software
- Spreadsheet Software
- Pivot Tables And Charts
- Business Reporting
- Data Analysis
Tools you'll learn
Details to know

Shareable certificate
Add to your LinkedIn profile
Recently updated!
July 2026
Assessments
43 assignments
Taught in English
See how employees at top companies are mastering in-demand skills

There are 6 modules in this course
Instructor

Offered by
Explore more from Business Essentials
Status: PreviewMacquarie University
Status: Free TrialMacquarie University
Status: PreviewSkillsBooster Academy
Status: Free TrialJohns Hopkins University
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."
Advance your career with an online degree
Earn a degree from world-class universities - 100% online



