Formula and Functions

How to Round Values in Excel

If you need to Round values and numbers in Excel, perhaps round a value to the Nearest 100 or 1000 or if you want to round smaller values to a specific decimal place this guide will explain how.  Learn to…
Read more

Convert text case in Excel 2010

If you have ever been faced with text fields that contain poor formatting or capitalisation then you will find this guide on how to convert text fields to different cases a useful read… Convert text case with Excel 2010 Data…
Read more

Excel – Fix cell with #NA Error

Learn how to fix cells that show #NA after calculation with this short guide that explains why the error occurs and how to prevent the error from displaying those ugly #NA values all over your spreadsheet… Why does the #NA…
Read more