Google Sheets

GSheet Beginner’s Guide to Google Sheets

Here you’ll find blog posts on how to use Google Sheets.

The basics

Cell formatting

Formatting your data

Understanding Formulas and Functions

Controlling rows and columns (Part 1)

Controlling rows and columns (Part 2)

Cell references – Relative & Absolute

Moving, copying & pasting data (inc Paste Special)

Moving beyond just one sheet

Sharing, printing and downloading

Filtering your data

Conditional formatting & custom formulas

Custom formulas: A sheet full of examples!

Sorting your data

Merging cells

Notes and comments

Making sparklines (mini-charts)

Creating charts (part 1)

Creating charts (part 2)

Alternating Colours


Beginners Guide to Google Sheets (icon) You can download my Beginner’s Guide to Google Sheets ebook from the iBooks Store or from Kindle Store. This contains all my posts so far on Google Sheets in one convenient package.


Google Sheets Functions – The Series

IMPORTRANGE

IF

CONCATENATE

VLOOKUP

OR and AND

COUNTIF, SUMIF, COUNTIFS, SUMIFS

FILTER

PROPER, UPPER, LOWER, TRIM

TRANSPOSE

ISEMAIL, ISNUMBER, ISURL, NOT

UNIQUE, COUNTUNIQUE, SORT

NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND

WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH

GOOGLETRANSLATE, DETECTLANGUAGE

OFFSET

IMAGE