# Formula and Functions

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

## How to Calculate Percentage (%) Change in Excel

How to calculate the percentage change between two periods in Excel is a regular question I get asked by Excel analysts but if you read on you’ll find out that it is really quite simple… When creating reports with history,…

## How to format a text date into an Excel date

A date in text format can pose a problem for Excel users making date calculations, PIVOT Table groupings and general reporting impossible.  Learn how to convert a text date into a true date format with this guide…. The most common…