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

What You'll Learn

Performs basic spreadsheet functions using Excel on the Web

Watch on External: Coursera ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related AI Lessons

The Nervous System of the Telco: Unlocking the Real-Time Power of the Network Element Interfaces…
Unlock the power of network element interfaces to enable real-time insights in telco operations
Medium · Data Science
Enhanced RFM Analysis for Customer Segmentation using K-Prototypes
Learn how to enhance RFM analysis for customer segmentation using K-Prototypes, a clustering algorithm that handles categorical and numerical data, to improve marketing strategies and customer targeting.
Medium · Machine Learning
One Survey Asked Rich People Ten Times More Often Than Poor People.
Learn how a biased survey sample can impact data analysis and decision-making, and why it's crucial to ensure representative sampling in data science
Medium · Data Science
Data Cleaning Fundamentals: Building a Reproducible Data Cleaning Pipeline
Learn to build a reproducible data cleaning pipeline to transform raw data into analysis-ready datasets
Medium · Data Science
Up next
Spreadsheet Guy Meets the CFO: "Define How Much"
Digital Transformation with Eric Kimberling
Watch →