Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Data Preparation Using Functions

Microsoft via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Effort

3 weeks, 2 hours a week
Sessions

Self-Paced
Level

Beginner
Subtitles

German, Hindi, Pashto, Russian, French, Chinese, Hungarian, Ukrainian, Indonesian, Kazakh, Swedish, Korean, Portuguese, Greek, English, Italian, Spanish, Arabic, Vietnamese, Thai, Japanese, Azerbaijani, Polish, Farsi, Dutch, Turkish

Found in

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

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.

Syllabus

Using Functions to Clean and Standardize Text
- This module introduces common text functions that help prepare Excel data for analysis. You will learn how inconsistent data can affect analysis outcomes and how to use text functions to standardize data for reliable downstream use.
Date and Time Functions
- This module introduces date and time functions in Excel. You will learn why understanding date calculations is important for business analysis, how to create dynamic date and time entries, and how to use date functions to calculate working days and other time-based metrics.
Logical Functions
- This module introduces logical functions in Excel. You will learn how to use the IF function, nested IF and IFS functions, and AND and OR functions to generate new content and automate decision-making within datasets. A hands-on exercise applies the IFS function to a real business data scenario.