Dreaming to hit Philippines’ white sand beaches this summer? Don’t book that tickets just yet! Chances are, you could be getting pricier round trip airline tickets if you’re too excited booking those tickets a lot sooner.

With just a few clicks, I’m going to show you how you can snap up the best airline deals for your upcoming trips using Google Flights.

Google Flights, by the way, is another service of Google launched back in 2011 that lets you search flights in seconds. Unbeknownst to many, Google Flights has a ‘fare alerts’ feature that notifies you in real-time through email if there are downticks (or upticks) of ticket prices from your selected flight. And that’s exactly what we’re going to do in order to get the best deals in real-time from different airlines.

Here's how to monitor airline ticket prices with Google Flights

  1. Go to Google Flights website

  2. Search for your desired flight. You may opt for a round trip or one-way ticket (there are additional filters too such as desired stop-overs, which cities, airlines, etc.) Best to leave them as is to get the best possible deals)

  3. As soon as you specify the desired departure date, the page should automatically pull a list of flights you can choose. The best flights for the chosen date will appear first on top of the page. So in case you’re happy with those prices, you can book them right away.

  4. If the best flights are too expensive for you, you can activate Track prices toggle. Basically, it will monitor the lowest price for the trip and you’ll be notified through email in real-time.

As long as you don’t omit those tracked prices, Google will automatically alert you when there are downticks of those chosen flight, as seen below's screenshot:

Both Skyscanner and Traveloka have "price alerts" functionality, but it doesn't hurt to add Google Flights into the mix to get the best possible airline deals.

How To Score Cheaper Airline Tickets with Google Flights’ Fare Alerts

5 Handy Google Sheet Tricks To Help You Work Fast & Save Time

Just like Microsoft's Excel, Google Sheet has equally powerful functions hidden up its sleeve. It can help you do routinary, mundane tasks fast and perform time-saving complex operations.

With Google Sheet, being an open-source software and with its collaboration support, it's likely that you'll end up using the app more often than not. It's one indispensable tool every web master and virtual assistant can't live without.

While you may not use below's list of useful Google Sheet functions everyday, it pays to be familiar and well-verse with these shortcuts. We hand-picked this shortlist of five essential Google Sheets hacks to help you save time in dealing with spreadsheets.

1. Use SPLIT function and obtain the first word from a phrase

google sheet split function

Suppose you want to extract the first word from a string in a Google Sheet column. You can use SPLIT() function to split a string and obtain first word , as follows:

=index(SPLIT(A2, " "), 0, 1)

With the above function, a string “10042 Ferrara” yields “10042”.

To obtain the n word, just replace 1 with n accordingly.

2. Use REGEXEXTRACT to retrieve number from a string

google sheet regexextract

Suppose you have this data in a column and you wish to obtain the price

<p>Lined Linen Tunic with Silk Hem</p><p>&nbsp;</p><p><strong>RRP    $99.95</strong></p>

You can do so with REGEXEXTRACT function to extract the price, as follows:

=REGEXEXTRACT(C2, "[0-9]*\.[0-9]+[0-9]+")

3. Using CONTACT to combine multiple values

google sheet concat combine values

Suppose in Column A you want to get the first word and combine it with the value in Column J, you can achieve it using CONCAT function.

=concat( index(SPLIT(A2, " "), 0, 1), concat("-", J2) )

Or use ampersand to combine multiple values:

="RRP "&value(REGEXEXTRACT(E12, "[0-9]*\.[0-9]+[0-9]+"))

4. Use SUBSTITUTE() & RegexReplace() to search and replace

google sheet substitude regexreplace

Say you have a column of data that contains HTML ASCII codes and you want to get rid of them. Here's how you do it:

=SUBSTITUTE(B2,"&nbsp;", "")

Or you can go creative, do a nested SUBSTITUTE

=SUBSTITUTE(SUBSTITUTE(B2, "</p>", ""),"<p>", "")

Or you can go use RegExReplace to get rid all HTML tags

=RegexReplace( B2, "<\/\w+>|<\w+.*?>", "" )

Or a combination of Substitute and RegexReplace

=SUBSTITUTE(RegexReplace( B3, "<\/\w+>|<\w+.*?>", "" ),"&nbsp;", " " )

3 Things You Didn't Know Google Spreadsheet Can Do For You (Part 1)

5. Use VLOOKUP to search by keyword and return a specified cell from another sheet

Google Sheet's vertical lookup is a powerful function you need to master. It lets you search down the first column of a range for a key and returns the value of a specified cell in the row found.

If that doesn't make sense, imagine you have Sheet14 containing sku and color columns

Sheet14

And wanted to append the color initial found inside a separate table from Sheet15

Sheet15

You can do a quick search using VLOOKUP and return the color initial (from Sheet15) by providing color from Sheet14.

The full formula:

=VLOOKUP(I2, Sheet15!A1:B7,2, false)

Where I2 is the keyword, Sheet15!A1:B7 is the range, and 2 is column position from Sheet15 we want to retrieve.

Excel Gets OCR Support, Lets You Snap Tables and Convert Into Editable Spreadsheet

So next time you are asked to update a Google Sheet and do dead boring, repetitive tasks, try to look around inside Google Sheet list of functions and see if you can automate stuff and save huge amount of time in the process.

5 Handy Google Sheet Tricks To Help You Work Fast & Save Time

The older we get, the less time is spent on quality slumber. Blame it to the corporate life' stress, household responsibilities, or maybe that's just how adulthood simply works?

That's why we always try to snatch that much-needed naps whenever we can, whether on a bus or a train.

So, if you're among those millions of nine-to-five warriors who commute your way to work, or you're a backpacker with long trips to the countryside, here's a neat trick how to sleep off your commute without worrying about missing your stop. Let your phone automatically alerts you when you're about to enter your destination just in time.

What you need

  • IFTTT app (available on Android, iOS)
  • Mobile data connection

For the uninitiated, IFTTT (short for If This, Then That) is a powerful web-based service that lets you perform actions based on user-defined triggers. We call these actions as “applets”. IFTTT works like Zapier but much easier to use.

Let Your Phone Alerts You When You Arrive At Your Destination

The goal here is to create an IFTTT applet that notifies you when you arrive at your destination. To do this, we'll use both Location and VoIP Calls services. Here's how to get started:

  1. Install IFTTT app (iOS, Android), and sign-up.
  2. Create your first applet by going to My Applets tab and click on + icon top right.
  3. Now, you'll be asked to define the trigger and action, like this:

  4. Tap on this and search for Location > You enter an area and specify the area you want to be notified.

  5. Once done you'll be taken back to step 3 where you create an action. Just tap that and search for VoIP Calls service where you can fire Call my device action, as seen below:

  6. Save your applet and ensure your IFTTT is running in the background. You're done.

    Use IFTTT As A Spy App: Secretly Copy, Collect iOS Photos on iPhone, iPad (No Jailbreak)

While Google Maps' previous update already has a push notification that alerts you when you're approaching your stop, I find it too unreliable to be honest. A VoIP call works better, ensuring you get off the bus or train just in time.

Long Commute? Get Power Naps and Get A Phone Call When You Arrive At Your Destination