#REF! Error in Excel
An error in Excel called “#REF!” (with REF standing for reference) happens when a formula refers to an invalid cell. This usually occurs when cells
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
How to Write Scientific Notation in Excel?
Scientific notation is commonly used by mathematicians, engineers, and statisticians when they are writing very large numbers or very small numbers. MS Excel offers some
Extract Last Word in Excel
As you work with data in Excel, you might need to extract the last word in a cell, for example: This tutorial shows five techniques
Convert Number to Percentage in Excel
In Excel, we frequently calculate and enter growth rates, efficiency rates, success rates, discount rates, tax rates, interest rates, etc. In general, we have to
How to Find the Largest Value in Excel
Finding the largest value from the given values is important when making decisions about things like what is the highest score in the class or
How to Ungroup Sparklines in Excel
Sparklines allow you to place small charts within the cells in a worksheet in Excel. You can have your data in a row and then