Course
The 15 Basic Excel Formulas Everyone Needs to Know
Learn how to add arithmetic, string, time series, and complex formulas in Microsoft Excel.
Updated Dec 2023 · 15 min read
Get certified in data literacy and land your dream role
Our certification programs help you stand out and prove your skills are job-ready to potential employers.
What is the easiest way to learn Excel formulas?
Can Excel formulas be used for large datasets?
How do I debug an error in an Excel formula?
Are Excel formulas the same in all versions of Excel?
Can Excel formulas replace manual data analysis methods?
Topics
Spreadsheet Courses
2 hr
20.4K
Course
Intermediate Google Sheets
4 hr
48.1K
Course
Data Analysis in Excel
3 hr
30.4K
See More
RelatedSee MoreSee More
tutorial
How to Use HLOOKUP in Excel
A beginner-friendly, comprehensive tutorial in mastering the HLOOKUP function in Microsoft Excel.
Arunn Thevapalan
6 min
tutorial
How to Calculate Percentiles in Excel
In this tutorial, we'll explore what percentiles are, what they are used for, the ways of calculating them in Excel, simple examples of such calculations, and possible errors to be aware of when computing percentiles in Excel.
Elena Kosourova
8 min
tutorial
How to Calculate Factorials in Excel: A Complete Guide
Learn to calculate factorials in Excel with ease. Discover FACT, FACTDOUBLE, GAMMA functions, and more to solve mathematical and real-world problems.
Elena Kosourova
7 min
tutorial
How to Use the XLOOKUP Excel Function with Multiple Criteria
This tutorial discusses the purpose and syntax of the XLOOKUP Excel function, its advantages concerning its predecessors, the two main ways of using XLOOKUP with multiple criteria including their pros and cons, extending functionality through the optional parameters, and the way of running a similar search in older Excel versions.
Elena Kosourova
0 min
tutorial
How to Calculate Confidence Intervals in Excel
A beginner-friendly, comprehensive tutorial on understanding Confidence Interval calculations in Microsoft Excel.
Arunn Thevapalan
8 min
tutorial
Monte Carlo Simulation in Excel: A Complete Guide
A beginner-friendly, comprehensive tutorial on performing Monte Carlo Simulation in Microsoft Excel, along with examples, best practices, and advanced techniques.
Arunn Thevapalan
9 min