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
Posts
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
Google Forms – Changing the theme
We can make Google Forms a little more aesthetically pleasing by changing the theme and so that it can look a little more fun or professional and that it includes the colours that we want. Here we’ll look at: Changing the background colour Changing the header template Choosing a different form font Adding your own image… Continue reading Google Forms – Changing the theme
Google Forms (8) – Adding images and videos
[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|||”] In Google Forms, apart from text, we can add images and videos to enrich the form, and as always this is simple to do. Adding an image to a form You can add images to your form. On the… Continue reading Google Forms (8) – Adding images and videos
Google Forms (7) – More ways you can create better forms
[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|||”] Updated – Info on default settings added Once you’ve got to grips with the basics, it’s time to look at other ways you can make you form better. Here’s a selection of options Google Forms provides which are very… Continue reading Google Forms (7) – More ways you can create better forms
Google Forms – Managing your form’s responses
Once you’ve made your form and shared it, you’ll then want to see the responses and probably want to have a visual summary of them. Google Forms provides a wonderful graphical summary of the responses automatically right within Forms itself, so there’s no need to create charts yourself. Open your form and you’ll be in… Continue reading Google Forms – Managing your form’s responses
Google Forms – Types of questions
Google Forms contain lots of different types of questions which should match most of your needs. In this post we will look at the different options, looking at what they look like in the edit mode and on the final form. Question types menu 1) On the form edit page, click on “Multiple choice”. 2)… Continue reading Google Forms – Types of questions