This one is going to be all about the QUERY function. I love using this one. You can do a lot of exciting things with it. Make sure to also read Part 1 and Part 2 to get to know the setup as well as some other functions and neat examples.
QUERY is an awesome function because you can basically use your spreadsheet as a database and query it which means you have a lot of possibilities. In some cases it is also a lot easier to use than doing the same thing by using other functions. Keep reading
Everyone knows Bone Gap is full of gaps—gaps to trip you up, gaps to slide through so you can disappear forever. So when young, beautiful Roza went missing, the people of Bone Gap weren’t surprised. After all, it wasn’t the first time that someone had slipped away and left Finn and Sean O’Sullivan on their own. Just a few years before, their mother had high-tailed it to Oregon for a brand new guy, a brand new life. That’s just how things go, the people said. Who are you going to blame?
Finn knows that’s not what happened with Roza. He knows she was kidnapped, ripped from the cornfields by a dangerous man whose face he cannot remember. But the searches turned up nothing, and no one believes him anymore. Not even Sean, who has more reason to find Roza than anyone, and every reason to blame Finn for letting her go.
Kell is one of the last Travelers—rare magicians who choose a parallel universe to visit.
Grey London is dirty, boring, lacks magic, ruled by mad King George. Red London is where life and magic are revered, and the Maresh Dynasty presides over a flourishing empire. White London is ruled by whoever has murdered their way to the throne. People fight to control magic, and the magic fights back, draining the city to its very bones. Once there was Black London – but no one speaks of that now.
Officially, Kell is the Red Traveler, personal ambassador and adopted Prince of Red London, carrying the monthly correspondences between royals of each London. Unofficially, Kell smuggles for those willing to pay for even a glimpse of a world they’ll never see. This dangerous hobby sets him up for accidental treason. Fleeing into Grey London, Kell runs afoul of Delilah Bard, a cut-purse with lofty aspirations. She robs him, saves him from a dangerous enemy, then forces him to another world for her ‘proper adventure’.
But perilous magic is afoot, and treachery lurks at every turn. To save all of the worlds, Kell and Lila will first need to stay alive — trickier than they hoped. Keep reading
On the outside, there’s Violet, an eighteen-year-old dancer days away from the life of her dreams when something threatens to expose the shocking truth of her achievement.
On the inside, within the walls of the Aurora Hills juvenile detention center, there’s Amber, locked up for so long she can’t imagine freedom.
Tying their two worlds together is Orianna, who holds the key to unlocking all the girls’ darkest mysteries . . .
What really happened on the night Orianna stepped between Violet and her tormentors? What really happened on two strange nights at Aurora Hills? Will Amber and Violet and Orianna ever get the justice they deserve—in this life or in another one? Keep reading
Make sure to read Part 1 of the tutorial, as it explains the setup I work with (my GR shelves) that helps you to better understand what I’m doing!
The first tutorial was more of an introduction of the basic functions that you need/use all the time. Now I’m going a bit further and explain some of the more complicated ones that can come in quite handy and even more important: how to get some neat results by combining them. Keep reading