Format your Google Sheet tables so they look good GREAT

A collection of formatting tips for tables in your Google Sheets.

Google Sheets formatting for tables

Formatting Tables

Let’s start with a simple table, completely devoid of any formatting:

Table no format

Header rows

Go for bold, center-aligned and wrap the text, so it all shows.

Google Sheets formatting column headings
Continue reading Format your Google Sheet tables so they look good GREAT

Updates to the Google Sheets Training Courses

Sep 18 announcement: Whew! This was a big task, but today I’m proud to announce that my video training courses are bang up-to-date! I sent out emails to students earlier today, announcing updates to 40 videos in my Google Sheets training courses.

Specifically:

Read on for more details.
Continue reading Updates to the Google Sheets Training Courses

How to use the Google Sheets Filter function: a guide to get you started right now

The Google Sheets FILTER function is a powerful function we can use to, well, filter our data.

Filter function in Google Sheets

Suppose we want to retrieve all values above a certain threshold? Or values that were greater than average? Or all even, or odd, values?
Continue reading How to use the Google Sheets Filter function: a guide to get you started right now

How to use Google Sheets: A Beginner’s Guide

How to use Google SheetsHow to use Google Sheets: A Beginner’s Guide

This tutorial will help take you from an absolute beginner, or basic user, of Google Sheets through to a confident, competent, intermediate-level user.

Google Sheets is a hugely powerful tool, for everything from digital marketing to finance modeling, from project management to statistical analysis, in fact, just about any activity involving the recording and analysis of data.

And if you’re (relatively) new, it really pays dividends to learn how to use Google Sheets correctly. This tutorial will help you transition from newbie to ninja in short order!

If you’re new to Google Sheets, then I recommend you start from the beginning of this article.

However, if you’ve used Sheets before, feel free to skip sections 1 and 2, and begin with the Data and basic formulas section.

A template is available for copying to your Drive, to accompany this tutorial:

Want a copy of the template from this tutorial?
Click here to create your own copy >>

In addition, various advanced resources are listed for you to take things a step further. Look for this logo: Advanced Resource

Contents

Continue reading How to use Google Sheets: A Beginner’s Guide

Running Total Array Formulas (using the MMULT function)

In this post we’ll look at how to calculate a running total, using a standard method and an array formula method. We’ll cover the topic of matrix multiplication (take a deep breath, it’s going to be ok!) using the MMULT formula, one of the more exotic, and challenging formulas in Google Sheets.

If you like video tutorials, here’s the one on MMULT:

This is a lesson from my latest, Google Sheets course on Advanced Formulas 30 Day Challenge (it’s free!).

Continue reading Running Total Array Formulas (using the MMULT function)