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

## Excel reveal formulas – Learn how to display all formulas

Excel Formulas can be revealed for easier correction and error checking, find out how to easily reveal all Excel formula within a workbook in this guide. Excel Reveal Formulas Excel formulas can get complicated quite fast and, especially on those…

## 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 insert a line break or carriage return into an Excel cell

There are times when the ability to spread written text in a cell over two or more lines is useful, this is often referred to as a line break or a carriage return and this post will show you how…

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

## How to calculate the difference in days with Excel

Calculating the difference between two dates in Excel is a usfeul technique to understand, especially in the business environment, read on and I’ll show you how to calculate the difference between two dates in Excel… In order to calculate the…

## How to split a text field into parts using Excel’s LEFT, RIGHT, SEARCH and LEN functions

Are you one of the many Excel users out there having to deal with text fields in unusable formats? If so this guide will help you gain an understanding of how to use Excel’s SEARCH, RIGHT, LEFT and LEN functions…

## How to change the colour of an Excel Worksheet tab using a cell value with VBA

Changing the colour of a worksheet tab based on a cell value is a useful technique to have up your sleeve.  There are many practical applications for this technique and it is particularly useful for those times when automatically sending…

## How to save an Excel file with today’s date using VBA

Regular Excel reports benefit from having the date saved in the filename, learn how to automate this process through VBA in this how to guide…   There are many occasions when you need to add a date to a file…

## How to automate dates in an Excel title from your dataset or chart table

Are you tired of constantly changing dates in your Excel report titles?  Perhaps you have been embarrassed by forgetting to update the title before emailing your Excel report out?  Well no more, automate the title so you can forget about…