If you have a worksheet with a lot of data and you want to ensure your data integrity, you need to make certain that there are no duplicates in your data. Trying to find and remove duplicates in your worksheet can be like trying to find a needle in a haystack. Fortunately the Remove Duplicates […]

Continue reading

Here’s a roundup of the top 5 tips, based on how many of you clicked on the links to view them: How to quickly delete blank rows in a worksheet When working in Excel you probably have had to deal with removing blank rows. This, you may agree, is annoying and time consuming, especially if […]

Continue reading

To make a number easy to read, or to make it a ‘round’ number you can format it to only show a certain number of decimal places regardless of how many are actually in the cell. Instead of having to use your mouse to format the cell in a number of steps, you can do […]

Continue reading

If you have data in your Microsoft® Excel® worksheet that spans across a lot of columns, you won’t see all of your data on your screen. To view different columns, you need to scroll from one side of the sheet to the other. Most people would use the scroll bar, but there’s a quicker and […]

Continue reading

Last week we showed you how you can keep your company in good standing by honouring your loan installments, and we showed you how to work out your loan installment using an interactive financial program. In relation, it’s important to know the periodic payment, principal amount and interest rate that you’ll be paying, which you […]

Continue reading

If your company has a loan, to keep it in good standing, you need to ensure that loan installments are honored. Knowing how much the installment is, and how often it has to be paid, will help you manage your finances better. Last year we shared a tip on how to use the PMT Function […]

Continue reading

A data validation list is an excellent feature that helps you quickly enter correct information into a data range. Let’s say you are entering departments, wouldn’t you rather select the names from a drop down list instead of typing? A dynamic data validation list is a better option. With a dynamic list as you edit/update […]

Continue reading

We recently closed Fiscal Year 2014 and are now in Fiscal Year 2015, you can imagine how much work was on our finance team’s plate especially with the beloved auditors roaming in our offices! If you haven’t yet approached your financial year-end, this tip will help you ensure that you don’t miss it by helping […]

Continue reading

If you have an investment and would like to know the exact date that it will mature, use the EDATE function. Let’s say your investment will give a yield in 12 months, but you want to know the actual date, you can calculate it with the EDATE function which returns a serial number representing a […]

Continue reading