by Ilker | Nov 22, 2022 | Excel Tips & Tricks
If you ended up in this article, it's a big probability that you had referred a column or cell in your Excel table and press F4 and finally heard the annoying chime. Fortunately, you haven't given up and made manual changes on the references. In this guide, we’re...
by Ilker | Nov 2, 2022 | Excel Tips & Tricks
You might have already seen that Excel's date-related functions return errors or incorrect values with external data. The most common reason is the difference between date formats, such as reverse day and month figures. Usual scenario between US and European...
by Ilker | Nov 1, 2022 | Excel Tips & Tricks
Date formats vary between countries. If you need to work with external source reports from a different country, you may see that Excel doesn't recognize the dates or recognize them wrongly. The most common case happens between US and European countries because of the...
by Ilker | Sep 30, 2022 | Excel Tips & Tricks
Excel's Grouping is a very useful tool to display the data in a compact view. The feature allows you to hide the less prior data to let the major values remain visible. In this article, we are going to show how to group columns in Excel. Download Workbook Grouping...
by Ilker | Sep 9, 2022 | Excel Tips & Tricks
Although swapping two cells sounds easy, it may become complicated what you want to be swapped or not. In this article, we are going to show how to swap two cells in Excel for several scenarios. Download Workbook Swapping two adjoining cells Let's start with the...
by Ilker | Sep 8, 2022 | Excel Tips & Tricks
Descriptive statistics are summarizations of your dataset. This summary includes mean, median, mode, standard deviation, variance, minimum and maximum variables, kurtosis, and skewness. Excel can generate all these measures for a selected range in a proper table. In...
by Ilker | Sep 7, 2022 | Excel Tips & Tricks
A subtotal is the aggregation of a data set, typically showing the totals of a certain section in that data set. Excel gives you tools to calculate subtotals in different ways. In this article, we are going to show how to use the subtotal feature in Excel. Download...
by Ilker | Sep 6, 2022 | Excel Tips & Tricks
You might think "as the crow flies" distance is nothing more than a simple hypotenuse calculation back from geometry class. Unfortunately, not. You should work with either decimal degrees or degree-minute-second (DMS) notation due to the curvy structure of Earth. This...
by Ilker | Jul 26, 2022 | Excel Tips & Tricks
If you are in this page, you are probably aware of the advantages of Excel Tables and using them. Also, you probably wonder why you cannot use its special references, also known as structural references within data validation list. Although Excel is still not...