How to Apply Long Date Format in Excel?
Dates in Excel are saved as serial numbers where the date January 1, 1900, is stored as the number 1, and each following day is
SPREADSHEET PLANET
Time Saving Excel Tips & Tutorials
I am Steve Scott and I regularly write about easy to follow how-to tutorials about Excel spreadsheets. I started this website as a side project to document some of the cool things I was learning in MS Excel, and now I am so happy that it reaches thousands on Excel learners every day.
Remember, Excel is not just a software – it’s a skill that can significantly boost your productivity and career. So dive in, explore the tutorials, and happy Excelling!
POPULAR EXCEL ARTICLES
LATEST EXCEL ARTICLES
Count Cells Less than a Value in Excel (COUNTIF Less)
Microsoft Excel is a powerful tool for data management and analysis. Sometimes in Excel, we want to count cells that meet some predefined criteria, such
Calculate the Coefficient of Variation in Excel
The coefficient of variation is one of the relative measures of dispersion. The ratio between the standard deviation and the mean is known as the
How to Sum a Column in Excel?
One of the essential operations in Excel is summing numbers in a column. So, for example, we can calculate a column to determine the total
3D Reference in Excel – What is it and How to Use it?
When working with Excel, most Excel users refer to cells/ranges in the same worksheet and sometimes may have to refer to other cells or ranges
How to Count Cells with Text in Excel?
One of the essential Excel operations to summarize data is counting the number of cells in a dataset containing particular data types. It’s a common