Everything You Need in Excel
This site aims to teach you everything you need to know about Microsoft Excel.
- Tips
- Tricks
- Templates
- Tutorials
- Example Files
- Best Practices


How to Count Only Filtered Cells in Excel [6 Ways]
By Tamal Das
Are you tired of counting filtered cells in Excel using conventional formulas, only to realize that the count includes hidden…
How to Calculate Price Per Square Foot in Excel: 5 Easy Ways
By Tamal Das
Are you tired of manually calculating the price per square foot of properties, products, or services? Do you want to…
How To Add Trailing Zeros in Excel [11 Methods]
Do you need to add leading zeros in Excel like 000203? Default Excel will not allow you to add trailing zeros…
How to Create a Random SSN Generator in Excel: 5 Proven Methods
By Tamal Das
Are you tired of manually creating Social Security Numbers for your database or testing? Say goodbye to such boring and…
How to Round To the Nearest Dollar in Excel [9 Ways]
If you have received the data with decimals and round to the nearest numbers in Excel for further analysis. This…
How to Convert 8 Digit Number to a Date in Excel [6 Ways]
You want to convert 8 digits text representing date to Date in Excel for your project. This article explains how…