Awesome Tips and Tricks for Google Sheet

When you get started with a new app like Google Sheets, you want to know all of the tips and tricks that you can use to get the most from it. The faster you learn the spreadsheet tricks, the more efficient you'll be in that app.

Spreadsheets have plenty of power no matter how you use them. They're easy to get started with, but there's plenty more power for working with data as you learn more functions and features of your chosen spreadsheet app.

For Video : https://youtu.be/fswFqtSiuos

1. Import Data from Other Google Sheets

One of the most common things that spreadsheet users will do is connect a different spreadsheet 

The function that you'll want to try out is called IMPORTRANGE. With the IMPORTRANGE function, you can actually connect to an entirely different Google Sheet and pull data over. Best of all, it stays up to date.

To use this function, try out the syntax below:

=IMPORTRANGE("Url of Sheet to link to", "Sheet and cell references")

Here's an example of a finished function to pull data using IMPORTRANGE:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1woWM2QTeBPCjIhUF9HphpuLw7j_ZWVOl4aE-kZqQZzE/edit#gid=51954154","sheet1!A:Z")

For Video : https://youtu.be/OYQ-rS7-TNA

2. Filter Spreadsheets to Find Specific Data

Filtering can help you refine what's actively showing in the spreadsheet, and it's a real life-saver when you've got huge datasets to work through.

Just hit the filter button (shown inset below) to add filter buttons to your table. Then, click on the filter button on the column and refine what's showing.