How can we help?

Close
icon

Give us a call

Our team of experts are on hand and ready to help.

0161 883 2655
icon

Live chat

Ready to chat data? That's what we're here for

icon

Submit an enquiry

Fill out your details and one of the team will be in touch

Get in touch
Graphic
Graphic

How to Round a Number in Excel

Read time: 1 minute

Round a Number in Excel In the example below there are 7 employees A to G and their monthly sales total. This is how you would round these numbers up to the nearest £1. Using the formula =ROUND(C3/1,0)*1 you can easily round the monthly sales total to the nearest £1. In excel you can use […]

How to Create a Chart in Excel

Read time: 1 minute

Creating a chart in Excel allows you to visualise your data and make more sense of it. Here’s how to create a chart. Highlight the required data Select ‘Insert’ to choose either a chosen chart, or a chart type recommended by Excel Insert the chart Add titles, axis labels and colours for professionalism Excel offers […]

How to do IF Function Excel

Read time: 1 minute

The IF function in Excel can be very helpful for data analysis and conditional formatting. Below is an example of a way that the IF function can be used. The general formula for an IF function is: =IF(cell value, “value if true”, “value if false”) . For a value “greater than” you use > For […]

Import Data in Excel

Read time: 1 minute

Working with Excel inevitably means handling data, but sometimes this data comes from a source other than Excel. This can be from a text file, word document, webpage or any other source. Usually copying and pasting data doesn’t format correctly, leading to errors and poor data security. In the example below we are trying to […]

How to Manually Enter Excel formulas

Read time: 1 minute

If you have a large amount of data that you need to find the sum of, rather than doing =SUM(C3+C4+C5) etc. there is a much quicker way to manage your data. By using the formula =SUM(C3:C21) you are automatically including every cell between and including C3 to C21. Then press enter and your sum will […]

How to do Conditional Formatting in Excel

Read time: 1 minute

Conditional formatting in Excel allows you to format a single cell or group of cells according to the data within them. In Excel you can chose to format a cell with highlights, data bars, colour scales or icons due to the rules that you can set; ultimately opening up endless data visualisation possibilities. If you […]

1 2 3 4 6 7
Sign up to our newsletter and stay up-to-date with our latest news

"*" indicates required fields

This field is for validation purposes and should be left unchanged.