[MUSIC] All right, so let's talk about how to reference data from different Sheets. Import range allows you to import a range of cells from a specified spreadsheet. We can use import range to bring in entire Sheets or just a range of cells. You can access and analyze thousands and thousands of rows of data directly within Sheets helping you easily draw insights from big data. So let's do that. Let's use import range to bring in a range of cells from another spreadsheet. We need to paste in the URL of the spreadsheet you want to pull data from. First enter equal import range, then add the URL to the formula string and put quotes around it. Then we need to specify which tab and range of data we want to pull from. That import function will find that spreadsheet and import that data. Let's dig into how to analyze your data with pivot tables. If you need ideas about how to aggregate or organize your data, a pivot table is one of the best ways to get started. In Sheets, the pivot table feature can suggest ways to present ranges of data in relation to each other. Pivot tables also help you visualize your numbers in interesting ways so you can deliver impressive reports. Now, I'm going to show you how to make a table that will depict the highest-grossing movies by genre. Then we're going to add some bells and whistles. First to find the pivot table function click on Data and select Pivot Table. There we go. Now we need to select a range of data we want to access. Then we can indicate where we want this pivot table to appear in our spreadsheet. So the pivot table editor will open here giving us some more options for a pivot table. This editor allows you to drag and drop different fields to view aggregate statistics. Let's add genres to the rows. There we go. Let's drag in our movie titles to the values. Our pivot table will guess what data we want to result. As always you can also customize this on your own. So you want to drill down into each cell and see the corresponding values that are aggregated here in this pivot table. You can double click on a cell. There we go. Neat? Next up. I'll show you how to name ranges of your data to access segments of it quickly. Sometimes when you have a big chunks of data, you might need to break it up a bit. If you're a director, for example, you may want to break a column of movie names into two parts, maybe A through M and N through Z. Naming your ranges helps you do this. All right, so you can name subsections of your data and make those names principles in formulas. Okay, open Data and select Named Range and we can rename the data range. Cool. Okay, this part I'm particularly excited about. I recently found out about the macros feature in Sheets. And now I'm going to teach you how to create macros that can automate tasks in your sheet. Macros are an incredible time saver particularly when you need to automate repetitive work. Let's say we had imported a larger spreadsheet with many many sheets in it, each of which had a similar data structure. So rather than having to go through and format each sheet in the same way, you can actually record those formatting actions once with a macro and then play that back on different sheets within your spreadsheet. This not only saves you time, it also prevents manual errors you might have made in replicating that process on different sheets. So you can find Macros under Tools. I really wanted to highlight this one for you folks. So back in module 3 when we styled our sheet, I recorded a macro so that now I have a cool example to show you. So watch this. There we go. Very cool. So we just recorded the styling and it basically plays it back for us and saves us a ton of time. How cool is that? You record your own macros and save and name them so they're easy to apply later. Have fun with macros. So now let's optimize your spreadsheet with add-ons. Maybe you're a marketing professional who wants to know what people are saying about your client's product or service on Twitter. Staying on our movie theme, after a film was released, you'd probably want to pay attention to its reception. So gathering data on this can help you aggregate public feedback and spot trends which can lead to more informed decisions in the future. Google Sheets has some really great add-on features that let you import data from social media platforms and much more. These third-party tools put your spreadsheet on turbo to provide even deeper insights. Let's check it out. So select Get Add-Ons up here. There we go. And you'll see this brings us to the GSuite Marketplace and here you'll find a bunch of tools that third parties have created to supercharge Sheets. You can find out more about any of these by clicking on the featured image. You're able to use them once they've been installed. And they'll appear in your Add-On menu across all of your sheets. All right, in the next video, we'll cover how to tell a story with your data.
