Popup Calendar Addin for Excel

Entering dates in a worksheet confuses most Excel users. Nearly every user has faced a date format problem, which format should be used to enter date? Should we set the month first then day or other way? Which date separator to be used? Is it “/” or “-“? How will the date be parsed when … Continue reading Popup Calendar Addin for Excel

Calculate a Running Balance

Suppose you maintain an Excel workbook to record your income and expenses, and you want to know the current balance of cash in hand or bank balance at any given date. With a combination of absolute and relative references, Excel's SUM function does a great job to provide a fine solution to the problem. I … Continue reading Calculate a Running Balance

Data Validation – Use a Formula to Validate Email Addresses

Data validation is a powerful Excel feature that can be used to restrict what data can or should be entered in a cell. You can setup data validation to prevent users from entering invalid data. In this post I am sharing with you a tip on how to  setup data validation setup to restrict users from entering invalid … Continue reading Data Validation – Use a Formula to Validate Email Addresses