John Wiley & Sons

Excel Efficiency: Automation, Security, and AI Tools

John Wiley & Sons

Excel Efficiency: Automation, Security, and AI Tools

Included with Coursera PlusLearn more

Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

5 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

5 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Create and format spreadsheets for efficient data management

  • Perform calculations and use advanced functions to analyze data

  • Build visualizations and automate tasks using macros and AI tools

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

October 2026

Assessments

7 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Microsoft 365 Excel For Dummies 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 6 modules in this course

This module explores the power of dynamic formatting in Excel, focusing on how to apply and manage conditional rules. Learners will understand the limitations and possibilities of formatting options, and gain hands-on skills in using color scales, top/bottom rules, and custom formulas for data visualization.

What's included

1 video7 readings1 assignment

This module teaches learners how to secure Excel spreadsheets by protecting cells, implementing data validation, and setting up error alerts to prevent user errors and maintain data integrity. Learners will gain practical skills in configuring worksheet protections and refining input rules to ensure accurate data entry.

What's included

1 video8 readings1 assignment

This module explores the practical application of AI tools such as Flash Fill, Analyze Data, and Copilot Pro to streamline workflows and enhance productivity. Learners will gain an understanding of AI's potential and challenges, particularly in data extraction from images using OCR technology.

What's included

1 video3 readings1 assignment

This module teaches how to record and manage Excel macros to automate repetitive tasks, configure macro security settings, and use relative references for flexible macro functionality. Learners will also discover how to assign keyboard shortcuts, link macros to shapes, and utilize the Personal Macro Workbook for efficient macro management.

What's included

1 video8 readings1 assignment

This module provides practical strategies for boosting productivity in Excel through the use of time-saving keyboard shortcuts. Learners will discover how to streamline common tasks and avoid data loss through efficient navigation and saving techniques.

What's included

1 video2 readings1 assignment

This module covers essential techniques for preventing and recovering from spreadsheet data loss. Learners will explore methods to recognize risks, apply recovery strategies, and implement preventive measures to ensure data integrity. The content focuses on practical skills for safeguarding Excel workbooks and managing potential threats.

What's included

1 video4 readings2 assignments

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

Wiley Skills Network
John Wiley & Sons
227 Courses26,519 learners

Offered by

Explore more from Business Essentials

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

What brings you to Coursera today?

Frequently asked questions