Uncategorised

Insert Dates in Excel

result month auto

This tutorial covers how to insert dates in Excel. The Date Format Like numbers, currency, time and others, the date is a quintessential number format in Excel. Though Excel tries its best to auto-recognize data types, it doesn’t always succeed. To manually apply the date format to a cell or group of cells, select the…

Read More

Cell References

mixed ref

In order to make accurate calculations it’s essential to understand how the different types of cell references work. A1 vs. R1C1 References Excel worksheets contain many cells and (by default) each cell is identified by its column letter followed by its row number. This is known as A1-style referencing. Examples: A1, B4, C6 Optionally, you…

Read More