Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Chart Axes in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • How to Create Gantt Chart in Excel
  • How to calculate current stock or inventory in Excel
  • Filter Data Based on Date in Excel

References

  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel LOOKUP Function
  • Find closest match in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • How to get relative row numbers in a range in Excel

Data Validations

  • Excel Data validation must begin with
  • Excel Data validation must contain specific text
  • Excel Data validation exists in list
  • Excel Data validation no punctuation
  • Excel Data validation number multiple 100

Category: Excel Functions

Excel Standard Deviation

by

What is Standard Deviation (STDEV.P, STDEV.S)? This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using the STDEV.S function in Excel. What is Standard Deviation? Standard deviation is a number that tells you how far numbers are …

Continue Reading

Count Unique Values in Excel

by

This example shows you how to create an array formula that counts unique values. Examples: 1.. To count the number of 5’s, use the following function. We use the COUNTIF function.  2. To count the unique values (don’t be overwhelmed), we add the SUM function, 1/, and replace 5 with A1:A6. 3. Finish by pressing CTRL + SHIFT …

Continue Reading

RAND vs RANDBETWEEN function examples in Excel

by

Excel has two useful functions when it comes to generating random numbers. The RAND and RANDBETWEEN function. Rand The RAND function generates a random decimal number between 0 and 1. 1. Select cell A1. 2. Type RAND() and press Enter. The RAND function has no arguments. 3. To generate a list of random numbers, select cell A1, click on …

Continue Reading

Countif function in Excel

by

COUNTIF is one of the statistical functions, it is used to count the number of cells that meet a criterion This chapter covers  many easy to follow COUNTIF examples like Numbers, Text, Booleans, Errors and ‘Or Criteria’. Numbers 1. The COUNTIF function below counts the number of cells that contain the value 20. 2. The following COUNTIF …

Continue Reading

Vlookup Examples in Excel

by

The VLOOKUP function is one of the most popular functions in Excel. This chapter contains many easy to follow VLOOKUP examples for Exact Match, Approximate Match, Right Lookup, First Match, Case-insensitive, Multiple Criteria, #N/A error  and  Multiple Lookup Tables. Exact Match Most of the time you are looking for an exact match when you use the VLOOKUP function in Excel. …

Continue Reading

Excel If, Nested If, And/Or Criteria Examples

by

IF function is one of the most used functions in Excel. This page contains many easy to follow IF examples. Simple If Examples The IF function checks whether a condition is met, and returns one value if true and another value if false. 1a. For example, take a look at the IF function in cell B2 below. …

Continue Reading

Offset in Excel

by

The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells. OFFSET function Syntax; OFFSET(reference, rows, cols, [height], [width]) 1. The OFFSET function below returns the cell that is 3 rows below and 2 columns to the right of cell A2. The …

Continue Reading

Count and Sum Functions in Excel

by

The most used functions in Excel are the functions that count and sum. COUNT function is one of the STATISTICAL functions while SUM function is one of the Math and Trig functions. You can count and sum based on one criteria or multiple criteria. Count To count the number of cells that contain numbers, use the COUNT function. Countif To count cells …

Continue Reading

IF, AND, OR and NOT Functions Examples in Excel

by

Learn how to use Excel’s logical functions such as the IF, AND, OR and NOT function. If The IF function checks whether a condition is met, and returns one value if true and another value if false. 1. For example, take a look at the IF function in cell C2 below. Above Case Study Explanation: if the …

Continue Reading

Excel Date & Time Functions Example

by

To enter a date in Excel, use the “/” or “-” characters. To enter a time, use the “:” (colon). You can also enter a date and a time in one cell. Note: Dates are in US Format. Months first, Days second. This type of format depends on your windows regional settings. Learn more about Date and Time formats. Year, …

Continue Reading

Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

by

Excel has many functions to offer when it comes to manipulating text strings. Formula tab → Function Library Group → Text Function N/B: Every formula in excel must begin with an equal sign, function then in bracket; cell name/cell ranges/cell references. Syntax: =fx(cell name/cell ranges/cell references) Example: = Sum( A1:B4) Where Sum is the function name and A1:B4 is …

Continue Reading

Change Case: Uppercase, Lowercase, Propercase in Excel

by

How to convert text to capital letters and more in Excel Often times computer users find it difficult to change case in Excel. Imagine working on a huge volume of excel data and you need to convert a record to capital letters or the reverse. Boom! your stuck because it is not word document. We all …

Continue Reading

Excel VLOOKUP and HLOOKUP functions Examples

by

Learn all about Excel’s lookup & reference functions such as the VLOOKUP, HLOOKUP, CHOOSE, MATCH and INDEX  function. Navigation: Formula Tab → Function Library Group → Lookup and Reference Vlookup VLOOKUP stands for Vertical lookup.  The VLOOKUP function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column …

Continue Reading

MINVERSE function: Description, Usage, Syntax, Examples and Explanation

by

Examples of MINVERSE function Example 1 Steps to follow: 1. Open a new Excel worksheet. 2. Copy data in the following table below and paste it in cell A1 Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter. You can adjust the column widths to see all …

Continue Reading

Round numbers in Excel

by

This chapter illustrates three Mathematical functions ROUND, ROUNDUP and ROUNDDOWN. Navigation: Formula Tab → Function Library Group → Math & Trig Category Before your start: if you round a number, you lose precision. If you don’t want this, show fewer decimal places without changing the number itself. Round Syntax: ROUND(number, num_digits) 1. Round a number to two decimal places. …

Continue Reading

MUNIT function: Description, Usage, Syntax, Examples and Explanation

by

What is MUNIT function in Excel? MUNIT function is one of the Math and Trig functions in Microsoft Excel that returns the unit matrix for the specified dimension. Syntax of MUNIT function MUNIT(dimension) The MUNIT function syntax has the following arguments. Dimension: Dimension is an integer specifying the dimension of the unit matrix that you want …

Continue Reading

MULTINOMIAL function: Description, Usage, Syntax, Examples and Explanation

by

What is MULTINOMIAL function in Excel? MULTINOMIAL function is one of the Math and Trig functions in Microsoft Excel that returns the ratio of the factorial of a sum of values to the product of factorials. Syntax of MULTINOMIAL function MULTINOMIAL(number1, [number2], …) The MULTINOMIAL function syntax has the following arguments: Number1, number2, …    Number1 is required, …

Continue Reading

MROUND function: Description, Usage, Syntax, Examples and Explanation

by

What is MROUND function in Excel? MROUND function is one of the Math and Trig functions in Microsoft Excel that returns a number rounded to the desired multiple. Syntax of MROUND function MROUND(number, multiple) The MROUND function syntax has the following arguments: Number: The value to round. Multiple: The multiple to which you want to round …

Continue Reading

PI function: Description, Usage, Syntax, Examples and Explanation

by

Example of PI function Steps to follow: 1. Open a new Excel worksheet. 2. Copy data in the following table below and paste it in cell A1 Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter. You can adjust the column widths to see all the data, …

Continue Reading

9 Mathematical Computations Example using Excel Statistical Function

by

In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. This chapter gives an overview of some very useful statistical functions like: AVERAGE function, AVERAGEIF function, MEDIAN function, SUMIF function, MIN function, MODE function, STEDV function, LARGE function, SMALL function. Average To calculate the average of a …

Continue Reading

PMT, RATE, NPER, PV and FV Financial Functions in Excel

by

Learn all about Excel’s PMT, RATE, NPER, PV and FV To illustrate Excel’s most popular financial functions, we consider a loan with monthly payments, an annual interest rate of 6%, a 20-year duration, a present value of $150,000 (amount borrowed) and a future value of 0 (that’s what you hope to achieve when you pay off a loan). We make monthly payments, …

Continue Reading

25 Basic Excel Formulas and Functions Worked Examples

by

Mastering the basic Excel formulas is critical for beginners to become highly proficient in data analysis. A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. Every formula in Excel starts with an equal sign, then the function name and in bracket a …

Continue Reading

MOD function: Description, Usage, Syntax, Examples and Explanation

by

What is MOD function in Excel? MOD function is one of the Math and Trig functions in Microsoft Excel that returns the remainder after number is divided by divisor. The result has the same sign as divisor. Syntax of MOD function MOD(number, divisor) The MOD function syntax has the following arguments: Number: The number for which …

Continue Reading

SECH function: Description, Usage, Syntax, Examples and Explanation

by

What is SECH function in Excel? SECH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic secant of an angle. Syntax of SECH function SECH(number) The SECH function syntax has the following arguments. Number: Number is the angle in radians for which you want the hyperbolic secant. SECH formula …

Continue Reading

SUMIF function: Description, Usage, Syntax, Examples and Explanation

by

What is SUMIF function in Excel? SUMIF function is one of the Math and Trig functions in Microsoft Excel that is used to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger …

Continue Reading

BASE function: Description, Usage, Syntax, Examples and Explanation

by

What is BASE function in Excel? BASE function is one of the Math and Trig functions in Microsoft Excel that r converts a number into a text representation with the given radix (base). Syntax of BASE function BASE(Number, Radix [Min_length]) The BASE function syntax has the following arguments. Number: The number that you want to convert. …

Continue Reading

FLOOR function: Description, Usage, Syntax, Examples and Explanation

by

What is FLOOR function in Excel? FLOOR function is one of the Math and Trig functions in Microsoft Excel that rounds number down, toward zero, to the nearest multiple of significance. Syntax of FLOOR function FLOOR(number, significance) The FLOOR function syntax has the following arguments: Number: The numeric value you want to round. Significance: The multiple …

Continue Reading

SERIESSUM function: Description, Usage, Syntax, Examples and Explanation

by

What is SERIESSUM function in Excel? SERIESSUM function is one of the Math and Trig functions in Microsoft Excel that returns the sum of a power series based on the formula: Many functions can be approximated by a power series expansion. Syntax of SERIESSUM function SERIESSUM(x, n, m, coefficients) The SERIESSUM function syntax has the following …

Continue Reading

SUBTOTAL function: Description, Usage, Syntax, Examples and Explanation

by

What is SUBTOTAL function in Excel? SUBTOTAL function is one of the Math and Trig functions in Microsoft Excel that returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is …

Continue Reading

CEILING function: Description, Usage, Syntax, Examples and Explanation

by

What is CEILING function in Excel? CEILING function is one of the Math and Trig functions in Microsoft Excel that returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula …

Continue Reading

FACTDOUBLE function: Description, Usage, Syntax, Examples and Explanation

by

What is FACTDOUBLE function in Excel? FACTDOUBLE function is one of the Math and Trig functions in Microsoft Excel that returns the double factorial of a number. Syntax of FACTDOUBLE function FACTDOUBLE(number) The FACTDOUBLE function syntax has the following arguments: Number: The value for which to return the double factorial. If number is not an integer, …

Continue Reading

SEQUENCE function: Description, Usage, Syntax, Examples and Explanation

by

What is SEQUENCE function in Excel? SEQUENCE function is one of the Math and Trig functions in Microsoft Excel that allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. Syntax of SEQUENCE function =SEQUENCE(rows, [columns], [start], [step]) SEQUENCE(number of row, number of columns,starting number, step size) …

Continue Reading

TRUNC function: Description, Usage, Syntax, Examples and Explanation

by

What is TRUNC function in Excel? TRUNC function is one of the Math and Trig functions in Microsoft Excel that truncates a number to an integer by removing the fractional part of the number. Syntax of TRUNC function TRUNC(number, [num_digits]) The TRUNC function syntax has the following arguments: Number: The number you want to truncate. Num_digits(Optional): …

Continue Reading

CEILING.MATH function: Description, Usage, Syntax, Examples and Explanation

by

What is CEILING.MATH function in Excel? CEILING.MATH function is one of the Math and Trig functions in Microsoft Excel that rounds a number up to the nearest integer or to the nearest multiple of significance. Syntax of CEILING.MATH function CEILING.MATH(number, [significance], [mode]) The CEILING.MATH function syntax has the following arguments. Number: Number must be less than …

Continue Reading

FACT function: Description, Usage, Syntax, Examples and Explanation

by

What is FACT function in Excel? FACT function is one of the Math and Trig functions in Microsoft Excel that returns the factorial of a number. The factorial of a number is equal to 1*2*3*…* number. Syntax of FACT function FACT(number) The FACT function syntax has the following arguments: Number: The nonnegative number for which you …

Continue Reading

SIGN function: Description, Usage, Syntax, Examples and Explanation

by

What is SIGN function in Excel? SIGN function is one of the Math and Trig functions in Microsoft Excel that determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative. Syntax of SIGN function SIGN(number) The SIGN function syntax …

Continue Reading

MMULT function: Description, Usage, Syntax, Examples and Explanation

by

What is MMULT function in Excel? MMULT function is one of the Math and Trig functions in Microsoft Excel that returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. Syntax of MMULT function MMULT(array1, array2) The MMULT …

Continue Reading

CEILING.PRECISE function: Description, Usage, Syntax, Examples and Explanation

by

What is CEILING function in Excel? CEILING function is one of the Math and Trig functions in Microsoft Excel that returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. However, if the number or …

Continue Reading

EXP function: Description, Usage, Syntax, Examples and Explanation

by

What is EXP function in Excel? EXP function is one of the Math and Trig functions in Microsoft Excel that returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm. Syntax of EXP function EXP(number) The EXP function syntax has the following arguments: Number: The exponent applied …

Continue Reading

SIN function: Description, Usage, Syntax, Examples and Explanation

by

What is SIN function in Excel? SIN function is one of the Math and Trig functions in Microsoft Excel that returns the sine of the given angle. Syntax of SIN function SIN(number) The SIN function syntax has the following arguments: Number: The angle in radians for which you want the sine. SIN formula explanation If your …

Continue Reading

Posts navigation

  • 1
  • 2
  • 3
  • 4
  • …
  • 21
  • Next

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Extract multiple matches into separate rows in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel
  • How to use Excel NOT Function
  • How to use Excel XOR Function

Date Time

  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to show last updated date stamp in Excel
  • Add years to date in Excel
  • Get first day of month in Excel
  • Calculate date overlap in days in Excel

Grouping

  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel
  • Running count group by n size in Excel
  • How to randomly assign people to groups in Excel
  • Group numbers at uneven intervals in Excel

General

  • Sum by group in Excel
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • How to calculate project complete percentage in Excel
  • Subtotal by color in Excel
  • Convert column number to letter in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning