Excel Formulas | Codefinity
Course
Certificate

# Excel Formulas

4.0+
5 reviews
Beginner
This course is designed for beginners who want to start exploring formulas in Excel. You'll begin with the basics and then discover some really useful formulas for daily use. Show more
14 chapters
1 hours
Over 1.5 million
people have chosen

tech skills

## What you will learn

1
Basic Formulas
In this section you will learn how to input and use Excel formulas for various calculations, including basic operations like addition, subtraction, multiplication, division, and power. Discover the importance of using functions for clearer and more efficient calculations. Explore statistical functions like AVERAGE, MEDIAN, MODE, MIN, and MAX to analyze data effectively.
View chapter details
2
Array Formulas
In this section you will learn about array formulas in Excel and how they enable multiple calculations on sets of values simultaneously and how to use specific functions like UNIQUE, SORT, FILTER, and TRANSPOSE.
View chapter details
3
Lookup and Reference
In this section, you will learn about lookup and reference formulas in Excel. These formulas enable you to search for and retrieve specific data from a table or range. You will explore essential functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP, which are invaluable for finding and referencing data efficiently.
View chapter details
1
Basic Formulas
In this section you will learn how to input and use Excel formulas for various calculations, including basic operations like addition, subtraction, multiplication, division, and power. Discover the importance of using functions for clearer and more efficient calculations. Explore statistical functions like AVERAGE, MEDIAN, MODE, MIN, and MAX to analyze data effectively.
View chapter details
2
Array Formulas
In this section you will learn about array formulas in Excel and how they enable multiple calculations on sets of values simultaneously and how to use specific functions like UNIQUE, SORT, FILTER, and TRANSPOSE.
View chapter details
3
Lookup and Reference
In this section, you will learn about lookup and reference formulas in Excel. These formulas enable you to search for and retrieve specific data from a table or range. You will explore essential functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP, which are invaluable for finding and referencing data efficiently.
View chapter details
Trusted by employees of leading companies
We have students from each letter of MAANG and many more companies
Data Engineer
Certificate of Completion
Showcase your newly acquired skills. You've earned it
Main directions
Data Science
Elevate your skills with Python's simplicity, versatility, and robust libraries.
WEB Development
Enable your web development with dynamic and scalable applications.
Data Analytics
Extract insights with facilitation and create powerful visualizations.
Over 200,000 5-star ratings
and counting
Ruslan Kravchuk
The main thing is to learn and not give up
The material is good, there is a lot to learn, all in order to become better and the main thing is to learn what you want....
Matteo Comune
Thanks to them I'm learning a lot…
Thanks to them I'm learning a lot faster because they help you to understand everything from scratch. It's the best website that helps people with no background in IT...
great course for beginners
great course for beginners, they test your knowledge in every lesson...
Elpunzon
I am enjoying my Codefinity experience…
I am enjoying my Codefinity experience learning Python. The self-paced way of learning is great because I can fit it into my schedule...
Alexandru Alexandru
Is nice to learn from codefinity
Is nice to learn from codefinity. Its easy and have good examples on what I learned here...
jacob Templet
Easy to follow along with and provides...
Easy to follow along with and provides challenge in my every day life. The challenge keeps me wanting to learn day after day...
Elan
Codefinity is a comprehensive learning…
Codefinity is a comprehensive learning tool to help you develop your skills as a software engineer or data scientist. The exercises are fun and a good way to sharpen your skills...
Thibault
First time learning how to code
First time learning how to code and successfully doing so with codefinity - thank you...
Well designed for total beginners
Well designed for total beginners, incremental progress and makes me feel confident....
_Gracy
it's simply perfectly well explained
it's simply perfectly well explained! so far I have not experienced any difficulty because everything is so well managed...
Ruslan Kravchuk
The main thing is to learn and not give up
The material is good, there is a lot to learn, all in order to become better and the main thing is to learn what you want....
Matteo Comune
Thanks to them I'm learning a lot…
Thanks to them I'm learning a lot faster because they help you to understand everything from scratch. It's the best website that helps people with no background in IT...
great course for beginners
great course for beginners, they test your knowledge in every lesson...
Elpunzon
I am enjoying my Codefinity experience…
I am enjoying my Codefinity experience learning Python. The self-paced way of learning is great because I can fit it into my schedule...
Alexandru Alexandru
Is nice to learn from codefinity
Is nice to learn from codefinity. Its easy and have good examples on what I learned here...
jacob Templet
Easy to follow along with and provides...
Easy to follow along with and provides challenge in my every day life. The challenge keeps me wanting to learn day after day...
Elan
Codefinity is a comprehensive learning…
Codefinity is a comprehensive learning tool to help you develop your skills as a software engineer or data scientist. The exercises are fun and a good way to sharpen your skills...
Thibault
First time learning how to code
First time learning how to code and successfully doing so with codefinity - thank you...
Well designed for total beginners
Well designed for total beginners, incremental progress and makes me feel confident....
_Gracy
it's simply perfectly well explained
it's simply perfectly well explained! so far I have not experienced any difficulty because everything is so well managed...
Chosen by students of top schools
Including 30 out of top-30 U.S. colleges

## Accelerate your career with professional guidance

### Допомога

We're sorry to hear that something went wrong. What happened?