VBA Macro Codes to Filter Data In Excel
Excel offers a lot of built-in filtering options. You can do a lot of basic and advanced filtering using the in-built options. But with VBA,
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 Create Custom Lists in Excel?
Excel has a fantastic feature called Custom Lists that lets you create your own lists and quickly apply them in various ways. When you create
#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
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