Many people use spreadsheets to record financial transactions. When entering numbers into a spreadsheet, by default, you'll not see a currency. Instead, the numbers are entered without any association to a specific currency. In this article, you'll find out how to add a currency to a range of cells. You'll also ...
When you open a new spreadsheet in Google Sheets you'll notice the numbers are formatted in a particular way. This is fine if you're working on a basic spreadsheet and you want some quick results. However, there will be a time when you need to format the numbers to suit your project. This article looks at all the ...
Google Sheets is the free spreadsheet program available to everyone. Whether you use a Chromebook, Windows PC or Apple Mac you can access Google Sheets from the Chrome web browser. All you need is a Google Account and you're good to go. This complete guide is currently a work in progress and you'll find more ...
One of the most popular and powerful options in Google Sheets is the vlookup function. This powerful yet simple function allows you to do so much when using a spreadsheet. Learning how to do a vlookup may appear difficult at first. However, once you have got used to how it works you will have no problem adding the ...
Conditional formatting is a really useful tool as it allows you to immediately analyse data with visuals. When you have lots of data on a spreadsheet it can easily become a sheet of noise. Conditional formatting in Google Sheets helps you to make certain data highlighted, so you can easily see the data you need to be ...
When using spreadsheets you'll most likely come across a time when the text in cells is no longer visible. There are a few ways to fix this. This article will look at the different methods and explain how to wrap text in Google Sheets. What happens when text no longer fits in a cell in Google Sheets If there is no ...
The average function in Google Sheets is an essential function for anyone wanting to find out an average number from a range of cells. Using the Average function in Google Sheets So let's take a look at how to use the average function in Google Sheets. In the following example, we've got a list of numbers in column A ...
Let's take a look at how to divide numbers in Google Sheets. To divide a number in Google Sheets you use '/' in the formula to divide one number from the other. Dividing numbers in Google Sheets In the example below you can see there is the number '100' in cell A1 and we want to divide this number by '3', which is the ...
Multiplying numbers in Google Sheets is an easy process and is very similar to other basic calculations you can do in spreadsheets. We'll take a look at two different ways of multiplying numbers in Google Sheets. First, we'll look at using a formula to multiply one number inside a cell by another number in a ...
There are many different ways you can choose to subtract numbers in Google Sheets. Let's take a look at the most basic first. Then we'll take a look at other ways to subtract numbers in Google Sheets. Subtracting a number from one cell In the example below, we've got the number '10' in cell A2 and the number '5' in ...
Google Sheets is a spreadsheet program that you access from the internet. All of the work you do with Google Sheets is done online. This has many advantages because it means you don't need to worry about making sure you have the latest version. It also means you can share certain worksheets with your colleagues, so ...
Adding numbers together in Google Sheets is easy to do. Spreadsheets are extremely powerful programs and learning how to do basic calculations is important. Once you've mastered how to do the basics you'll feel more confident using a spreadsheet program such as Google Sheets. Let's take a look at how to add numbers in ...
Dan Millward