by Ilker | Nov 25, 2019 | Excel Tips & Tricks
Data doesn’t always come in a nice table layout, especially, when you retrieve it from an external source like a web site. Thanks to the Excel Text to Columns feature, you can split data into multiple columns. In this article, we are going to show you how to use...
by Ilker | Nov 22, 2019 | Excel Tips & Tricks
Excel is a fairly an efficient software given that it can perform complex calculations. However, depending on your system, it can also get pretty slow when running complicated calculations. How formulas are used, and size of the workbook are typically the culprit if...
by Ilker | Nov 22, 2019 | Excel Formulas
RANK.AVG (RANK AVG) is a Statistical function that can return the rank of a given value, within the specified array of values. If there are values that share the same rank, the average rank of that set of values will be returned. In this guide, we’re going to show you...
by Ilker | Nov 22, 2019 | Excel Formulas
The RANK.EQ function is a Statistical formula that returns the rank of a given value, within the specified array of values. If there is more than one values that share the same rank, the higher rank of that set of values is going to be returned by the formula. In this...
by Ilker | Nov 21, 2019 | Excel Formulas
The AVERAGEA in Excel is a Statistical function that can calculate and return the average (arithmetic mean) of the values of a range of cells. AVERAGEA differs from the AVERAGE function in its ability to include numbers in string format and logical values in the...
by Ilker | Nov 21, 2019 | Excel Tips & Tricks
A loop is an essential concept for any programming language, and VBA follows the same approach. You can use loops to repeat an action until a specified condition is reached, or move through objects in a group, e.g. all worksheets in a workbook. A loop is an essential...
by Ilker | Nov 19, 2019 | Excel Tips & Tricks
Control Shift Enter Excel shortcut, as known as CSE, is a key combination you can use to apply array functions.CSE abbreviation is also used for array formulas that are entered using the Control + Shift + Enter key combination when entering a formula. Array formulas...
by Ilker | Nov 18, 2019 | Excel Tips & Tricks
In this guide we’re going to go over 10 things you should know about the frequently-used-yet-not-so-easy-to-use VLOOKUP Excel function. Although this guide mainly focuses on the VLOOKUP function, these tips also apply to the HLOOKUP function, which essentially...
by Ilker | Nov 4, 2019 | Excel Tips & Tricks
When it comes to date and time values, Excel evaluates them a bit differently than how we process them. For Excel, date and time values are numbers in a date or time display. Although this behavior allows making date and time calculations easier, it can be helpful to...
