Develop your Microsoft Excel skills for preparing, analyzing, and working with business data. In this course, you will learn to use text functions to clean and standardize inconsistent data, date and time functions to create timelines and calculate time-based metrics, and logical functions to automate decisions and generate new information within datasets. Through practical business scenarios, you will apply functions such as IF, IFS, AND, and OR to transform data and support more reliable analysis. By the end of the course, you will be able to use Excel functions to improve data quality, create time-based calculations, and automate logic-driven tasks in spreadsheets.
Data Preparation Using Functions
Data Preparation Using Functions
This course is part of Microsoft Excel for Beginners Professional Certificate
Instructor: Microsoft
Included with Learn 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
What you'll learn
Use functions to prepare text data for effective analysis.
Use sorting and filtering tools to perform simple data analysis.
Use functions such as IF, VLOOKUP and create PivotTables to perform more advanced data analysis.
Details to know
Shareable certificate
Add to your LinkedIn profile
Recently updated!
September 2026
Assessments
7 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
Build your Business Essentials expertise
This course is part of the Microsoft Excel for Beginners Professional Certificate
When you enroll in this course, you'll also be enrolled in this Professional Certificate.
- 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 from Microsoft
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."
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
