Excel Tips

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. Fowmy AbdulmuttalibFowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed by McDonald’s […]

Calculate a Running Balance Read More »

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. Fowmy AbdulmuttalibFowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed

Data Validation – Use a Formula to Validate Email Addresses Read More »