Excel Tips and Tricks
How to enter dates only in the current week in Excel
In this article, we are going to show you how to allow users to enter date values only for the current week in Excel. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2020/12/How-to-enter-dates-in-the-current-week-only-in-Excel.xlsx" type="big"...
How to prevent future dates from being entered in Excel
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. [button...
Implicit vs Explicit Intersections in Excel
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. [button...
How to remove spaces in Excel
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. [button...
Box-and-Whisker Charts
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...
How to create a sequence of dates in Excel - Autofill
In this article, we are going to show you how to create a sequence of dates in Excel using the Auto Fill feature. Download...
How to create a dynamically changing calendar in Excel
In this article, we are going to show you how to create a dynamically changing calendar in Excel. ...
How to change case in Excel
In this article, we are going to show you how to change case in Excel using different methods. Unlike in Word,...
How to use emojis in Excel
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. [button...