5 Ways to Create an Excel Named Range

5 Ways to Create an Excel Named Range

by | Jun 10, 2019

Named ranges are cells, ranges, tables, formulas, or constant values that are represented with meaningful names, that are tied to their workbook reference (i.e. A1, B23, A1:B23). Using named ranges make formulas easier to read and maintain. In this guide, we’re...
Function: LOG10

Function: LOG10

by | May 31, 2019

The LOG10 Excel function is a Math formula that returns the logarithm of a given number, using base 10. The logarithm of a given number is the exponent to which another fixed number (the base 10) must be raised to produce that number. In this guide, we’re going to...
Function: LOG

Function: LOG

by | May 31, 2019

The Excel LOG function is a Math formula that returns the logarithm of a given number and base. In this guide, we’re going to show you how to use the LOG function and also go over some tips and error handling methods.Supported versionsAll Excel versionsExcel LOG...
Function: LN

Function: LN

by | May 31, 2019

The Excel LN function is a Math formula that returns the natural logarithm of a given number. The natural logarithm of a number is the power to which e would have to be raised to find that number. Natural logarithms are based on the constant e which is approximately...
Function: EXP

Function: EXP

by | May 30, 2019

The Excel EXP function is a Math formula that returns the value of the constant e (Euler’s number) raised to the power of a given number (ex). The constant e is approximately equal to 2.71828, which is the base of the natural logarithm. In this guide, we’re...
How to create calculated columns in Excel tables

How to create calculated columns in Excel tables

by | May 29, 2019

Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. In this guide, we’re going to...
Function: FACTDOUBLE in Excel

Function: FACTDOUBLE in Excel

by | May 29, 2019

The FACTDOUBLE is a Math function that returns the double factorials of a given number. Also known as the semi-factorial, double factorials of a number (n) is shown as n!! and is equal to n x (n-2) x (n-4) x ... 4 x 2 for an even number, and n x (n-2) x (n-4) x ... 3...
Function: FACT

Function: FACT

by | May 29, 2019

The Excel FACT function is a Math formula that returns the factorial of a given number. Factorial of a number n (denoted as n!) is the product of all numbers that are less than or equal to that number (n! = n x (n-1) x (n-2) x … x 2 x 1).  Frequently used in...
Function: LCM

Function: LCM

by | May 29, 2019

The Excel LCM function is a Math formula that returns the least common multiple (LCM) of two or more numbers. Also known as lowest common multiple or smallest common multiple, the least common multiple will give you the smallest positive number that is divisible by a...