by Ilker | Dec 10, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to allow users to enter date values only for the current week in Excel. Download Workbook To limit the user interaction with input cells, you can define validations. You might be familiar with data validation from dropdown...
by Ilker | Dec 8, 2020 | Excel Tips & Tricks
It can be a challenge to make data entry consistent in concurrent use. A common example is entering a future date into a form. In this article, we are going to show you how to prevent future dates in Excel. Download Workbook To limit the user interaction with the...
by Ilker | Nov 27, 2020 | Excel Tips & Tricks
Formula intersections can help simplify your formulas. There are 2 types of intersections in Excel: implicit and explicit. In this guide, we’re going to show you implicit vs explicit intersections in Excel. Download Workbook Implicit Intersections If you are using...
by Ilker | Nov 25, 2020 | Excel Tips & Tricks
If you are working with data from different sources, you’ve more than likely came across unwanted spaces in the data. In this guide, we’re going to show you how to remove spaces in Excel. Download Workbook There are mainly two ways you can use to remove spaces...
by Ilker | Nov 24, 2020 | Blog, Excel Tips & Tricks
A box-and-whisker chart is a visualization of groups of numerical data and their quartiles in the data set. Originally named boxplot chart, this visualization gets its name from a box that represents the lower and upper quartiles, and lines extending from the box...
by Ilker | Nov 23, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to create a sequence of dates in Excel using the Auto Fill feature. Download Workbook AutoFill is the action of dragging the small square at the bottom-right corner of a cell. The small square is called the fill handle....
by Ilker | Nov 23, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to create a dynamically changing calendar in Excel. Download Workbook Populate variables First step is creating the variables to be used in the formulas. These variables need to provide the present day information so that...
by Ilker | Nov 20, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to change case in Excel using different methods. Download Workbook Unlike in Word, Excel doesn’t have any built-in features that can help modify the text case. However, some of the methods we will be looking at in...
by Ilker | Nov 18, 2020 | Excel Tips & Tricks
Did you know that Emojis have been around since 1997? They essentially became an integral part of most written communication methods. In this article, we are going to show you how to use emojis in Excel. Download Workbook How to insert an emoji in Excel You can insert...