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.
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.
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.
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.
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.
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
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.