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…
Author: Christopher Sirali
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 Cell in Excel
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…
Excel Chart with Positive and Negative Numbers
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…
Escape Special Characters in Excel
Some characters that we may want to include in a cell in Excel are special characters in that they are used by the…
