Cloud storage provides greater accessibility and rapid deployment of data, strong protection for data backup, and lower storage costs, making it an ideal storage platform. Saving workbooks to a file hosting service in the cloud, like OneDrive, allows you to access it from any computer as long as you have internet connection. It also makes […]

Continue reading

Before you share an electronic copy of a Microsoft® Excel® workbook, it’s a good idea to review the workbook for hidden data or personal information that might be stored in it, or in its document properties. This could be information about your organization or about the workbook itself that you do not want to share […]

Continue reading

Two weeks ago we shared a tip on how to quickly delete blank rows in a worksheet. Thank you for the comments we received on this tip, they didn’t go unnoticed. A lot of you have requested that we show you how to delete blank rows in a worksheet without deleting rows which have data […]

Continue reading

To maintain data integrity in your worksheet you can start by identifying cells that are blank, possibly due to data capturing error or because they have been left as place holders for vital information and forgotten. This gives you the opportunity to complete capturing and have a complete data set which is vital for data […]

Continue reading

When working in Microsoft® Excel® you probably have had to deal with removing blank rows. This, you may agree, is annoying and time consuming, especially if you have a large worksheet with thousands of rows. Well, instead of deleting the blank rows painstakingly one after the other, we’ll show you how you can delete them […]

Continue reading

Calculating depreciation, which is a decrease in an assets value, for a given period is vital for any business. It helps give an accurate picture of total assets which allows a business to have a better idea of its future cash flow or revenue strength. Luckily you can easily calculate depreciation in Microsoft® Excel® using […]

Continue reading

In order to perform a high-level analytical review of your purchases you may want to compare purchases made to prior financial years. To compare purchases to historic data, you need a formula that will work out which financial year the asset was purchased. To calculate the financial year in which the purchase was made, we […]

Continue reading

An asset register is pivotal to asset management. No matter what size your asset portfolio is, you need to keep a record of your asset information for asset planning, accounting and legislative compliance, and performance monitoring. To make things easier for you we’ve created an asset register template that you can freely download, customize and […]

Continue reading

Did you know that you can populate an entire data table using only on VLOOKUP formula? This can be done using VLOOKUP in an array formula.  You benefit by saving loads of time which leads to efficiency and a quicker turn around of the work.  Other benefits of Array formulas includes improved formula integrity and […]

Continue reading