## Workout Tracker, Calorie Counter…All in Excel

‘New year, new me’… how many times have you heard that? Or even said it yourself? After eating too much over the festive season, we were feeling guilty and began looking for redemption online. We found some useful Excel spreadsheets which could help you (and us!)...

Applying styles to your spreadsheets is not simply a matter of style over substance. Formatting allows you to emphasise and delineate your data, enhancing both its clarity and your presentations. Styles is a tool that allows you to more quickly and easily apply consistent formatting to your spreadsheet using...

## How to Represent Trends with Sparklines

Sparklines are very small charts that fit within a line of text or a single cell of a spreadsheet. They’re a great way to give your data some context without taking up half the page with various bulky charts. As they are so small, they are typically...

## How to Format Numbers in Excel

Excel is, at its heart, a programme that manipulates numbers: so getting your numbers to appear as you want is an important skill. The appearance of a number entered in an Excel cell can be changed in many different ways. This blog post shows you...

## How to Forecast using Average Percentage Growth

Average percentage growth tells us how fast something has grown, and eventually forecasts the future through extrapolation.   There are different ways of calculating average growth in Excel (e.g. LOGEST, LINEST, lines of best fit, etc.) and some of these will give different results. Let’s take a...

## Spotting Inconsistencies with “=…=…”

Inconsistencies can creep into spreadsheets for a range of causes: data-entry errors; accidental changes made to the data after entry; inconsistently applied rounding or changes to units; or differences in the way numbers are formatted in different systems.   The following is a simple technique which can...

## Done In 60 Seconds – Cumulative Sums

Have an ordered list of items, each with an assigned value such as revenue or cost, which you need to analyse and understand? Perhaps you need to know how these numbers are adding up in order to be alerted to business limits (budgets, deadlines etc,) being approached...

## How To Excel – Use Filters to Get the Data You Want

Excel gives you many options when it comes to filtering your data. If you have a database with numerous entries, you can filter the data so that only the relevant information appears. Then, when you remove the filter, you can see all of your data...