• Formulas
  • Examples
  • VBA
  • Functions
  • Shortcuts
  • Shop
  • Cart
  • About

Category: formulas

Calculate Normal Distribution Probability in Excel

There are a lot of statistical measures and terms that are used and can be calculated using Excel. One of these terms is…

Posted On 1 Sep19 Feb

Mood’s Median Test in Excel 

Although Excel has many built-in formulas that fall under many categories: statistical, mathematical, logical, and many more, there are some things that cannot…

Posted On 28 Aug19 Feb

Excel VLOOKUP and MID for Data Analysis

Excel formulas are made in a way that complicated things can seem easy. There is always an option to combine the formulas to…

Posted On 24 Aug19 Feb

Excel SUMIF with INDEX & MATCH

Although Excel formulas are powerful as a standalone option, their true power can be seen when combined. INDEX and MATCH are two formulas…

Posted On 24 Aug19 Feb

Using the LINEST function

A LINEST function is a great tool that can be used in Excel or Google Sheets. With this function, we can perform linear…

Posted On 1 Aug19 Feb

Linear Interpolation in Excel

If we talk about linear interpolation in Excel, we first need to understand what this term is. Linear interpolation is a method from…

Posted On 27 Jul19 Feb

Difference Between LOOKUP and VLOOKUP Functions

VLOOKUP is one of the most widely used formulas in Excel. A similar formula, from the same family for that matter, is LOOKUP,…

Posted On 27 Jul19 Feb

Using HLOOKUP in Excel to Retrieve Text Values

To retrieve text values using HLOOKUP in Excel, you must use the asterisk (*) wildcard. For example, you can use HLOOKUP with the…

Posted On 18 Jul19 Feb

Adding Hexadecimal Numbers in Excel

Hexadecimal numbers, also known as hex numbers, are a number system frequently utilized in computing and programming. Unlike the decimal system, which has…

Posted On 18 Jul19 Feb

Combining MATCH, INDEX, and OFFSET in Excel

All of the formulas in Excel are great on their own. Better yet, these formulas are even better when combined. In the example…

Posted On 18 Jul19 Feb

Posts pagination

1 2 3 … 17 Next

Connect with us

  • English
  • .
  • Polski
© 2025 OfficeTuts. All Rights Reserved.
  • Formulas
  • Examples
  • VBA
  • Functions
  • Shortcuts
  • Shop
  • Cart
  • About