Excel - Microsoft Excel Formulas and Functions For Beginners

Name: Excel - Microsoft Excel Formulas and Functions For Beginners
Rating: 4.3 (37 reviews)

Master the core functions of Excel step by step, perfect for students, job seekers, and professionals.

Created bySkillify Academy

Last updated 8/2025

English

English [Auto],

What you'll learn

Introduction to the Excel Interface
Logical Operators IF, AND,OR & NOT
Working with Error Function
IF and IFS Statements
Nested IF & IFS Statements
SUM, SUMIF, SUMIFS & SUMPRODUCT Functions
COUNT, COUNTA, COUNTBLANK, COUNTIF & COUNTIFS
AVERAGE, AVERAGEA, AVERAGEIF & AVERAGEIFS
ROUND, ROUNDUP & ROUNDDOWN Functions
MIN() and MAX() Functions
ROW, ROWS, COLUMN and COLUMNS and mores

Course content

1 section • 17 lectures • 2h 7m total length

Introduction to the Excel Interface7:58
Explore the Excel interface, including the ribbon with home, insert, page layout, and formulas tabs, the quick access toolbar, formula bar, worksheet area, sheet tabs, and status bar.
Logical Operators IF, AND,OR & NOT9:00
Learn how to use Excel logical operators if and and or not to make data driven decisions, evaluate conditions, and build conditional formulas for pass/fail and attendance scenarios.
Working with Error Function8:36
Explore how to detect, handle, and correct Excel errors using iferror, iserror, and error type functions. Customize vlookup results with not found or other messages to keep reports clean.
IF and IFS Statements10:15
Learn how to use if and ifs statements in Excel to automate decisions, from simple pass/fail tests to multi-condition grading and sales bonuses, with practical real-world examples.
Nested IF & IFS Statements10:18
Learn to use nested if and IFS statements in Excel to evaluate conditions with true or false results. Assign grades or segments based on logical tests.
Relative, Absolute and Mixed References5:50
Master relative, absolute, and mixed references in Excel to make formulas adapt when copied, keep constants fixed, and support dynamic tabs and conditional formatting.
Calculations with SUM, SUMIF, SUMIFS & SUMPRODUCT Function7:53
Master Excel formulas for data analysis by learning sum, sumif, sumifs, and sumproduct to quickly sum ranges, conditionally filter data, and multiply quantities by prices.
Calculations with COUNT, COUNTA, COUNTBLANK, COUNTIF & COUNTIFS8:22
Explore how Excel count functions work together to analyze data: count counts numbers, counta counts non-empty cells, countblank finds blanks, and countif and countifs apply single or multiple criteria.
Calculations with AVERAGE, AVERAGEA, AVERAGEIF & AVERAGEIFS7:50
master four essential excel average functions—average, averagea, averageif, and averageifs—to compute averages across numbers, text, and conditioned data. apply them to analyze scores and expenses with flexible criteria.
Working with ROUND, ROUNDUP & ROUNDDOWN Functions7:09
Explore how round, roundup, and round down functions in Excel control decimal places, with examples for financial data, measurements, and precise unit calculations.
Working with Rand & Randbetween5:29
Explore how the rand and randbetween functions generate random numbers in Excel, with rand producing decimals between 0 and 1 and randbetween returning whole numbers within a defined range.
Working with MIN() and MAX() Functions5:00
Master Excel's min and max functions to quickly identify the smallest and largest values in a data range, and combine them with if for deeper analysis.
Working with SMALL, LARGE Functions6:49
Learn to use the small and large functions to extract the first through third smallest or largest values in a range, using the array and k parameters.
Working with ROW, ROWS, COLUMN and COLUMNS5:45
Learn to use row, rows, column, and columns to identify positions, count items, and manipulate data in Excel, with practical examples for beginners.
Working with ODD, EVEN and MOD Formula5:57
Explore Excel's odd, even, and mod functions to round numbers to the nearest odd or even integers and return remainders for data categorization and analysis.
Dynamic Array Functions (FILTER, UNIQUE and SORT)7:01
Master dynamic array functions in Excel by applying filter, unique, and sort to extract, deduplicate, and order data for faster analysis.
Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)8:42
Explore Excel lookup and reference functions like vlookup, hlookup, index, and match, learn to search a value in column and retrieve data, combining index and match to overcome vlookup limits.

Requirements

No prior Excel knowledge required

Description

Are you new to Excel and feeling overwhelmed by all the formulas and functions? You’re not alone. This beginner friendly course is designed to demystify Microsoft Excel’s formulas and functions and help you build a strong foundation in spreadsheet skills that are essential in any career.

Whether you're a student, professional, freelancer, or entrepreneur, this course will walk you through the most important Excel functions used in real world business, finance, data analysis, and daily productivity tasks.

No fluff — just clear explanations, hands-on exercises, and practical examples that show you how to use formulas with confidence.

What You’ll Learn:

How to write and use basic Excel formulas
Understand the difference between relative, absolute, and mixed cell references
Apply essential functions like SUM, AVERAGE, COUNT, MIN, MAX
Use logical functions like IF, AND, OR, NOT
Work with text using LEFT, RIGHT, MID, LEN, CONCAT, TEXTJOIN, TRIM
Lookup and reference data with VLOOKUP, HLOOKUP, INDEX, MATCH
Use date & time functions such as TODAY, NOW, DATEDIF, NETWORKDAYS
Troubleshoot formulas and avoid common errors (#DIV/0!, #VALUE!, etc.)
Create simple, dynamic reports using formulas

Why Learn Excel Formulas and Functions?

Formulas are the heart of Excel — they make your spreadsheets powerful, dynamic, and intelligent. Mastering them means you can:
Analyze and summarize data effortlessly
Make better business decisions
Automate repetitive tasks
Save hours of manual work

Get Started Today

Included in This Course:

Introduction to the Excel Interface
Relative and Absolute Cell References
Logical Operators IF, AND,OR & NOT
Working with Error Function
IF and IFS Statements
Nested IF & IFS Statements
Calculations with SUM, SUMIF, SUMIFS & SUMPRODUCT Function
Calculations with COUNT, COUNTA, COUNTBLANK, COUNTIF & COUNTIFS
Calculations with AVERAGE, AVERAGEA, AVERAGEIF & AVERAGEIFS
ROUND, ROUNDUP & ROUNDDOWN Functions
Rand & Randbetween
MIN() and MAX() Functions
SMALL, LARGE Functions
ROW, ROWS, COLUMN and COLUMNS
ODD, EVEN and MOD Formula

By the end of this course, you’ll be able to use Excel formulas confidently, solve real-world problems, and impress employers or colleagues with your new skills.

Enroll now and take the first step toward Excel mastery!

Who this course is for:

Anyone who wants to save time and be more productive in Excel
Students and job seekers looking to add Excel to their resume
Office professionals who want to strengthen their spreadsheet skills
Complete beginners with no prior experience in Excel