Excel for Beginners: Beginner Functions
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
Medium · Data Science
Snowflake VALIDATION_MODE: Dry Runs and Error Detection Before Loading (2026)
Medium · Data Science
Verifying How IAM and Lake Formation Behave for the Glue REST Catalog and S3 Tables
Dev.to · Aki
We Leaked PII in Staging: Here's the Automated Data Masking Pipeline That Saved Us
Hackernoon
🎓
Tutor Explanation
DeepCamp AI