Ben Collins Profile picture
Apr 7 4 tweets 2 min read
Did you know you can publish your #GoogleSheets as web pages?

You can then share these web pages with the world, so people can see your Sheet as a distinct, lightweight webpage.

It's a good idea if you want to show the Sheet to a very large audience.

(1/3)
Here's an example:

docs.google.com/spreadsheets/d…

(2/3)
And here's how to do it:

1️⃣ Go to File > Share > Publish to web.

2️⃣ On the popup, select the Sheet (or Sheets) you want to publish and hit Publish.

3️⃣ Share the URL wherever you want!

There's even an option to embed the Sheet within an existing web page. 😃

(3/3)
That's a wrap!

If you enjoyed this thread:

1. Follow me @benlcollins for more of these
2. RT the tweet below to share this thread with your audience

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Ben Collins

Ben Collins Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @benlcollins

Apr 6
Yesterday I introduced the QUERY function using this formula:

=QUERY(A1:E100,"select B, D, E where D = 'Europe'",1)

It returns only columns B, D and, E, and only rows where column D is equal to "Europe."

Today's question: How can we change "Europe" to a certain cell, like G2? Image
Well, if you try to put the cell reference straight into the select statement it won't work, because the select statement is a text string.

Also, Europe is surrounded by single quotes, and these need to be included even when we reference another cell.

🤔
To reference another spreadsheet cell, we close the text string, reference the cell, and then open the text string again.

What the...?!
Read 6 tweets
Apr 5
The QUERY function in #GoogleSheets is pretty much the most powerful function in the spreadsheet world.

It operates on your data and has the functionality of many other functions, like sorting, aggregation, filtering, etc.

It's like a pivot table in function form.

(1/4)
It's a tricky function to learn because it's so different from regular functions. You use query language to write a statement that operates on your data.

Here's an example:

=QUERY(A1:E100,"select B, D, E where D = 'Europe'",1)

(2/4)
The function operates on data in the range A1:E100.

It returns only columns B, D and, E from that data in columns A to E, and applies a filter so that only rows where column D is equal to "Europe" are in the results.

Cool, right?

(3/4) Image
Read 5 tweets
Dec 3, 2021
A great way to be more efficient in #GoogleSheets is to learn basic shortcuts for selecting data.

That's what I'm going to show you today - how to select data for formulas without your hands leaving the keyboard. ⌨️

It's so much quicker than grabbing the mouse! 🖱️
I remember how awkward it felt when I first learned these shortcuts, and how it was initially slower than just using the mouse to highlight the data.

But after a few days, it was significantly quicker than using the mouse. And it will be for you too.

Here we go ⬇️
1️⃣

Move quickly to the last non-blank cell in a row or column:

PC/Chromebook: Ctrl + ⬆⬇⬅➡
Mac: ⌘ + ⬆⬇⬅➡
Read 8 tweets
Dec 2, 2021
The OFFSET function is not a function you need particularly often, but it's worth knowing about because it allows you to move ranges around very easily.

#GoogleSheets thread. Let's go. 👇
The OFFSET function returns a reference to a range that is offset from a starting point in a worksheet.

For example, in the table shown in this image, imagine you want to align these columns at the top of the column.
The OFFSET function can do this with a single formula for each column, which is quicker and easier than copy-pasting or creating complex nested formulas.

The OFFSET formula in this example is:

=offset( B2:B6, 1, 0, count(B2:B6) )
Read 6 tweets
Dec 1, 2021
Have you come across floating bar (or column) charts before?

They're a useful way to show data when you want to compare ranges or high and low values.

For example, you can use floating bar charts with salary data, weather data, stock prices, blood pressure readings, etc. Image
To create a floating bar (or column) chart in #GoogleSheets, you’ll need two series in your dataset, e.g. a set of low values and a set of high values, like this salary range dataset. Image
Then follow these steps...

1. Highlight the data and Insert > Chart
2. In Setup, choose a Bar Chart (horizontal) or Column Chart (vertical)
3. Still in the chart setup menu, set the Stacking to be “Standard”
4. Go to the Customize menu

(continued in next tweet)
Read 4 tweets
Jul 8, 2020
A thread about #Lego, including a live build 🤓 👇

I grew up loving the stuff, from ages 3(?) to perhaps 15, from duplo blocks to cutting edge Technic. I credit Lego in part for my deep love of STEM topics.

As an adult, I've started playing it again with my own kids (1/n)
About 3 years ago, I bought the Lego Saturn V to decorate my home office. 🚀

Because #Lego + Space. No more explanation needed.

Amazing, amazing build!!

You can really appreciate the engineering in this one. Highly recommended if you can get hold of a set.

(2/n)
Recently I finished a few big work projects so it was time I built another set.

Lego absorbs your mind fully and so is a great way to distract yourself during this pandemic.

With Lego, you're in control and you enjoy the process and the outcome.

(3/n)
Read 9 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(