Search results
Find over 500 working Excel formulas with detailed explanations, videos, and related links. Learn how to use key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and more.
- BMI Calculation Formula
This example shows one way to calculate BMI (Body Mass...
- Count Specific Words in a Cell
If you need to count how many times a specific a word (or...
- Round a Number up to Nearest Multiple
This tells Excel to take the value in B6 ($33.39 ) and round...
- Fixed Value Every N Columns
In this example, the goal is to copy every nth value from...
- Currency Exchange Rate Example
To get historical currency exchange rates over time, you can...
- Round Price to End in .45 Or .95
To round prices to end in .45 or .95, depending on whether...
- Get Column Name From Index in Table
To get the name of a column in an Excel Table from its...
- Round a Price to End in .99
To round prices to end in the nearest, .99 value, you can...
- BMI Calculation Formula
22 wrz 2024 · Learn how to use 15 essential Excel formulas for arithmetic, string, time series, and complex data analysis. See examples, exercises, and tips for adding formulas manually or using GUI.
6 lip 2024 · This tutorial provides multiple examples and methods related to the use of Excel formula list. You can download the workbook and practice.
21 mar 2023 · Learn the basics and advanced techniques of creating and using formulas in Excel with this tutorial. Find out how to use operators, functions, cell references, and more with practical examples.
20 mar 2023 · Learn how to use 10 essential Excel functions and formulas to calculate numbers, averages, sums, maxes, mins, and more. See examples, tips, and links to in-depth tutorials for each function.
Excel Functions List. Below you will find a searchable list of ~200 Excel Functions. Next to each function, you’ll see a description of the function along with the function’s syntax. If you’d like to learn more about a function, simply click it’s row and go to the function page.
Learn how to create formulas from the data in your worksheet with sample data and guidance. Find links to articles and videos for different types of formulas, such as conditional, lookup, date and time, financial, statistical, math, counting, conversion, text, and more.