Diameter Formula in Excel
The diameter of a circle or a sphere is the length of the straight line connecting the center of the circle or sphere…
Category: examples
Convert Julian Date to Calendar Date in Excel
The Julian date format uses the combination of a year and the number of elapsed days of the year. Julian dates are mostly…
Yellow Box in Excel
Sometimes when you select a cell in an Excel dataset that has data validation enforced, a yellow box pops up with certain information….
Wrap Date in Excel Cell
As we work with dates in Excel, sometimes we may want to wrap dates in cells to achieve a custom visual effect. A…
Find Last Cell with Value in a Row in Excel
Finding the last cell with value in a row is a very common task in Excel. It can be very time-consuming especially if…
Insert a Table within a Cell in Excel
Excel cells are designed to hold numbers, text, formulas, dates, times, pictures, or shapes but not tables. Excel tables are specially designated areas…
Insert a Tab Character in a Cell in Excel
In word-processing applications such as Microsoft Word, it is easy to insert Tabs. The tabs are used to align text by moving the…
Using Brackets in Excel
Excel uses round brackets ( ), square brackets [ ], and curly brackets { } for different purposes. It is important to know…
Chart with Positive and Negative Numbers in Excel
Sometimes you may want to create an Excel chart based on a dataset that has positive and negative numbers. In this tutorial, we…
Select the First Cell in the Range in Excel
In this tutorial, we will look at the following 3 methods that we can use to select the first cell address in a…