We generally use data to give us information on something and to help us make more informed decisions. However, human beings aren’t very good at looking at a set of numbers and working out whether there is a trend or whether something looks unusual. This is where charts are invaluable. The old adage of a… Continue reading Google Sheets – How to use Sparklines (mini-graphs)
Author: bazroberts
Google Sheets – What’s the difference between notes & comments?
In this post, we’re going to look at two key ways you can add extra information to your sheet, without affecting the format of your sheet: Notes and Comments. Sometimes people confuse these, as they both give extra information in the cells, but there is a clear difference between the two. The key difference is:… Continue reading Google Sheets – What’s the difference between notes & comments?
Google Sheets – Conditional Formatting & custom formulas
Sometimes we spend time colouring in our sheets so that the data is more visible, in a way that it can be read and understood really quickly and that the most important points can be ascertained with ease. Wouldn’t it be great if Sheets could colour your data automatically, depending on a set of conditions? Well,… Continue reading Google Sheets – Conditional Formatting & custom formulas
Google Sheets – Filtering your data
Let’s look at how you can filter your data to show a particular aspect of it. There are two ways to do this: Filter (by value & by condition) Filter View Filter – By value If we have a set of data, we can add some filters to enable us find the information we want. In… Continue reading Google Sheets – Filtering your data
Google Sheets – Moving, copying & pasting data
In this post, let’s look at how we can move, copy and paste our data on the sheet, starting with the basics and then introducing some lesser-known methods that will save you time and effort. Moving cells (drag & drop, cut & paste) Copying and pasting cells Paste special (values, format, all except borders, formulas, transpose)… Continue reading Google Sheets – Moving, copying & pasting data
Google Sheets – The cell references: Relative & Absolute
Here we’re going to look at how references to cells will allow you to do multiple calculations really quickly. We’ll look at: How to reference cells with each other How to quickly copy formulas across other cells How cell references change when they are moved around the sheet (relative cell references) How you can fix… Continue reading Google Sheets – The cell references: Relative & Absolute
Google Sheets – Controlling rows & columns (Part 2)
Let’s look at some further ways you can control your rows and columns: Selecting multiple rows or columns There are two ways to select more than one row or column. First, if the rows or columns you want to select are all next to each other, then simply click on the first one and drag… Continue reading Google Sheets – Controlling rows & columns (Part 2)
Google Sheets (1) – The basics
[et_pb_section bb_built=”1″ admin_label=”section”][et_pb_row admin_label=”row” background_position=”top_left” background_repeat=”repeat” background_size=”initial”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” border_style=”solid” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.51″ custom_margin=”-100px|||”] Google Sheets is a wonderful spreadsheet program which can make your working life so much easier. So, what can it be used for? Calculations The number one use is manipulating data. Data is entered and the program can then be… Continue reading Google Sheets (1) – The basics
Creating multiple short URLs in seconds
[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.0.47″ custom_padding=”4px|0px|37.9062px|0px|false|false”][et_pb_row admin_label=”row” _builder_version=”3.0.48″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″][et_pb_text admin_label=”Text” _builder_version=”3.21.1″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] The Google Url Shortener has closed down. Wouldn’t it be better if instead of sharing a long link like the one below, you could get a shorten version of it? Well, you can and Google provides… Continue reading Creating multiple short URLs in seconds
Google Forms – Creating personalized forms automatically
Pre-filling Google forms Why would you want to pre-fill parts of a Google Form? To ensure the information is in the format you want The data format is consistent Consistent data means it’s easier to analyze afterwards It’s quicker for the person to fill out your form It adds the personal touch, if you add their… Continue reading Google Forms – Creating personalized forms automatically