Lists are great for summarising points and showing the order of something concisely. Docs gives you various ways you can present lists. These can be the classic bullet points or can be numbered in different ways to suit your text. Here we’ll look at: Basic lists (bulleted & numbered) Making sub-lists Other list formats Adding… Continue reading Google Docs – Making bulleted & numbered lists
Posts
Google Docs – Getting to grips with tables (part 1)
One of the most common things that is added to documents is a table. So, it makes sense that you know how to create the table the way you want it. Here we’ll look at pretty much everything related to tables. It’s a long post so, I’ve divided it into two. Part 1 Inserting a table Deleting… Continue reading Google Docs – Getting to grips with tables (part 1)
Google Docs (3) – Setting up the page
Apart from changing the text to the way you want it, you will often want to set up the page differently from the default. You can change the page size, page orientation, how the text fits on the page, etc. Here we’ll look at the following: Page set up All the settings in this section… Continue reading Google Docs (3) – Setting up the page
Google Docs (2) – Making your text look better
[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 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|||”] The most basic way to use Google Docs, is to create a new document and then just start typing. Which is fine, but often you want to make it look more professional, or you want to make certain areas stand… Continue reading Google Docs (2) – Making your text look better
Google Docs (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” custom_margin=”-100px|||” background_position=”top_left” background_repeat=”repeat” background_size=”initial” _builder_version=”3.0.51″] You may have heard of Google Docs, but what are they exactly? Google Docs is part of the Google Apps family and is a word-processing program similar to Microsoft Word. It’s largely used for writing texts but things like images, tables,… Continue reading Google Docs (1) – The basics
Google Sheets – How to use Sparklines (mini-graphs)
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)
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