by Ilker | May 29, 2019 | Excel Formulas
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...
by Ilker | May 28, 2019 | Excel Formulas
The Excel GCD function is a Math formula that returns the greatest common divisor (GCD) of two or more numbers. The greatest common divisor of a set of values is the largest positive number that divides each number. In this guide, we’re going to show you how to use...
by Ilker | May 28, 2019 | Excel Tips & Tricks
Excel Table is a feature used for managing and analyzing data in a tabular format. This way, you can display data in a neat and concise structure, while also including filtering abilities, easy-to-use formatting and layout options, and automatically updating any...
by Ilker | May 28, 2019 | Excel Tips & Tricks
A name in Excel is used for referencing a cell, range, formula, or constant value for easier and faster access to those references. These names are called named ranges in Excel. Using named ranges in your workbook models can save you time and increase your efficiency....
by Ilker | May 27, 2019 | Excel Formulas
The Excel CEILING function is a Math formula that rounds a given number up to the nearest multiple of significance. This function is the predecessor of the CEILING.MATH function which was released in Excel 2013. In this guide, we’re going to show you how to use the...
by Ilker | May 24, 2019 | Excel Formulas
The Excel FLOOR function is a Math formula that rounds a given number down to the nearest multiple of significance. This function is predecessor of the FLOOR.MATH function that was released in Excel 2013. In this guide, we’re going to show you how to use the FLOOR...
by Ilker | May 24, 2019 | Excel Formulas
The CEILING MATH (CEILING.MATH) is a Math function that rounds a given number up to the nearest multiple of significance. This function has been released with 2013 version as a replacement for the CEILING function. In this guide, we’re going to show you how to use the...
by Ilker | May 22, 2019 | Excel Tips & Tricks
Excel is one of the best platforms to do stock quote analysis. However, you traditionally had to pull this data either manually, or using third party tools. Now, you can do this using built-in Excel features if you are running Office 365. In this article, we are going...