# Formula and Functions

## Removing blank characters, AKA Non-breaking spaces, from Excel text strings

If you have an issue where Excel’s TRIM function does not appear to be removing the blank spaces in your text string, or you are trying to remove blank characters/non-breaking spaces from a text string then read on to learn…

## 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…

## How to remove leading spaces from Excel cells

When leading spaces, or blank characters, make their way into your data they can cause havoc on your Excel lookups and lead to inaccurate reports.  Learn how to remove the leading spaces from the Excel cells and how to take…

## How to calculate the number of working days between two dates in Excel

For any Excel users out there involved in project work learning how to calculate the number of working days between two dates is a very useful skill.  Learn how to calculate the number of working days between two dates in…

## Excel – Fix cell with #VALUE Error

Learn how to fix cells that show #VALUE after calculation.  This guide explains why the #VALUE error occurs and will teach you how to prevent it occurring on your reports…   What causes the #VALUE Error The #VALUE error will…

## 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…

## How to Calculate Correlation Coefficients in Excel 2010

If you need to test for any correlation between 2 variables using Excel 2010 then read on to find out exactly how… In a business environment the Excel analyst will often be asked to prove theories and test concepts, one…

## 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…

## Microsoft Excel Sum Formula explained

Microsoft Excel Sum Formula The Sum Formula in Microsoft Excel is probably one of the first formulas you should learn when you start using Excel.  It is part of what makes a spreadsheet so useful, the ability to perform quick…

## Adding time values in Excel – How to guide

Adding time values in Excel is a simple technique to master.  Learn how to make sure your result is accurate each time with this how to guide for Excel – Adding Time Values… Time values are often found in Excel…