Excel for Beginners: Beginner Functions

External: Coursera Courses ↗ · Coursera

Open Course on External: Coursera

Free to audit · Opens on External: Coursera

Excel for Beginners: Beginner Functions

Coursera · Beginner ·📊 Data Analytics & Business Intelligence ·3mo ago

Key Takeaways

Performs basic spreadsheet functions using Excel on the Web

Original Description

This 1-hour, project-based course introduces learners to basic spreadsheet functions. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft. However, all of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets. We will cover the following concepts in a hands-on manner: - Review basic functions: sum, min, max, average - Introduction to date-based functions: today, year, month, day, datedif - Trying out conditional functions: if, iferror, countif, sumif - Applying string-manipulation functions: find, replace, proper, concat, textjoin Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.
Watch on External: Coursera ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
From Data Ownership to an AI-Powered Second Brain
Learn how to leverage AI for data-driven decision making and create a second brain for your organization, enabling better insights and productivity
Medium · Data Science
📰
Snowflake VALIDATION_MODE: Dry Runs and Error Detection Before Loading (2026)
Learn to use Snowflake's VALIDATION_MODE for dry runs and error detection before loading data, ensuring data quality and integrity
Medium · Data Science
📰
Verifying How IAM and Lake Formation Behave for the Glue REST Catalog and S3 Tables
Learn how IAM and Lake Formation interact with Glue REST Catalog and S3 tables, and how to verify their behavior for secure data management
Dev.to · Aki
📰
We Leaked PII in Staging: Here's the Automated Data Masking Pipeline That Saved Us
Learn how to build an automated data masking pipeline using Python to protect sensitive data in staging environments
Hackernoon
Up next
6-Phase SQL Roadmap 2026 | Data Analytics & Engineering | #shorts
SCALER
Watch →