Google Sheets - Beginner | Intellezy Trainers | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

53 Lessons (2h 48m)
    • 1. Introduction

      0:51
    • 2. What is Google Sheets

      2:06
    • 3. Opening Google Sheets

      2:43
    • 4. Importing and Converting Spreadsheets to Sheets

      3:44
    • 5. Navigating the Sheets User Interface

      5:21
    • 6. Understanding Sheet Components

      3:27
    • 7. Using The File Menu

      2:11
    • 8. Creating a Spreadsheet

      2:05
    • 9. Saving a Spreadsheet

      1:47
    • 10. Accessing Help

      2:12
    • 11. Navigating a Spreadsheet by Mouse or Keyboard

      4:31
    • 12. Working with Cell and Ranges

      3:05
    • 13. Using Various Data Selection Techniques

      3:37
    • 14. Working with Common Sheet Commands

      2:23
    • 15. Working with Copy and Paste

      4:05
    • 16. Understanding Data Types

      2:22
    • 17. Formatting Values

      2:36
    • 18. Using the Autofill Handle

      3:16
    • 19. Inserting Links

      3:42
    • 20. What are Formulas and Functions

      4:41
    • 21. Understanding the Components of a Formula

      6:58
    • 22. Understanding Calculation Hierarchy and the Order of Operations

      3:53
    • 23. Creating Basic Formulas

      5:30
    • 24. Working with Basic Functions and AutoSum

      4:13
    • 25. Using Cell References

      4:38
    • 26. Using Explore

      2:28
    • 27. Formatting and Aligning Data

      3:38
    • 28. Modifying Columns and Rows

      4:38
    • 29. Using Borders and Fill

      4:41
    • 30. Using Paint Format

      2:09
    • 31. Inserting Notes or Comments

      2:58
    • 32. Inserting Checkboxes

      2:09
    • 33. Using Zoom Tools

      1:39
    • 34. Working with Sheets

      1:40
    • 35. Working with Spreadsheet Tabs

      3:11
    • 36. Hiding and Unhiding Spreadsheets

      1:32
    • 37. Sorting Sheets Data

      4:25
    • 38. Filtering Sheets Data

      4:23
    • 39. Using Filter Views

      3:55
    • 40. Using Freeze Panes

      2:48
    • 41. Using Find and Replace

      2:53
    • 42. Using Spell Check

      2:09
    • 43. Preparing a Spreadsheet for Printing

      4:28
    • 44. Changing Spreadsheet Settings

      1:56
    • 45. Finalizing Printing

      1:25
    • 46. Downloading and Emailing Files

      2:06
    • 47. Sharing a Spreadsheet

      3:20
    • 48. Inserting a Chart

      3:34
    • 49. Formatting a Chart

      4:59
    • 50. Moving and Sizing a Chart

      1:45
    • 51. Inserting Images

      2:42
    • 52. Creating Drawing

      3:01
    • 53. Course Recap

      1:02
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

117

Students

--

Projects

About This Class

This course is designed to teach the student the fundamentals of Google Sheets. Students will learn how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Sheets. Additionally, students will learn how to format spreadsheets, manipulate columns and rows, prepare a spreadsheet for printing. Students will also learn how to create and format charts, and insert graphics and images.

Meet Your Teacher

Teacher Profile Image

Intellezy Trainers

Learning Simplified

Teacher

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

 

 

Intellezy Presents Limelight Series, a training series pr... See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction: Hi, I'm Ed McRae, and I want to welcome you to the Google Sheets beginner class there. Lots of great things I'm going to share with you during this course. Let's take a look and see what we're gonna be learning. We'll start by getting started with Google Sheets because that's what was a good place to start. Will learn how to enter data in. We'll discuss some formula. Basics will revisit some middle school stuff there. That will be fun. We'll get into formatting a spreadsheet. We'll learn how to manage spreadsheets. We'll learn how we can print a spreadsheet, how to create charts and how the work with graphics, lots of interesting things. As you can see, I'm ready to get started, so let's go ahead and get into our course material. 2. What is Google Sheets: What is Google sheets? Google Sheets is Google's spreadsheet program. It's similar to and works very closely with. In some ways, Microsoft Excel. It's similar in the sense of when we open up a file, and Google Sheets were opening up what we call a sheet, and then each individual sheet inside of the sheet is considered a spreadsheet, so it's similar to opening up in Excel workbook and then having multiple sheets inside of the workbook. So what are some things that weaken do inside of Google sheets? Well, we could enter an in store lists of data, weaken, sort and filter data. We can generate charts and pivot tables based on data that's there. We can even do calculations and formulas where we generate new data or manipulate the information that is there inside of the sheet. So what is the advantage of using Google sheets? Well, one advantage of using Google sheets is the fact that it is all online. There's no desktop counterpart, and so what that means is that we can access our Google sheets and create and edit and do all the things we need to do from any computer that were on anywhere in the world. Also, ghoul sheets save automatically, so we don't have to worry about hitting save. We don't have to worry about losing information. Everything saves automatically. And of course, there is a version history that we can go back through and utilize. Another advantage of Google sheets is because it is a program that's on any computer, anyone who is using Google. That means that we can share and send this to pretty much anyone in the world without worrying about whether or not they have a specific type of program or a license to be able to view our information. So we kind of take spread sheeting out of the desktop box, and we put it in the cloud and were able to both of you create and share our worksheets anywhere throughout the whole world. 3. Opening Google Sheets: all right. Now that we know what Google Sheets is, let's take a look at some of the ways that we can access Google sheets All right. Firstly, we can access it by just typing in the u R l sheets dot google dot com All right, so let's do that was going to our address bar here. Sheets dot google dot com It's already got it sitting right there in time. All right, that brings us right to our sheets. Home page. Right, Right. From here, we see the ability to access several templates. Weaken search. We can also see recent documents that we've opened as well, Cup. Now we know that Google Drive is gonna be the default storage location for all of your Google sheets that you create eso. We can also create a new workbook from Google Drive. Let's take a look at that. So I'm gonna go back over to Google and let's go to Google Drive, and I'm gonna go ahead and click new and noticed that one of the options that I see under new is Google Sheets. Click run in that and it brings me to They knew she beautiful. All right, All right, so we go with sheets dot google dot com. We can go through Google Drive now. If I have existing sheets workbooks in here, I can open them and they will open up using Google Sheets. Let's open up this file here of quarter one sales the double click on that. Gonna open up in the preview mode here so I can view it and is going to give me the option here to open with Google Sheets. Someone to go ahead and click right on that option. And it's gonna load up for me. There we are. We haven't opened up in Google sheets. All right, let's go back the sheets dot google dot com. Of course, right from this area, I can create a new blank sheet. I can use one of these templates here as well of all these different templates in the gallery there that I can choose to look at. Um, and I could do a blank one. So let's do a blank sheet click blank. And there we go so lots of different ways that we can get into a new Google sheets environment. We could go to sheets dot google dot com. We'll create a new document through Cool DR Open up on existing document or template and Google Drive or from the Sheets Home page, we can create a blank sheet. 4. Importing and Converting Spreadsheets to Sheets: All right, let's talk about how we can take Excel files and open them up in Google Sheets. Excel and Google sheets play very nicely together. Could easily convert Excel files into a sheets format or just open them through sheets by leaving them in Excel format. We can also convert from sheets to excel, so that's a two way thing that works very nicely right now. We'll just take a look at viewing and excel in Google sheets and then converting it into an actual Google Sheets file format. So the first thing that weaken Dio being that Google Drive is the storage location for sheets is you can take your excel worksheets and workbooks, I should say, and upload them into Google Drive now show you a way to do this from inside the sheets itself. But right from here, I have a folder here, and I got a bunch of Excel files in here. This is not one, but these other ones are noticed. The file format, The file extension, that X less extra. That's Excel s over here, So let's grab one of these guys right here. How about quarter one sales? I'm gonna go ahead double click on that and notice the file extension that XLs X. I'm still in the next cell format. When you go ahead, open this and Google or with Google sheets open, open, open It opens up Now gives me this nice little thing here to let me know I'm currently still in an Excel format. All right, so what if, for whatever reason, I want to get out of that Excel format and I want to save its purely as a Google sheets format, gonna go to file and I'm going to say save as Google sheets. And what is going to do now? Save a copy of it in the same location as the original in the Google Sheets format. Noticed that there is no doubt XLs happening up here any longer. I am now in a Google sheets format. Purely All right, let's go back over to drive and let's take a look and see if we can see that file in there . And sure enough, here we have. We have quarter one sales that XLs X, which is what we opened up before, and he would just see quarter one sales notes. The icon is different this is in the Google Sheets format as opposed to the XLs X Excel format. OK, so we can upload to Google drive and we can open it up, do our conversion there. I also have the ability Let's go back into sheets itself. And, uh, let's just go ahead and get into a blank environment. I'm gonna go to file and I'm gonna go to import right? So file import, I'm right from here. I could import from my drive if I already have stuff in there. But let's say I had not uploaded to Google drive yet. Maybe I didn't realize that that's what I needed to do. I can upload right from in this interface. I'm gonna go to upload, gonna go ahead and select a file. Let's go ahead and grab this file right here, going to upload it. I can choose to replace this current spreadsheet that I'm in inserted as a new sheet or creating new spreadsheet inside here. I'm going to say import data, right. So it's gonna replace what I had there and there we go now just imports the information that doesn't import the name. So I'm going to change the name of this to be imported sales. All right, now that is going to be stored inside of my Google drive. All right, Eso Very good. Very easy. I don't think it's gonna be in the same folder here. Most likely will be in the route drive very easy to take an Excel file and convert it or view it in Google sheets. 5. Navigating the Sheets User Interface: All right, let's take a walk through the sheets user interface and see where things are and kind of get acclimated to some of the things that we can do. All right, All right. So let's start at the top. First of all, at the top here were able to see the name of our current file. We could rename it if we want to. Oh, that's good. Right there. We can also see the folder where the sheet is being stored. All right, so you can see I have it in my sheets class folder. Now, I have a star area here as well. If I want a favorite a sheet. I couldn't do that as well and be able to view that angle drive. All right, so that's cool down below that. I see my menus. Basic menu stuff here file, of course, is going to be for anything involving opening, creating saving of a file, publishing it. I have my edit stuff here. So copying and pasting undo and redo all the classic shortcuts work in here as well. You can see them listed their like control Z control V control. Why? Right. Pay specialists here find them replaces there as well. All right now, you're also as you go through some of these menus going to start to see specific commands based on where you are. Some currently in cell C 15 and is giving me options to delete Row 15. Delete column C Right. Delete cells, delete cells. So gives me some options there. Based on what I have highlighted. Here's some view options so I can do things like freezing of Rose. Right display grid lines or not, I display my formula bar or not show formulas. Write my zoom settings. Air here can also choose to go full screen. Have insert here. Can choose to insert rows, columns, cells, charts, images, drawings, forms, functions, check boxes, comments, all kinds of things, new sheets, all that is there. My format menu is going to allow me to do formatting, so number formatting, among other things, will learn about those in other videos. Conditional formatting alternating colors, which is equivalent to table formatting in Excel for my Excel users who are watching this, uh, the day the menu here is going to allow me to do data. Things like sorting filtering pivot tables named Ranges sheet protection. Remove duplicates. All those things are there. I have a tools area here where can create forms. Macro script notification rules. I haven't add ons area. If I have included in the add ons, I'll see those there. And I have a help area here. Work in search for things. All right. Every time Here have a message every time every change you make is automatically saved in drive. Right. So automatic saving is turned on automatically. So every time we make changes, we don't have to go back and hit. Save. If I click on that, it will bring me here and allow me to see my versions go to a specific version if I want to be able to do so. All right. Okay. Very good. Let's go back. Now. This whole menu area could be hidden by clicking on this up Arrow over on the right control shift. F is the shortcut for this guys that hides my menu like and, of course, expand it. Here's my ribbon slash toolbar area. More of a toolbar than a ribbon gives me some formatting things and just some other basic things that may want to do. Inserting charts, doing some formulas, moving things around. All that stuff is there for me. All right, down in the middle, of course. Here we have our actual worksheet. Same components, write columns, Rose. Right. Numbers, letters. Um, in all that in ourselves, down on the very bottom. Here we see the ability to add in worksheets. Make sure we can view all sheets here. I'm gonna highlight this data set that I've got here. I'm gonna highlight these numbers right here. Matter of fact is gonna highlight the whole thing. Why not? And down in the lower right hand corner, I haven't explore button Click on Explorer for my excel uses. This is the equivalent of the quick analysis tool in excel that pops up for You know, what this is doing is pretty cool. Is showing me different things that I may want to do with my data. That's highlighted. Eso it could ask questions, right? I can do some formatting here. I can generate a pivot table there. Different analysis using charts. All right, So if I want to quickly see some of the things I can do, I will highlight a data set. Let's highlight a different data set and see what pops up. Let's just highlight these total values right here, and we'll do the height heading as well. And let's see what pops up when we had explore right calculations and then some other basic things here. Not as much, obviously, is when we had the whole data set selected. All right, so that is a pretty neat tool as well. All right, so the interface very easy to understand. You can click in their explore around and see everything that's there. Everything is right in front of you, very user friendly interface. 6. Understanding Sheet Components: All right, let's break down the components of a work sheet in Google Sheets. Let's take a look at a few things. First of all, we have the formula bar that pops up right here. That's this little FX and this long white strip that's after it. Now the formula bar is going to show me the actual contents of a cell, and it's also going to show me a formula. So if I'm just looking at these values, I can't tell where there is a formula and whether isn't. However, when I click on some of these, I can see Oh, this is being generated through a formula. All right, so that's pretty cool. Also, if they were formatting in place just very quickly, let's say we had some formatting here, all right? I'm not going to see the actual dollar sign or anything like that happening up here in the formula bar. So this shows me the actual content versus what is being displayed inside of the sheet. Very good. Now a sheet is made up of three things. First thing that we have our columns. Columns are vertical and they're given letter designations from a all the way over here to Z. We can, of course, come in here and we can choose to add other columns to the right or the left. You'll learn how to do that later on. That would get you into double A A B, A C and all that until you get to the end. We, of course, have rose, which are horizontal and are given numbers one all the way down to 1000. Could add more rows down there if we wanted to as well. We have scroll bars here. I can scroll left to right, up and down. See options here for adding a bunch more rows there as well. All right, so that is cool. Of course, inside of the sheet itself, each interaction porter intersecting point rather of column and row is a cell. So you know this inside of these formless that saying stuff like G 12 and G four and all that. What does that mean? Well, that means the intersecting point of column G and Row five or G and row. For if I click here, I'm now in cell G 18. You can see it Highlight the column letter and the role number for you here as well to give you a little bit of help of knowing what cell you're in exactly. OK, and when you learn how to do formulas, you'll learn you could just click on the sell. You have to memorize the cell reference, which is what that's called. By the way, the name of the cells called a cell reference. You have to memorize that you can click on it. But if we just need to know to be able to navigate or choose something, we look at the intersecting point of the column and the road now down on the bottom. Here I have the ability to add in a new sheet so I can click Add she ads in the new worksheet rights. All see all of my sheets listed right down here. I can also use this little all sheets button to quickly jumped to a particular sheet. So if I have a lot of work sheets and I can't see them all, I can use that to help me get to where I want to get to. All right, so those are the components that make up a worksheet 7. Using The File Menu: all right, I'd like to do a high level overview of the file menu and see what's inside. So let's take a look. Go ahead and click on file here under file. First of all, of course, we're able to share. This will allow me to send a link to another user to access my Google. She here I have a new option where Right from new, I can not only choose to create a new spreadsheet, but also I could get into the other APS as well. I could do a new dock, a new presentation form drawing right or I can create from a template. I have the ability to open up a file from here. I have an option here to import. We did that in our video, where we learned how to convert an Excel spreadsheet into Google sheets. Right. We have the option to import right from here. I could make a copy of this sheet if I wanted to. I have several options here for downloading. I could download this as an Excel workbook as an open document format as a PdF, a Web page or CS or TSV file. All right, so all those air there as opposed to sharing. I can choose to send this as an email attachment, so I can actually attach this as a singular document to an email and send that out. I could make this available offline. All this is coming from Google Drive, right? So if I want to be able to use this without an Internet connection, I could choose to make this available. If I don't have one, I can see my version History. From here, I can rename my sheet, move it to a different folder or move it to the trash. I also have the ability to publish to the Web to view my document details or to view general spreadsheet settings that I can set up our in terms of some general time zone and other settings and some basic calculation settings. So some very important stuff I can also print from here as well. All right, so very important. Yet easy to understand things in the file menu 8. Creating a Spreadsheet: All right, let's talk about starting from scratch, creating a new spreadsheet in Google sheets. So right here in a spreadsheet right now. So I want to create a new one. I'm gonna go to file. I'm gonna go to New, and I'm gonna choose spreadsheet. I mean, it just doesn't get much easier than that. Right now. We have a new spreadsheet, right? So very easy. If you're inside of Google sheets to create a new blank spreadsheet, how about if I am inside of Google Drive well, from Google Drive? I can go to New in the upper left hand corner. Google Sheets creates a new blank spreadsheet for me there as well, So we can do this from Google Drive. Also. Now, if I'm on the sheets home page school sheets dot google dot com right in the upper left hand corner. I have a big button that says Blank could click right on. That creates it for me. Once I name it right. Then I'd be able to see it and set the location and all that for that will learn how to do that in another video. Uh, let's do it from a template. I'm gonna go to file new Let's look at our templates here, Go to the general section. Gives me all these different templates I can use. Let's do one based on monthly budget And there we go. I've got a template based on the monthly budget and I couldn't fill it. Then do whatever it is I need to do. Okay. So very easy here from file from Google Drive to create a new blank sheet or created she using a template. 9. Saving a Spreadsheet: All right, let's talk about how saving works in Google sheets. So files are saved automatically. There's no need to go to file save hit control s or any of those things were used to doing for in a desktop environment. All I need to do is give my file. My sheet and name is going to go ahead and name this work. She we created the blank spreadsheet here. I'm gonna go ahead and name this. Let's call this Arum. Are monthly budget enter as soon as I do that. Notes that says saving and now says all changes are saved in Dr. So once we name it, that kicks off the saving process automatically. If I want to change the location. All right. I could say move to I don't know where this thing saved that once a move to I think it's saved in the route drive. So I'm gonna move it to this folder here called Sheets Class To choose that I can also create a new folder here. It's a move and it moves. The EPA was in the root director. It moves it to sheets class guy. So that's awesome. We can control our file management. As far as where things are right from here. Also have the ability to favorite this file. I'm gonna go ahead. Include this star right here. Two favorite it. Let's go back over to Google Drive. I can see. Of course, if I go into sheets class, my arm, Our monthly budget is right there. If I go to start on the left, I can see all of my starred documents, and there are more monthly budget is one of them. So once we name our file saving kicks off and we have full control over whether something is favorite it and where it's located. 10. Accessing Help: our guys. Let's take a look at the help feature. So I'm gonna go over to my help menu next to add ons when you click on help. And there's some useful things here. First of all, have a search menus area here, and this is cool. This is similar to the Tell me what you want to do. Feature for my excel uses out there. I can search for specific things there. I want to search find pivot tables. Right. Boom. There it is right there. I want to find picture options and start drawing is right there. Okay, so that's pretty cool. Right? Under help. Weaken search. There are menus and find commands that were looking for. I have a sheets help area here. If I click on that is going to allow me to search for help. Insert a shark. All right, give me results. Adding a charter graphs, bar charts, right. Boom. Nice help feature right here. Of course, because we're online, we can get into other links in articles and other options here. Alright. How about training? Help? Training training is very important. And, um, it gives me all these different trainings and helps so I could see Ah, whole guide for switching to sheets from Excel to help us out getting started with sheets because Mia hold cheat sheets here that will show me keyboard shortcuts, templates and other things. So anything I need help with, I can do right? And all this stuff is here. Basics. Productivity guides. Everything is there to help us out. Switching from Microsoft. All that stuff is up there. Help updates. Now Google Sheets is constantly updating the advantage of being an online platform. As Google is rolling out updates, they will happen here, forgo the updates. I can kind of get some insight into what's new and when the new feature was added in so I can scroll through here and see the new features that have been added. Get some insight and some training as to what those new features are so very easy to use. Very comprehensive help feature in Google sheets 11. Navigating a Spreadsheet by Mouse or Keyboard: Let's learn some ways that we can navigate through a sheet, and there are lots of different shortcuts and methods we can use for that. Let me just display a list of shortcuts here. We're gonna demonstrate most of these. Maybe grab a screenshot of this if you want, or pause the video and write these down to demonstrate most of these. All right, there are different ways for us to move from one cell to the next or to move around or throughout an entire range or the entire sheet. All right, so let's go. And let's actually take a look at some of these shortcuts in action, shall we? Here we go. So first, let's just look at some basic navigational shortcuts. Of course, I can use my mouse if I have a wheel on my mouth so I could wheel it up and down, right to navigate. I can use my scroll bars, my vertical scroll bar here, and my horizontal scroll bar here to move up, down left, right. I could just click on a particular cell to be able to move to that cell. All right, easy stuff. I can use the arrow keys on my keyboard. Right up, down. Left, right, Move where I need to get to. I can use the tab key on my keyboard and tab is going to move me to the right. So if we want to move one cell to the right, which is hit tab, shift and tab will move me one cell to the left. Okay, So Tab movement to the right shift and tab moves me to the left. Inter is gonna move me down because I'm hitting. Enter could move down one cell at a time shift enter is gonna move me up and noticed that it is selecting the cell as I do it. So if I hate it once, it's selection takes me into that cell. But do the second time it moves, Meet up to the next cell so we can use enter and shift enter to also go into a cell as well as moved down or up. All right, let's look at some other stuff here. The home key will move me to column A in whatever role I'm in. So from in this row, hit home at home will move me to the first cell in that rope right, So column a control home will move me to the beginning of the spreadsheet cell. A one? Yes. If you want to get all the way up to the beginning of the spreadsheet, control home will allow me to do just that. All right, All right. Let's see some others If I'm within a continuous range and I want to move to the end of that range, for example, I'm here in this row and I want to jump to the end of this road, not the whole robot where the data stops. I can hold control and hit my right arrow key. Who controlled tap? My right arrow key. It takes him to the end of that road. How about control down? Yup. That works about control left. That works as well. It's moved me to the ends of the range. Control up. So basically, what it's going to do is move me until it gets to a cell that is different in meaning. If I have a cell that has data in it and I do control right, it's going to keep going until it hits a cell that has no data. So you know this If I do it from here? Control left, right. It stops right at that cell. It doesn't take me to the beginning because there's a blank right there. Or if I start with the cell that has no data and do control up, it'll keep going until it hits a cell that as data in it, All right, that is awesome. I can use control, page up and page down to be able to move between sheets. I could just use General page up and page down to be able to scroll one screens worth of information up and down. So lots of different shortcuts they're All of those are on the slide there that had all of the shortcuts. There's hopefully get a screenshot of that. Let me display that one more time for you. If you need to pause or if you need to grab a quick screen shot of this, you can experiment with these shortcuts and you'll find ways that suit you to be able to move around your sheet 12. Working with Cell and Ranges: let's talk a little bit about working with cells and some of the different terminology that you need to know when it comes to cells inside of sheets. So first of all, a cell is each intersecting point of a column and rope. Like, right now, I'm in cell a one now. Men sell F eight now men sell h 16. I know that because I see it highlighting both the column letter and the road number over here on the left. All right, so that is cool. Now, a cell is also called a cell reference where they sell reference. And this is important because you're gonna use cell references when we start to do formulas . As a matter of fact, if we look at one of these formulas over here, you notice that it is using the cell reference, not the actual value. So is using here in this one G three divided by G 12 right? So it's taking this value, dividing this value into it. All right, so we use that in formulas, and that allows our formless to be more dynamic because as values begin to change All right , let's change this number right here. right. Everything automatically updates because it's looking at whatever is in that cell, not any hard value. Okay, so each individual boxes of cell. Now, when we start getting multiple cells highlighted, then we're talking about a range and ranges can be continuous or not. Here's an example of a continuous range of cells, one solid block of cells with no blank rows or blank columns. Here's another example. No blank rows, no blank columns. All right, we see that in this formula here. D three colon F three. That's saying grab everything from in between D three and F three is grabbing all of those cells and then summing them up together. All right, eso that is that now you can also have non continuous ranges of cells. Let's say I'm doing some formatting. I could say, Hey, I want these cells to be formatted And then I also want these cells down here to be formatted a certain way, and then maybe I also want to do something with these calculations cells over here. So these are non continuous ranges of cells. You can use those and formulas also Ah, that I don't have an example of that in front of us right now can so each individual boxes a cell. A cell is a cell reference, which or the name of the cells considered the cell reference, which gets its name from the column letter followed by the row number. You can have cell ranges that are continuous or non continuous as you get deeper into learning about formless and things, you'll get into some other types of ranges on some other types of references. Specifically, you'll learn about absolute references, mixed references, relative references. We'll save that for another video. 13. Using Various Data Selection Techniques: Let's take a look at some different ways that we're able to select data in a spreadsheet. All right, now, first of all, just with my regular cursor here, I can click and drag over a range of cells to select it. You can click on individual cells, or we can click and drag over multiple ones to select a continuous range. So let's start with some different ways to select continuous ranges. This being one of them, another way to select the continuous range would be the click on one cell. Hold the shift key on the keyboard and then go click on another cell somewhere else in the sheet. Right? So let's I want to get this whole commission column, click on the top, hold shift, click on the bottom that's going to select the two endpoints and everything in between. All right, we're talking about selecting a continuous range. How about this whole thing you hear? Click on the beginning of hold shift, going to go diagonally this time and click on the last number, still grabbing those two endpoints and everything in between. All right, so that is awesome or shift key lets us do that and I can also use shift and my arrow keys . Look at this, right, some holding shift. Let's go back to the beginning Here. Hold the shift key tapping my arrow key to the right. And it's selecting one column at a time. My arrow key down its selecting one row at a time can also then de select by going up or to the left. Okay, So even if I had highlighted this whole thing here, I could hold shift and used my arrow keys to refine my selection point. Come. So that is good. If I click in a continuous range and hit control A, it will highlight that whole range. That's the shortcut for select all. If I were in a blank cell and did that, it would highlight the entire sheet time. But if I'm just in a cell with a value in it and do control A is gonna grab the whole range there. All right, so I'm sitting in this first cell here. I want to quickly highlight this whole first row when the do control shift and the right arrow let me do that again, holding control and shift together and then tapping the right arrow key. All right, we know that controlled by itself moves to the end of a range, right? We learn that shift we just learned selects a continuous range. So for use control and shift together, I can quickly get a continuous column or a continuous rope. Come. So these are all cool methods to select a continuous range. So shift is all about a continuous range. The control key is gonna let me grab independent ranges or non continuous ranges. Let's Ah, highlighted. This whole first row could hold control and highlight this whole bottom part here in the whole. Controlling highlights some other stuff, right? And, you know, if you get bored, you can draw a picture, right? Look at that. Now excels looking at you. Fantastic. So you can highlight independent ranges right now. Why would I want to do that? Well, maybe I want to do something or the same thing to multiple cells that are not connected. Or maybe I want to delete values or format them and they're not connected. Ah, highlighting a in continuous range. Using control will allow me to do just that. So different methods that we can use to highlight whatever it is we need to highlight in our spreadsheet 14. Working with Common Sheet Commands: Let's take a look at some common commands that we can use within a worksheet to deal with structure of the worksheet and just do other basic things. So, first of all, we have everyone's favorite Undo, right? Let's say Oops. I didn't mean to delete all that stuff, right? Undo. Now you have a back arrow that's up here in the upper left hand corner can also use the common keyboard Shortcut of control Z. All right. Or control. Why? To redo. All right, so get rid of stuff. We could easily get it back. Now, there are a ton of commands that we will get. When we right click someone to right click on my sheet here, I'm going to see a bunch of stuff. In the first of all, I'll see all of my options for cutting, copying and pasting as well as paste specials. All that stuff is right there for you. You could see the keyboard shortcuts here control X c V, where all those common shortcuts work in this environment as well. I see that have the option to show an edit history so I can right away see who made a change and when they made that change. And what have you So track changes is basically always on, which is a cool thing. I can choose to insert Rose just by right clicking. I could say Insert row so we don't necessarily have to right click on the header Can right click anywhere Insert row insert column in search rose by the fault above where you are and insert columns by the fall to the left of where you are. I can also insert cells and choose to shift my existing information to the right or down. I have options for deleting rows, columns and cells of options for inserting links. We're gonna do a whole separate video dealing specifically with linking. But I also see some things here for protection, inserting of comments, conditional formatting and data validation, all of which will learn at other times so lots of basic commands weaken. Get to pretty much anywhere just by right clicking. Or we can use our common keyboard shortcuts. Control the control C Control P. Why all those different common shortcuts to do things within our sheets 15. Working with Copy and Paste: Let's take a look at some of the methods that we can use for copying and pasting in our sheet. Of course, I can highlight an area. Let's highlight this header area here now. The difference, of course, between copy and paste would be copying would make a duplication of that area so I can reuse it somewhere else, whereas cut would completely remove it from that area and allowing the place it somewhere else of demonstrate someone to right click. I'll do cut first someone right click on this and I'm going to choose. Cut. The No. Second also used a keyboard shortcut of control X. That's my preferred method for doing things right. So when you cut it, it's gonna put the marching ants here around it, and I'm gonna come down here and right click, and she's paste. Ryan noticed it completely removes it from up here and puts it down there. Let's undo that. Let's use some shortcuts. I'm gonna highlight when do control. See now for copies instead of cutting, which is controlled X in the copy control. See? Come down here and do control V for paste. Notice the difference that keeps the original where it waas and it paste a copy of it down below. So that's pretty cool, so we can right click to copy and paste. We can also use our keyboard shortcuts. Now when we get ready to copy something and paste it, you might not always want to let me actually leave that there. You might not always want to copy everything. Maybe there's a certain element of a area that you would like to copy and then paste, for example. I've got some formulas over here. Formulas, formulas, formulas. The highlight. All of these going to copy going to come down here and hit paste when I hit paste everything, says zero. Why? Because when I copy and paste a formula, it's pasting the actual formula and adjusting the cell references. That's called a relative reference. By the way, eso that now I could, you know, use my formula with value Stop put down here. But let's say I don't want to copy and paste the formula. I just want the values there. Well, in the highlight, a copy. When I come down here, I'm gonna right click and I'm gonna go to paste special and pay special is going to give me the different elements of what I've copied that I can paste second, see paste values on Lee. It can pace just formatting Could paste formatting, accept certain things. Maybe just the formula. Data validation. Uh, let's say pace values on Lee. And there we go. It does just that. Now, what if I had some formatting in here and you'll learn how to do this later on? But I'm just going to very quickly do some formatting here. So I've got this formatting and let's say I wanted to copy just the formatting and have that down here. Well, same thing. Go ahead and copy. I'll use the right click this time. Pay special. I'm gonna pace the format only. And there we go. It pace that format or those formatting zen for me cup So very easy to copy and paste exactly what we want. Let's do one more example. I'm going to highlight these a man. If I'm gonna highlight these names here, these first names copy them unless I want to use those as headings at the top of a column instead. Right click Go to pay special and shoes paste transposed and that will paste it in a different way. So if it was a column in the pace of there's a row, if it was a row, it'll pasted as a column, right? So all different ways for us to copy and paste again using our right click. We can also use our edit menu to get to our copy and paste options, and we can use our keyboard shortcuts. 16. Understanding Data Types: data types are going to determine how the values of a cell are automatically formatted and is going to determine how other elements like pivot tables or if we do an export, or if we do a filter or sort deal with that set of data, for example. Well, first of all, let me show you where to go to choose the data type, and then we'll talk about some of the differences between them. So I'm gonna highlight some cells. And let's just highlight these numbers over here, all the numbers and there's an area here. This says 123 If I look at my tool bar here, if I click on that, it gives me all of my different formats. Now the default is gonna be automatic meaning based on what's type. Then it's going to look and figure out what the data type should be. But then I see that I can also do different things. I can say this is specifically a number. This is a percentage. This is scientific for Matic, right? So some of these will effect formatting right? Like if I highlight these guys here and I say, Hey, you're gonna be an accounting format is going to affect the actual format of the cell as well. Um, text cells, for example, automatically be left aligned, whereas number cells will automatically be Write a line that you can see that here, all these texts, cells over here, right. If I say that these are all going to be plain text which they automatically figuring that out there, all left the line where these numbers are all right, aligned. Okay, so your data type is going to affect formatting as well as how other things deal with the data. All right, let's look at some of these other formats that air here. We have date and time formats here duration formats. And then we have a more formats area where I can get other currencies, other date and time formats, or do a custom number format. So this is an important thing. If we do an import of data, let's say we imported data from a database somewhere. You may need to spend time making sure that each field of data is formatted in the correct way, and that will allow you to make sure that calculations and things of that nature are happening correctly. 17. Formatting Values: we've looked at data types. Now let's look at how we conform at data types. Specifically. Let's look at number format. Ing's alright, So I'm gonna highlight a bunch of numbers, see? And that all these air dollar values out here. So let's highlight all of these guys right here. Let's use our control trick here. The highlight These over here, all right. And I see several things. First of all, I have the ability using this dollar sign here to format this as currency. Now, a currency format is going to be different from an accounting format. A currency format is going to keep the dollar sign flush with the left most number. If I go to my data types and choose accounting, it will left align the dollar sign. I prefer the accounting format. For that reason, I like something be lined up. I'm weird. Like that s o. That is cool. So we see all that happening there. Now I have these options here too. Decrease or increase my decimal places. So from when the ad decimals can use the arrow to the right, if I want to take decimals away can use the arrow to the left. So since this is all money, I'm gonna go ahead and keep a two decimal place format there. All right, nice and easy. How about these percentages over here? Let's highlight this percent column. I'm just going to click on percent and there were going to decrease my desk. I'm going to stay with one decimal place there time. So very easy to format our values in this way. Now, if I were the highlight, I also have the ability when I go into my formats or my data types here to go to Mawr formats and have the ability to do Let's same or currencies. And this will let me see all of these different currencies can choose whatever it is that I want and apply it. And there we go. This is not going to do like a currency conversion of any kind. It's just going to change. The formats was gonna put whatever symbol is necessary at the beginning. Come, I can also do a custom number format where five. A custom code of some kind or what have you I can do that. They're as well. We have a whole listing of value formats number formats here that we can use right, so very easy to highlight our values and apply and manipulate the value or number formatting. 18. Using the Autofill Handle: auto fill is a powerful tool that allows us to automatically fill ourselves in with a series of data. And that could mean different things. That could mean filling in data based on what we've typed in. It could be copying a formula down a column or across a row. It could mean copying a format or filling in a numerical value. Let's look at some examples. I'm going to come over here and type the month of January in the cell and let's say I want to fill in the other months across, I'm gonna click on the seller. You're gonna notice that there is a blue square in the lower right hand corner of the cell . Well, just hold my mouse over that and I see my cursor change into a big cross. I'm going to click and drag over to the right until I get to December, November, December. Thanks to be right there. All right, January is there. Let's delete that last one. All right, so we're able to fill in that way. How about the days of the week? Let's actually start with Tuesday. Same thing, Phil. Across. We see it fills in the remaining days of the week, and then it will start over once it needs to start over. So those are built in. We can fill those things in. How about a formula? Let's say I didn't have these totals down here. I want to fill all the totals in I can click on this. Go to my fill. Tool can actually double click. When you're going down a continuous range, you can double click, and it will fill all the way down that range. How about a format? I'm gonna make this bold, and I'm going to go ahead and dragged this on down, and it automatically fills in that formatting as well, huh? So this is all good. How about the number one? Put the number one in the click and drag, and I'm gonna see it repeats that number over and over again. All right, So this is another thing we can use is if I want to copy something. I can use my filled tool if I hold control, however, and do this now, it fills the numbers in in sequence. Want to put two numbers in the specific sequence when the highlight Both those numbers when you use my fill tool. I see it continues on in that same sequence. All right, how about a date? Let's put the data in here January 5th. It would be nice if I knew how. The type of date Here we go. And I'm gonna go ahead and fill this in, and it automatically keeps going with my dates. Right? So that fill tool allows us to easily fill in multiple cells with a series of day that be a data that we wanted to enter in new or a copy of data or copy of a format that we already have in place. 19. Inserting Links: Let's take a look at the Link feature. We can create links to other workbooks, other cells or other places. I'm going to go to a blank cell and I'm going to right click on the cell. I see an option for insert link. Go ahead and choose that. Now I see that it gives me options here where I can paste a link or search could go to sheets in this spreadsheet. Let's link to another sheet in this spreadsheet. The link to sheet, too. I can put some text in here. Let's say that this is gonna end up being Q two sales or click apply puts a heading there of Q two sales, and what I can do is go ahead and right click on this and say, Open link and it opens me up to that particular sheet. Like so. All right, this is good. I could also, when I hover over the link, go to this little arrow in the upper right hand corner, Right click on that. It will bring me there as well. So we see that right clicking will open up the link in a new window or new tab, whereas here we can just jump to a link within the same area. All right, let's right click. And, uh, actually, let's just click on this. Let's go ahead and delete that. All right? I'm gonna right click again. I'm gonna go to insert Link. I have options down below here to select a range of cells I want a link to. Let's I want a link to this cell right up here. Click. OK, I'm gonna call this top click apply. Same situation here. Could go to my arrow, links me, takes me right up to that cell. Or I could right click and shoes to go to or open that particular link. All good. I'm gonna highlight this data here. I'm going to right click, and I'm gonna choose Get linked to this range that copies a link to the clipboard, going to go over here and let's paste. And there is a link to that range. Hit my arrow, and that brings me to that range of cells highlighted. All right, so all good, different ways that we can do this now can also insert a link by going to the insert menu and choosing link. It's gonna give me my same options right down here. I could go ahead and put in a link school ahead and do that. Let's make a hyperlink here. Supply that. And there we go. Got a link here to google dot com, and I could use that as well. All right. So very easy to create a link. Weaken. Do so by either right clicking. Weaken. Dual. Use all those options there. Or we can use the insert menu to generate a new link. The keyboard shortcut for a link is control K. 20. What are Formulas and Functions: I want to talk to you now about formulas and functions, you probably say, Well, Ed, why are you using both those words? Aren't they the same thing? Sort of, kind of. But there is a differentiation between the two, so let's talk about it. Let's talk about formulas first. So a formula is a mathematical calculation used to generate a result to in equation. Ah, formula is is manually created by you. Here we see an example of a formula. Very simple. We are adding cell a one to sell be one very simple formula. So formulas are created by you. And, you know, there really are No, I guess I want to say limitations to what you can do Mathematically. Obviously there are limitations, but it's kind of free for you to build your formula. However, you need to build it to get the result that you need now. Ah, function, on the other hand, is a built in formula. So functions are pre made formulas that do specific things. So they're very useful in that we don't have to necessarily mathematically figure out how we want to do the equation. All we have to do is figure out how they use the function, like what we need to plug in to the function and I'll talk about the different parts of a function in the moment. But they are more restrictive in that a function does a specific thing. Let's consider this function that we have right here is good little pin here. We'll do some little telestrate ing. So this is a function now. Every function has two parts. The first part of the function is the function name, which we see here. Function Name tells Google sheets what operations to carry out. So you notice there are no plus signs here. This is going to yield the same results as this formula up here. However, in down here the some the word some is What's telling it? Hey, add some stuff, Okay. Whereas up here it is the plus sign that saying hey were adding this Plus that now, immediately following a function name, you will always no exceptions. Find an open parentheses, e you'll see some stuff that's a technical term for it, folks. And then you see a closing parentheses. The stuff inside the parentheses are called the function arguments and the function arguments are the area where we as users are able to in put things into the function. So the function needs to receive some kind of input from us to know what to do or how to do it. So for a simple function like some, it's saying, Hey, well, what do you want me to? Some. And so we have to plug in and tell it. Well, I want you to sum up these cells here. We're doing a continuous range of a one through B one. This could easily be a one through B one million, and it would sum up all of those, however many cells that happens to be so formulas made by you little bit mawr free, where you can create your calculations however you want, as long as it falls in line with the rules of math will talk about the order of operations and things like that. In another, video functions pre made formulas more restrictive. They do specific things now, in terms of functions. Let's talk about how we would find or access our functions. Access are functions here. We're gonna go to the insert tab in the ribbon. We're gonna go down to function and we're gonna discover that we see, first of all, some very recently used or common functions at the top, some average count. Max men right here in Excel User, Right. This is very similar. The exact same stuff that you'd find in the recently used area. So not much of a learning curve there for you. And then we see all of the different categories of functions here. You gonna see ah, lot of pretty much all the same kind of functions you would see in an Excel world. So, like the look up, you know, index match. All these different categories of functions are all here. It's very easy to find their functions. We could also start typing in a function just manually. If I was here, I could say equals. Let's type some and you'll see it gives me a Siris of functions. Based on what I typed in, I could click on it and it would then take me into the arguments of that function, will get in and build some functions and do some things manually in another video. But that's the difference between a formula and a function 21. Understanding the Components of a Formula: all right. Now that we understand the difference between a function and a formula, let's talk about the components of each of those. We looked at examples of them, but let's dive a little bit deeper. Look a little closer at some of the symbols and things that are involved in both formulas and functions. The share a lot of things. So first thing, an equal sign, any kind of calculation, and I'll just sum up formulas and functions as calculations. Any calculation that takes place has to begin with an equal sign. Now there are certain symbols that you might type that will convert toe unequal sign. If you type like an at symbol, it'll convert it to an equal sign. I believe if you type a plus sign, it'll convert toe unequal sign. But at some point, the formula has to start with an equal sign. If it does not begin with the equal sign, it is not a formula. Nothing is going to calculate. It'll just display whatever's typed in that cell as text. Okay, so we have to start with an equal sign. Now if you are doing a formula, that means it's on you. You have to type in the equal sign. If you are using the insert function command, you don't have to type in the equal sign. It will put the equal sign in for you. Now, if you're manually typing the function, then you have to put the equal sign as well. But the equal sign has to show up at some point at the beginning of a formula. All right, then we have different mathematical operators and these air symbols that specify the type of calculation that's going to be performed on the elements of a formula. So let's talk about some very common symbols, and we'll go over here to sheets and will type some of them in eso. Some very common symbols that we would have in the formula would be your basic mathematical stuff. So let's say I have a So let's just do two cells here so equals D one, right? So I could use a plus sign for addition, right? Mind the sign would be for subtraction. The asterisk would be for multiplication zone that letter X like if we're writing it, the asterisk is for multiplication. Forward slashes for a division. If you're using a full keyboard is basically the symbols that are on that little number pad on the right hand side of your keyboard. Okay? Or if you have, like, old school calculator. So those are the basic operational symbols that we would have If you're going in depth and doing, like exponents or something, don't get nervous. I'm not gonna do that. Ah, you would use your carrot. So shift six. All right, These are basic mathematical symbols that you would use when you are doing a formula references. This is for both formless and functions, So references are the cells and ranges where data resides. A cell reference is identified by the column letter followed by the role number, right? So B six F 27 j 5000 right, That sounds like some kind of new robot that's going to take over the world. But that's actually a cell reference. Okay, when we have a range of cells or a continuous range of cells, those two outer ranges are separated by a colon. Here we see an example right here. A one colon F 65 indicates use or include every cell from a one through F 65. Okay, you will see ranges inside of functions, and this is an advantage of functions over. Formulas cannot have ranges in a formula, right? On Lee, a function argument can handle the use of a range so very important to understand that, um, now Constance, these air numbers or text to do not change in the formula user must manually edit constants , so constants are things that we manually would type in. So instead of using a cell reference, I could just type in 6% or 60.6 now. Typically, I advise against doing that because it makes your formal is a little harder to adjust. It's better, I think, even if you have a constant to define that constant somewhere in a cell and then use that cell. Reference in the formula will learn later on when we deal with different types of references how you could make something called an absolute reference so that that cell reference doesn't move. But I always tell people to put things inside of cells. But it's good to know that if we do just need to do a quick formula, you don't have to use a cell reference. You can put just a constant value in that formula. And then we have functions which, of course, are pre defined formulas. They're gonna have different symbols that are used inside of them as well. So let's take a look at some of the symbols that are specific to functions, or that may mean something different in the function than in a regular formula. So I'm gonna go over here, actually have a function right here that will take a look at were summing up be to through D two. So in a function, parentheses are arguments right in a formula parentheses, and we'll talk about the order of operations In another video parentheses in the formula groups a set of operations together to be performed first. Okay, then they function. Parentheses indicate arguments. Cancer is very important. We've already talked about how a colon indicates a range of cells. Another thing you may find in a function is a comma, and you can see here if I click down and it gives me a little help. A comma is a separator of arguments. So let's say there was a whole other set of cells that I wanted to some in addition to this first set, I could put a comma here, and now you can see it moves me into value to I'll do it again in case you missed it. So right now I'm in value one. Put my comma. I'm now in the value to argument, and I could now include a completely different set of cells, and now it's including that as a separate argument. So in functions, parentheses are for arguments. Coghlan's in our for ranges of cells, and then commas indicate we're moving to a new argument. All right, so the more you get used to these different symbols, the easier is going to be for you to make functions and formulas, and you'll find yourself not even using insert function as much. You'll just be manually kind of typing things in, especially when you get down into doing like nesting or functions and really complex formulas. Understanding the different symbols is going to go a long way to just easing your mind and letting you know what's going on inside of the formula 22. Understanding Calculation Hierarchy and the Order of Operations: Google Sheets adheres to the order of operations, the mathematical order of operations. Which means we need to revisit that. So come on, get in your time machine with me. Let's go back, back, back back. Seventh grade, eighth grade, maybe sixth grade for some of you were gonna talk about Pym Das, remember that right pin does. That's the algebraic order of operations that you learned in pre algebra class and you never thought you would see it again. But surprise right is back. So let's see who was paying attention, right? Pinned a stands for parentheses, exponents, multiplication division, addition and subtraction. So this is the mathematical order of operations. Right now, there's gonna be much more meaningful to us if we're doing a formula as opposed to eight function as a function. The order of operations is pre coded into the function. Unless you're using, that is just a part of a larger formula that you're grating. But if we're manually putting our typing in the formula, this is going to become very important. So the first thing that it's solved is whatever in parentheses, Secondly, exponents are solved. We're not gonna worry about that today. Thirdly, any multiplication, that's their will be done, right? Division addition and subtraction, right? From left to right. So let's take a look at an example of Will do. Ah, basic function. Ah, basic formula. Rather, Let's take a look at an example of what happens when we don't do this correctly. All right? S Oh, here we go. School over the sheets. And let's say I'm doing a formula here where I need to add to cells, and then I need to either divide or multiply. Um, the result of that. All right, here I go. I'm gonna do equals. I'm gonna grab this cell, okay? I couldn't find a plus on their plus this cell divided by, um, let's try to find that's moonless. A divided by. We could use this one divided by that self. Whatever. All right, we have our result here. Boom. Okay, now, this time I'm gonna wrap this 1st 1 in parentheses. Knows that our result is completely different. Let me back up. So here is giving me this result because it is doing the division first. See two divided by D to first remember multiplication and division that come before addition and subtraction so doing it this way. It's not going to give me the correct result because it's just is dividing this and then it's going to go ahead and add whatever is left to be too. Okay. On the other hand, if I come in here and put the parentheses around like so now it's actually doing what I wanted to do. It's adding these two up and then dividing by this. Let's check our work here and make sure that we have other correct answers. So these two added together would be, what, 7300 Right? So let's say 7300. Let's put our equal sign about seven through 7300 right, divided by 4900 and there we go. All right, so that's the result that we want it without those parentheses. We were not getting that result. It was dividing these two and then adding that value to this 3400. So those order of operations are very important again. Mawr important when we're doing the formula as opposed to a function. But in general, we need to be aware that these rules are in place 23. Creating Basic Formulas: Okay, We've laid a lot of foundation here. Let's actually go in and start creating some formulas and functions. We're going to start in this video by calculating using formulas. Let's go and create some formulas, will do some different things, and I'll show you some advantages of using references versus constants and vice versa. So let's start over here. I want to do some totals here, and I'm going to do some totals using constants. So I'm gonna come here and I'm gonna say equals. We always start with our equal side 3400 plus 3900 plus 4900. Enter. Cool That works. Gives me a total. Let me insert a column here. And let's do just call this total for the FX here for reference. Our function with her. Let's do the same formula. But this time will you sell references and let's watch the difference. What happens here? There a couple of differences here equals now. I could type the cell reference in right. I could go here and I could say B two. Okay, But whenever we using cell references, it's, in my opinion, easier to just click on the cell. So what should happen there clicked on the cell or the value. And that puts the cell reference in there for me. All right, this makes it a lot easier now. Right here. It's obvious I'm right here in the corner. So it's easy to tell what sell? Amusing. But if I was way off somewhere over here, right, it might not be as easy. You could see it putting that in there. I don't want to do that, but, you know, it's not as easy to tell what cell reference you're in. Okay, so it's better to just click on the cell, So let's start that again. B two plus C two plus de tu will stop right there. Enter gives me the exact same value. Okay, so in this formula, we've used constants where we just put the numbers this form low. We used to sell reference gave us the exact same value. So what's the difference? You might ask. Well, I'm glad you asked me that. I'm gonna tell you. The difference is I find out that this number for January is not correct. It actually should be 5500. I wanna change it. Watch what happens and watch what doesn't happen. 5500. Enter. Uh oh. The one with the constants does not change. Do so when it's constant, it's constant. It's going to stay that way. I'd have to manually go in here and change this. Now it's only one self. It's not a huge deal, but role that on down to even just these other four cells. Or imagine if I had a list of 1000 rows you really want to go through and change that for all 1000 rolls. You probably don't want to do that. Look at what my function deal my formula, rather with cell references did, though it automatically adjusted based on the value in the cell, because it's looking at the cell reference, right? So these air basically placeholders. And that's saying, Take whatever is N B two and added to whatever's in C two nd to I could change this value to more time 2000 more times, right? It's still going to just keep updating, no matter what. I'm changing these two. Let's change this one over here. No matter what. I'm changing them to write. This is going to keep updating for me, okay? that is awesome. Here's another advantage of using cell references versus constants. I've got an additional income column here. I'd like to be able to include that in my calculation, with a constant. I can't do that because there is no value here for me to type in. But with a cell reference situation I could say equals. Plus this cell reference right here. Even though there's nothing in there hit, enter, it still works. And if I type of value in here now, well, look at that. It automatically includes that as a part of the value or the overall formula. Okay, so you are at a disadvantage using constants. In my opinion, it's better, even if it is a constant value. Like, let's say, this commission rate right here, even if it is a constant. It's better to define that in a cell and then use the cell reference so that when things update they will automatically update. So I, for example, let's actually let's actually do that. Let's insert a formula over here for commission. It would be nice if I spelled that correctly. Let's head to the formal of equals. The total times this commission rate boom. There we go. If this commission rate changes to 12% well, that's gonna automatically update. So you're at an advantage of using cell references as opposed to entering in Constance. It gives you a little bit more control over the values they're being used, and it makes it easier for you to make any updates. And you can include cells where values have not been entered in yet. But, you know, in the future they will be. 24. Working with Basic Functions and AutoSum: All right, let's take a look at how we can use functions to do some basic calculations. The advantage of using a function is I can. One of the advantages is we can use ranges. So in a previous video, we did a some here or a total for these for the Northeast, Let's say, But we had to do it one cell of the time, right? We did equals this. Plus that, plus the other. Now, that's okay in this example, because we only have three or four cells if you've been working inside of spreadsheets. You know, we have thousands and thousands of cells, you know, Rose thousands of rose. A lot of columns. We don't want to sit there and have to put in individual references. So using a function becomes useful as we can establish ranges. So let's take a look. I'm going to use auto some that auto. Some is just a quick way to get to the same functions that we could get to buy going to insert function. So this is my auto. Some icon right here. I have my most common functions. We're gonna focus on these guys up here, so I'm gonna go ahead and say some. That's the function I want. All right. So the first step is you choose the function that you want to is. Actually, the first step is you make sure you're in the right cell, that that's we often overlook that. But that's very important. If I'm way over here, I could be doing the correct formula. But it's not in the right place, so the result will not show up where I wanted to. So I'm making sure that I'm in the correct sell. First of all, first of all, I'm gonna go Teoh, although some choose some. So second thing I'm doing is I'm choosing the function that I want to use now. Once I choose that I'm now in the arguments, I can go ahead and just highlight a continuous range. Look what I'm doing them just clicking and dragging. Let's grab this whole range like So. So Step three is we configure the functions arguments. All right, enter. All right, here we go. This is good. Have my total. Let's do on average. Same four steps. Click in the cell. Choose the function. Now again, this is important. This time we want an average. So I have to choose a function based on the result that I want. If I choose some here, it's not gonna give me an average. So if I want an average, have to choose average average. Let's highlight the correct cells. Make sure I'm not including the total here. I only want these cells enter, and we're good. We won't worry about the percentage. Right now. Let's grab the highest value. That's gonna be the max function. See what the highest value is out of these four. What we'll do, we'll do Just the months for that will do all for. We'll keep it consistent. Well, I guess since the same highest month, we won't eso Let's actually go back in here. I'm just going to change this last cell reference. Let's do D instead of all right, since we're doing months and then lowest month men highlight these guys right here. Enter. All right, this is good. So very easy to do a basic formula. Basic function. What are our four steps? One we click in the cell where we want the result to appear. Two. We highlight or choose the function that we want to use. Thirdly, we highlight the cells that we want the function to calculate. Or really, what we're doing is we're figuring out or putting in the correct arguments with a basic function that you're usually just highlighting a range of cells. You start getting into more complex functions. You may need to do different things, and you may want to use the overall argument window as opposed to using auto some. But we'll get to that in the future. And then lastly, we finish up our formula by hitting enter and there we go. We have our result were able to use our range of cells. You also again. I want to make sure you're choosing the correct function based on the results that you want . 25. Using Cell References: There are different types of cell references that you can use inside of a functional formula, and the type of self reference you use is going to determine what happens when you either fill that formula down or across or when you copy and paste. I'm sure an example. I have my total here and summing up be to through E to I want to fill this down when use my fill tool here, drag it down, and I noticed that it is doing it for each row, So it's adjusting in this calculating for each row. Now, if I look at the cell reference, it's changing from B two to B three before be five. This is called a relative reference, right, and I'll do the same thing for these while I'm talking about it. So relative reference is going to adjust the column letter or row number, or both relative to how far we moved. So if I'm moving down, it's gonna be adjusting or up. It's gonna be adjusting the road number for moving across can adjust the column letter from going. Doing both is gonna just both, so that's great when I want to a copy of the same formula down or cross for multiple different values. Now, if I do that same thing for the commission over here, it's not gonna be is great. It's giving me zeros. So see why so f two and in one So my commission rate is right here. My total is right here. OK, I got it. So when I copied it down is changing this two f three, which is what I want because I want to get the total now for Southeast problem we're having is it's changing. My commission cell to into my commission rate is only in in one what's an into an event. So that's why we're getting zeros. Okay, so each time I moved down, it's moving me further and further away from where my commissioner it actually is. I need to change this in one here, in my original formula. Erase these other zeros here, by the way, is the title of my self help dating books. Feel free to get that erased zeros. If I get rid of those, I want to change in one into an absolute reference right? An absolute reference means that it is not going to shift away from that cell if I copy and paste or use my fill tool, and that's what I want to do in this example, Whenever you have a constant value, you typically want to do that. Now. The symbol that we'd use for an absolute reference is dollar signs. The shortcut we can use to put dollar signs here would be F four now on some laptops you might have to do function. F four changes my Formula two F two times Dollar signs in dollar Sign one. Let's test this out. We'll see if we can fill this down now. Oh, there we go. That works. Take a look at each formula here. It's still changing my column f cells, but my end cells are staying the same in one in one in one. Uh, so when I have, ah, a situation where I want myself to adjust, I leave them the way they are. And that's called a relative reference. When I put dollar signs in front of the column letter and road number that's called absolute reference. Now there is a area in between the two called a mixed reference, and that would be if we just lock the column or just locked the road in this example. Technically, we're not changing. Columns were just going down, so technically we could do a mixed reference right where we're just locking the row. Let me show you what that would look like just for argument's say when they come here and I'm going to do F four a couple times and you notice if I keep heading f for its moving the dollar sign around. So I have relative reference. Absolute reference, a mixed reference where I'm locking the row mixed reference where I'm locking the column. Okay, so I wanna mix reference where I'm locking the row in this case or locking the lock in the row. And if I go ahead and fill this down, let's go ahead and move this on through. It's gonna do the same thing. Okay, that's a mixed reference. However, if I were the copy of the cross, then I would start getting into some trouble because I did not lock the column. Okay, so those your three types of references relative references to default absolute reference. Locking both the row and column mixed reference. Locking either the row or the column 26. Using Explore: I'd like to take a look at the Explorer feature. The explore feature allows me to look at the data that I have and see different things that I could do with that data. So let's take a look at some stuff. The first thing we're gonna do is highlight some data, so we'll highlight. Will do different highlights here. I'm just gonna highlight just these raw monthly numbers here. And I'm gonna go to the lower right hand corner and I'm gonna click. Explore that can also use Ault Shift X to open this window up. Explore. So I'm going to explore it. First of all is going to give me some basic formulas, right? I can see some average men, Max. Count of values. That's what count days for. I can get some answers here. Right Division with the most low mah hissed a gram. All that stuff is there. I see different options for formatting. I see different analysis options. So if I wanted to insert the chart, for example, when I see I have the ability to go ahead and view that full size, I could say insert chart, boom inserts a chart for me based on that data for my excel users. This is similar to the quick analysis tool. Different charts. Here. Let's highlight some different data and see what we get. Uh, I'm gonna highlight this whole area. Now, let's see what pops up over here. Art similar things here, Maurin. Depth charting. Take a look. You know, we have formatting alternating colors. We could do same formless and things up top here, right? Also have an edit area here where I can go in and edit data range that I'm using. All that is good. So very quick way for you to take information that you have and see our explore different ways that you could manipulate that data. All right, there is a project file that you can use to practice this. You're gonna want to go use that file. So go ahead and grab that file. Practice some of these things don't just practice the explore that go back and practice some of the formula stuff, right? See some different ways to do calculations using formulas versus functions that's going to really help you advance your knowledge here in Google sheets 27. Formatting and Aligning Data: Let's take a look at how the format our spread sheet. So it's boring right now. I wanted to not be boring anymore, and I just wanted toe look uniform that nice and be able to differentiate between values and all that kind of thing. So first of all, let's grab these numbers. So you always start by highlighting. All right, Whatever it is you want to format, this is all money. So I want to go ahead and do some number formatting here. Now I can use some of these quick formats. Have a format is currency here? I have some decimal places. I can move around, increase decrease All that's happening right here. I also have the ability to go to format up top. I can go to number, and it gives me all of my different number formats here, right, So I can choose to format as currency. Or that doesn't just include that, but also dates times, right, mawr formats, durations I'm gonna do in accounting format difference between accounting and currency is accounting. Will left the line. The dollar signs currency keeps a dollar sign flush with the number counting. Also, put that little dash there if it's zero. Okay, so there we go. That's nice. Now, obviously, we're gonna need to adjust some column with here going to do that in the number video. Let's highlight these headings up here, and I want to just some font setting. So I have different font styles I can choose from. For fun types, I should say font sizes, font styles such as bold right italics strike through colors that could be adjusted. And then I could even get in here and deal with alignments. Riken center things left right? Whatever I want. Let's do that same thing for these calculations over here. Let's go ahead and make these bold. And then let's do a little summation down here showing we shall and we'll go ahead and make these guys bold as well. Right? So you can use that format these however we want. Now when I go to the format option here, of course, I have those same things here. Font styles, fought sizes, alignments. Then I also have text wrapping where I can choose to go ahead and wrap text or clip it or have it overflow and I can adjust rotation. Let's grab these months. Right here. Text rotation tilt up. Still down. It sounds like we're doing a line dance or something here. Right? Stacked vertically. All right, take it back. Now, you all. And I could switch back to none. All right, So all of our formatting options are basic. Cell formatting options will deal with cell colors, fill colors, rather border colors and things in another video. But on my basic fot and value formatting is found in my toolbar and in the format menu. 28. Modifying Columns and Rows: Let's deal with how to manage rows and columns. First of all, let's talk about inserting rows or columns. Rose will be inserted above the grow that we're on. Columns will be inserted to the left of the column that we're on someone insert a couple of rows at the top here to put a little headings I'm gonna highlight three rows, a right click. And I noticed that I see options for doing both. The default is above, but I can do below as well gives me that option. So I want to say, insert three above. Boom! There we go. If I wanted to do a column, I could do the same thing or insert one to the left or right. So defaults gonna be left. I could do the right as well. I'm gonna put a heading up here. Arum, are sales data now, I'd like this to be kind of centered over this whole area of here, so I need to merge some cells together. So I'm gonna highlight this whole area. Let's go all the way over here to where the Commission column is. If I take a look in the menu or the toolbar here I see select emerged type. So let's take a look. I could merge all submerge. All the cells together could merge horizontally or merge. Vertical is looking. Each one submerge all, merges everything together and centers it within. Merge horizontally, merges and keeps the rows separated. Merge vertically, merges but keeps the columns separated. Yes, we have all those different merge options there. I'm gonna go ahead and merge. All well, center that. Let's just adjust this font size a little bit. Make a look like a heading. That's nice. Just give it a little different color to why? Because I want it all right now, I want to adjust. Speaking of things I want to do on a just some column widths here because I can't really see all my data. So you're row heights typically will automatically expand as you adjust your font size. Your column wits will not. Let's take a look. I can go. And if I hold my mouse on the line between the two column headings, it'll change toe a double arrow. I can click and drag and re size the columns like so click and dry to resize. Click and drag to resize. Now I can also double click toe auto fit. Sounds like eighties, right? DoubleClick Auto fit right so you could do that. And it'll automatically resize the columns here to fit whatever is inside that you could do that for a bunch of columns and watch guys. So, like, if I highlight all of these columns and go to one of them here and double click, check it out. That, although, fits all the columns for me now because I have emerge up here. That's going to kind of get a little wacky, so we may not want to do that, but you can see what's happening there. Let's undo that now. I could make multiple commas be the same size, all right. One way to do that is I can highlight them. And then if I resize one column, it will make all the others resized to be the same with Let's do that over here for our totals or calculations, I should say not all totals when the resize one boom resize is all of them to be the same with That is great. When the delete column Elmina right click column l delete column moves that over a little bit, and now we have some or we have a Mawr uniform. The area here. I could do the same for my row height. I can click and drag down, adjust my row height. So very easy to manipulate the size of our columns with size of our rose, and we see how we can merge cells together and really arrange things the way we want them to be. 29. Using Borders and Fill: all right. I'd like to apply some fill, add border options to my formatting kind of spice things up a little bit. So I'm gonna start with my header up here. You know, actually, I want to start with this header area down here and let's just go ahead and just format paint this commission rate guy right here and let's adjust our column with All right, We are good. Let's just make this bold as well and a little bit larger. Okay, so I'm going to start with this area right here. First of all, let's look at some fill colors. So when I take a look at my toolbar here, I have a fill colors. A little bucket here, fill color for goto format, right? I could take a look and I can go down into the formatting options in there as well. I'm going to use this bucket here. I could choose whatever color I want. Let's do just a nice little blue. That's lovely, isn't it? All right, that's good. So I can put that fill color there. Now I'm gonna go ahead and do the same thing for several different areas. Let's go ahead and fill our formatting area here. We use, like, a little, um, light area there and really like that. I will use this here. OK, this is good. And ah, let's just do a little something over here just for good measure. And then let's go ahead and paint this guy right here. All right? That's fantastic. Okay. Actually, I want to Let's ah usar format painter for this as well. And then we'll actually change you to a different color so you can play around kind of with , you know, you different colors and things and get things set up the way that you like for them to be . Let's make you guys bold. And let's, uh, right online you as well. All right. Fantastic. So very easy here to adjust. Our fills was right. Align you as well. How about Borders? About Borders? I'm gonna highlight this whole area. Have a border option right here. And I can choose the style of border that I want. Before I do that, though I am able to come over here and adjust the color. Believe it is a black border and adjust the weight. I would like to have a little bit of a thicker border. So let's use this and then we'll go ahead and apply that. I think it was already highlighted. Going ahead. Apply that setting. Like so I guess you can choose the style that you want. Let's just go ahead and do that on throughout here. You can choose the style that you want, and then we can choose where we want to apply that style. All right. This is good. This is good. Okay, very easy to do. Now, when I highlight, let's highlight this whole area. I have the option when I go here to look at my colors of doing alternating colors. And if I choose alternating colors, Aiken is gonna open up my explorer area and I can choose a specific style. This is similar to table style formatting. All right, let's undo that. Let's actually highlight this whole table like so, and it's gonna go ahead and do that for me. I can choose a header color. I can choose an alternating color here so you can set up whatever style you would like here . Let's say we want to go to more of a blue. All right? One of the more blue and a white and a light blue for the header. There we go that we have that going on here. Okay, So different ways that we can go in and format. Let's actually change what it's applying this to so one apply it to the fourth row. There we go, so different ways that we can go in and format and just make things look the way that we want them to look in regards to our fill, color and our borders. 30. Using Paint Format: the format painter is a very good option to use when you want to duplicate your formatting throughout your sheet. And I used it quickly in the previous video. But let's take a closer look at it and see how it actually works. To use the format painter, we need to start off with a cell that's formatted the way we want it to be. So we've already established that, you know, we kind of have things formatted this way. And let's say I want to grab this format and copy it throughout to some of these other header areas or title areas. I'm gonna click on the cell that has the formatting I want. Now this is my format painter right here. Looks like a little paint roller. All right, Um, one of the things that we cannot do for my excel uses here is there's no sticky option where if you double click, you can quickly put it multiple places that doesn't work here. We have to go back and re copy each time. All right, so that is what it is. So I'm gonna go ahead and click on this to select it, and then I'm going to click here, and it pastes that format. All right. Now, I'm just gonna just this a little bit based on where we are now. So let's go ahead and make that border complete. And let's go ahead and left a line. This come and I'm gonna have to go back again. Copy based. Copy. Paste copy paced. Right. So each time I want to use this, have to go back and copy again, and then I can repay snot. Need to adjust some formatting, zeer or some, uh, column with here, I should say to get this the way that I want it to be. All right. And there we go. So the format painter, very useful there saves you some time. Right of having to redo everything. Or remember what you did. Go to a cell that has formatting in it. Hit the format, painter. Go to where you want to paste it and paste that for Matic 31. Inserting Notes or Comments: both notes and comments can be useful, especially when we're dealing with a shared sheet or multiple. People are working on it. A note is going to just kind of be an indicator is going to show up in the spreadsheet. You can hover over it and see what's going on. A comment can be turned into more of a threat where we can reply and go back and forth and see kind of a history of what's going on. Smith. For more interaction and sharing someone to right. Click on this value, and I see an option here for insert note. Go ahead and click on that type of note here. We sure this. Oh, see that? UH, let's raise this value All right. Shows up like So if I hover over this sell, it pops up. There's no interaction here. It just is what it is. If I right click on here, I do have the ability to clear my note, right? Erase it, delete it. That's pretty much it. Let's come down here and let's do a comment on this value. I'm right clicking again. Comment. I noticed a difference here, right? It's putting the user That's making the comment. Views of this file can see comments and suggestions. How can we raise our subscription base or subscriber base? Maybe by spelling subscriber correctly? Aren't comments? Boom. There we go. So take a look at the difference here. First of all, the color is different. When I hover over, it shows who win, right? I can go over to the right hand side, and I can edit this, and there also is a resolve option here. When I click on it, I can reply, All right, so I can get a thread going here so we can have a threat of people replying back and forth , and I have the ability to resolve it. When I click, resolve this clip back on here again, I can click on it to reply when it's resolved, I can click resolve, and that goes ahead and resolves. That issue ends the discussion. I can view comment history here in the upper right. I can click on that. I can see the history of the comments, but it removes it from the cell so it doesn't clever it because it was resolved. So again, notes are just going to show up no interaction there. There it is. A comment is gonna indicate who and when and allow me to both reply and resolve. 32. Inserting Checkboxes: we are able to insert check boxes into cells, and those check boxes can get resolved to a value of true or false, and that value can then be used in other formulas. For example, having additional income column here. Let's say I just want to have a check box there to indicate whether or not there is additional income. So I'm gonna highlight these columns or these cells gonna go the insert. And when you choose check box and inserts check boxes in each cell, I can check the box now when I check the box here, notice my formal, Bart says, equals true, true, false. So it's giving me a true false value, which means I could do a formula based on that. Let's just do a real simple formula here. Ah, simple logical statement will probably get into those in another video. But if I say equals, if here, If the value of this equals, let's say true, then I wanted to say yes. If not, then I wanted to say no, just to show you that the values working. So if it's true, yes, so far unchecked, it says no. If I check it says yes, so it's actually out putting a value that you can use to do other stuff. That is really awesome real world. We could probably have that doing a different look up. It could be going toe. Look up where the additional income from another work. She It could be doing all kinds of different things based on this check box. And guess what? You get to experiment with that. There is a project file. You can open up. Go ahead and do that right now. You can open that up. You can experiment with all these different things check boxes, the formatting, all the things that we've talked about a year during this section. I recommend that you do that. It's gonna make your life all the more easier and is going to increase your knowledge in sheets. 33. Using Zoom Tools: all right. I want to show you some of the different ways we can zoom in and out in your spreadsheet. All right, so here I am in sheets, and I'm gonna take a look at my tool bar here. And if you look over to the left, you may have been wondering what these percentages air for. Those are Zuma percentages, folks. So if you hover over, that is going to say Zoom, I can click the drop down here, and I can zoom out, zoom out to about 75% see a little bit more stuff. I can zoom, and you can go up to 200. I could see all of that. Now I can click in here, and I can type what I want. If none of those specifically work, I can go to 85%. That's fine. I can go to, you know, whatever it is that I want. Let's go. 172%. All right. And there we go. Ok, so very easy to zoom in and out right through here. Now I can also go to my menus are going to view and zoom. And here are the same options right here can use those to zoom in and out as well. If you have a mouse with a wheel on it, you can hold control and use the wheel up and down to zoom in and zoom out. And depending on the specific laptop or keyboard you have, there may be other shortcuts that chicken program inside of the computer itself. For you to be able to zoom in and out because we are in a Web browser viewing this, you can also use the Web browsers tools to zoom in and out as well. Of course, that will be for the entire browser window, though not just for Google sheets. 34. Working with Sheets: Let's talk about sending up the structure of your workbook. We need to be able to add and delete and navigate between sheets. So let's take a look at how to do that. First of all, if I look over on the bottom, this is my sheets area. I could see all the sheets center here. So in this workbook we see that we have three different worksheets all the way to the left . I haven't all sheets area, and if I click on that, this will also show me all of the sheets. And that's useful. For if I have a lot of sheets, we only have three. But if I had a lot, Maura, where maybe I could not see or if I had renamed them. So the names were a little bit longer and I couldn't see all the sheet tabs down here. I could use this area to navigate between sheets as well. All right, so that is good. On the far left, I have a plus sign for ad sheet, and if I click on that, there we go. We could add in the new sheet. Of course, I can click and drag to reorder it. I could double click to name it. Let's just call this adds sheet. Let's be very careful as we're spelling that now I can right click on the worksheet down at the bottom here, and I see that I have the ability to delete it. I also couldn't do some duplicating and copying. We'll take a look at that, another video of some of the things we can do. But right now, let's just delete this worksheet. Um, I sure want to do that. Yes, I am. Come so very easy to add in delete and reorder sheets. 35. Working with Spreadsheet Tabs: once we've added in the sheet, or even if you already had some. And you know now the workbook is further developed. You may want to manipulate the sheet tabs, so let's take a look at some of the things that we can do. So, first of all, we can name our sheets now. See, this is happening for the 1st 1 This is Q one sales. These guys Q two and Q through are not named, so let's rename them two ways to do that one. I can double click, and I'm gonna go ahead and name this Q two sales. You can use spaces and stuff if you want to. We can also right click and choose rename. All right, double click, Weaken right click. Let's look at some other things we can do now we can get to our different worksheet options by right clicking or right click. See several things here. I see. I can delete duplicates. Let's duplicate this and create a Q four worksheet duplicate copy of Q three sales. Let's change that to you. Four. Sales didn't see that one coming, did you? All right, for right click again. I see that I'm able to also copy So I could take this existing worksheet, and I could copy it to a new spreadsheet or copy it within an existing spreadsheet as well . Don't come. It's all these air options for me. So if I were to say new spreadsheet, it will copy the sheet, and they would put it in a new spreadsheet that I could open up. Come if I were to copy this to an existing one, it's gonna bring me into my area here and let me choose the book that I want to copy that into. All right, All right. I can color code my sheets. If I right click, I'm going to see change color. So school hadn't apply a little bit of color each of these. Now, the color doesn't mean anything, but it's it's pretty cool. And it can be youthful for you again to tell your worksheets apart if they are color coded . Well, yes. All right, this is good. Add a new sheet in here at the end, and I'm gonna call this worksheet yearly summary or just year summary. Go ahead and color code. This. I want to move this to the beginning of my spreadsheet or my workbook. I can click and drag and drop someone the click, hold down my left mouse button and just drag on over. We could see it positioning itself where it's gonna go, shifting things around drop and there we go. It drops right at the beginning there. So just by right clicking and using our left mouse button were able to manipulate our sheets so that we can further develop our workbook. 36. Hiding and Unhiding Spreadsheets: hiding worksheets could be very useful if you are in a shared environment or if you're sending this to someone, um, and you don't want them to see what is hidden or if you just have a lot of sheets and you want to kind of declutter a little bit. Maybe you have some old information, and you just want to get it out of the way. But you don't want to delete. It may be their formulas. They're looking at it sometimes also, especially when you start doing formulas. If you don't look ups, or if you're doing drop down lists, there might be data that you don't need to see readily. But maybe you're using it to feed the formula or feed a drop down list, and you want to get it out of the way. Hiding a sheet is gonna help you to do that, so let's take a look at how to do it. A quick way to hide the sheet. Let's say this summary sheet over here. Want to hide it in the right? Click on it, or I could just click on the little arrow there and shoes hide sheet, and it is hidden Now, if I go back to this hour, I don't see any options here for unhygienic these sheets. Someone they need to go up to the view menu. So I'm gonna go to view. And when I go down to hidden sheets, I see it tells me how many sheets are hidden. I can go ahead and choose that she and it on hides. Now, of course, we can put security in place to stop people from doing that. You'll learn that in another video, but that is how we can hide and unhygienic sheets. 37. Sorting Sheets Data: I'd like to talk about some of the sorting options that we have here in Google sheets. So let's take a look first at some of the different options that they're there, and then we will actually see what they do now. There's a difference, of course, between sorting and filtering. Sorting is when we arranged data in a specific order or you can think of sorting. Also is grouping like values together, right? Could do both things, actually. So if I go to the data tab of here in the menu for the day, the menu, I should say I have several sort options. Now we have the ability to sort the entire sheet by the specific column name. We have the ability to sort a range by one particular column in ascending or descending order, and we have a general sort range option. So let's take a look at what they do. So I'm just gonna click somewhere. I'm gonna go to data and I'm gonna choose sort sheet that's going to sort it by column. Whatever college women so column F, let's sort that in descending order. All right, now, what that does obviously, is completely destroy the structure of what we had here. But you can see it's sorting the entire sheet. Let's undo that. So she sort sheet means exactly that. It's going to sort the whole sheet by whatever you've chosen. So that's a good option if you don't have anything else in the worksheet. If you don't have headings or you just have raw data there, you just want to sort everything than the sort sheet option is good. All right, This time I'm gonna highlight this range for January. So I'm just gonna highlight just this range where the numbers are gonna go to data sort sheet by rain. And if I say sort sheet by column, it's still gonna do the same thing. Okay, Even though I had a range selected, it's still doing the whole worksheet. So I'm gonna say sort data sort range by column. Diesel range not she lets do in ascending order. There we go. Post numbers from smallest to largest. Let's flip that now We're going from largest to smallest, so this time it's just staying within the range, right? Let's undo, Undo. Okay, so if you want to just sort that particular range, all right, quickly or sort your whole list by that one range. Do data sort by range. Now I'm going to highlight this whole list. Now, this whole continuous range and I'm gonna exclude the totals area the bottom. I am that include the headings, though, and I'm gonna go to data sort range when I choose sort range. I can tell it what I want. I'm gonna say data has hetero. It does not say that by the fault, which is why it's just saying Column A B c d E f g Once I check that that has a head a road . Now I consort by the specific column names. Let's sort this alphabetically by last name sort. Every gun sorts all my data alphabetically in that manner. Let's choose to sort by the vision. And then let's add another column in here within the division, I would like for it to sort based on the total in descending order soared. We see it doing just that, and it moves all the corresponding data. So within the divisions northeast. So here's what I mean when I say sorting. Sometimes groups like values together grouping all the Northeast divisions together. I see it sorted in descending order. When it switches to Northwest, that sort starts over again. That goes to southeast. It starts over again and so forth. All right, So the moral of the story is we start by highlighting. If we're sorting by a specific range, we start by highlighting what we want, and then we can choose to sort the range using one column or by multiples. If you had an instance where you wanted to sort the entire sheet we see it gives us options to do that as well. 38. Filtering Sheets Data: Let's talk about filtering. So what? Sorting? We know we're arranging the data in a specific order or grouping like values together. Right? That's sorting with filtering. The goal is different. When I filter. I only want to see data that meets whatever criteria I have set. Okay, So for example, maybe I Onley want to look at data for the Southwest Division. Wanted to hide everything that is not a part of that division. That's what filtering is going to do. Two different ways we can turn on our filter on. When we turn it on, it's gonna be dropped down arrows in our hetero and through those drop down arrows, we will be able to choose the specific filter settings we would like to incorporate. Let's do it now. We do have a filter icon over here in the toolbar. It can create a filter. That way, if we hit the drop down arrow there, it talks about filter views. We'll talk about that in the video. I can also go to the data menu, and I could choose create filter there as well. All right, so this turns on my filter. Now my filter gives me these drop down arrows. Very futuristic looking. Drop down arrows here in the head a row. If I click on the drop down, I see several things I can sort in ascending or descending order. So it does put sword options there for me. And then we have a few other things down here that we can do. So let's go through some of these. First of all, I have a filter by values area that gives me the search area and these checked boxes. This is my most common filter. I want a filter for just the West Coast wants to do the East Coast, right? So I'm gonna uncheck Northwest and Southwest, all right? And I'm gonna click, OK? And that filters this date, us. And now all I see is the East Coast. All right, let's go over here to our totals. Filter by conditions so fit survive by values again. We have all these specific values filter by condition, allows me to do a custom filter. I couldn't see things that are empty text that contains a certain value dates that are in a certain area. And then I have different comparison tools. I want to see all the totals here that are less than 100,000. Let's do a filter by condition. Scroll down here. Let's find less than there. We go say less than and then we can put in our value are Formula 1000. I'll click OK, and that filters there. And I don't have any the less than 1000 I think I meant to say 100,000. Let's put two more zeros here. There we go. That's what we wanted. All right, so we see that we're able to go one column of the time and add to our filter. No. When I take a look at my head a row, I see that it colors in and gives me a little fill A little green filter symbol there where the arrow used to be the futuristic arrow, and that lets we know that there is a filter specifically on that field. So I'm gonna go to my division filter. When you click on that, I want to clear this filter out. So I'm gonna say clear. And then I'm gonna say Select all when the click, OK? And it gives me everything, but I still have this filter on. So that's why I guess there are no values in those in the West Coast that are under 100,000 . So let's change this up. Let's change this to 200,000. Let's see if we can get our West Coast values back. Every gun there. We have some West Coast in there, all right, so we can go toe one column of the time. Clear the filter out, change what we have. Let's go over here and we can change this back. We can also go up to our menu here. Look at our filter options there. I could turn my filter on or off by clicking on that button there as well. So very easy for me to apply a filter, using the basic settings there as far as the values that they're there or apply a specific condition. 39. Using Filter Views: I'd like to introduce you a really cool feature called filter views. So when we're doing a traditional filter, we don't really have a way of saving it, right? We have the filter there, but, you know, we clear it out, we have to go back and re created again. Not a huge deal. But that could be time consuming if we know that there's a specific filter we want. And also, if we're dealing with a lot of users who have varying skill levels, maybe they haven't seen this video, so they don't know how to create a filter. Right? Which is just said when you think about it, everyone should know how to do that. Um, and everyone should see these videos, but everyone doesn't. So we can create or basically pre make these filters for them, which is what filter views do, and they'll be there in the list. And they could just choose the specific filter they want, and it'll automatically apply. Let me show you what I mean by this. I am going to do a separate filter for each division filter view rather for each division to do this, I'm gonna go to data filter views on the creating new filter view. It gives me this new view, and I can see what I've got here. Gives me this black bar across the top were first of all, I can name it. One unnamed, this northeast sales. I can see the range or change the range of manipulating here. I'm gonna go ahead and apply my filter. Let's change this to just northeast. All right? Just Northeast. Is there good close that let's do another one filter is now. When I go to filter views, you can see Northeast sales right there will ignore that for the time being was created new ones making sure I didn't have the filter still on this to Southeast. And let's go ahead and filter that for our southeast folks. Let's do one here for the Northwest, and then we'll do one for the Southwest. We'll call it Northwest Sales. Oh, right. And one more to go to Southwest sales. All right, Good. Okay, So all that's done. So now when I go to data and I go to filter views, I have all these views pre made, So somebody comes along, they want to see the Southeast sales. They just click on Southeast sales. Boom. There's it already filtered for Southeast. They won't see Northwest boom already filtered, so filter views are really, really cool. Those little they're going to sit there. I can easily apply them or close them in the upper right hand corner. I have a settings, buttons, little gear for options. When I click on it, I see that I can rename it. Update the range right? So if I need to expand, the range that's being looked at is being filtered. I could do that. I can also duplicate this and delete it, duplicating as good. As a matter of fact, If we just left it here and went and did a new one, we would be able to create a new filter based on this existing filter. So you can kind of do some filter view, inception kind of stuff right there. That's very cool. Very good for you, because you save time from having to recreate everything. And it's very good and user friendly for other users who may not know how to apply filters on their own 40. Using Freeze Panes: When you start scrolling around in a list, you can lose your headings, right? If I start scrolling down here, I lost my headings. I don't know what each of these columns are, What the calculations are Don't know. So I may want to do something called freeze panes and freeze panes allows me the freeze of particular portion of my sheet so that it stays in place as I scroll through the rest of my data. So we'll talk about freezing of rose. Um, several options here. I'm gonna start by highlighting my head a row here. So row three gonna go to view freeze. The first of all, whether I've highlighted something or not, I have a couple of options. Aiken say freeze one row boom immediately freezes that first row. If I scroll up and down, there we go. I could expand that to two rows if I wanted or let's unfreeze view. Freeze! No, Rose. I've highlighted this row. I'm gonna view frees up to current row. So that's going to include the road that's highlighted. There we go. And now it's frozen so I can scroll up and down and still view my headings. Now we can do the same thing with columns now. It's not gonna let me do that right now, because I have. Unless I was trying to freeze everything, including, ah, the division. If I were to say up to current column was going to yell at me, and the reason why is because I have a merged sell up here that's kind of messing me up, right? So if I UNM urged that, let's just unm urged that just for this exercises sake and the highlight column, Sea View frees up to current column. Now I have it frozen on my columns as well so I can scroll left to right. Headings are frozen. I can scroll up and down. My headings are frozen that way also. So this is a very useful way to just lock certain portions of your sheet in place. You can scroll around. I want you guys to give that to try. There is a exercise. Follow a project file you can use right now. I'd like you to go ahead and open that up. Get some practice with this. Manipulate your data here, do some sorting, do some filtering, do some freezing and just get comfortable with using Google sheets to manage your data. 41. Using Find and Replace: I'd like to take a look at the find and replace tool before we print anything we may need to update our data. Make sure that everything is displayed correctly. So I have a couple of shortcuts I can use to get to find them. Replace the shortcut for fine Would be control F. That brings me up to the upper right hand corner. Here. Find in sheet. I want to find Mawr. Type that in. It highlights right away for me, right? I want to find Let's say Robert starts finding that for me. So as we type, I can begin to find things that shows me how many instances. And I see that there are arrows here. Why can navigate to the different instances of whatever it is that I am looking for? All right, so that is pretty awesome. There's a more options button over here on this side and that pulls up my full find them. Replace window control. H is the short cut to pull up the full fine and replace windows to control F. That just gives me my find area over in the upper right control H gives me my full finding . Replaced window. I can also find that under edit. If I goto edit, I can choose. Find them replace. We'll pull up here as well. All right, let's find employees must replace that with associates. Sounds more official right now. When I'm finding and replacing, I can choose where I'm gonna search all my worksheets, just this sheet or a specific range. I can also choose how specific I want to be with what I'm finding to do. The replacement Don't want a match casing or capitalization. Do want to match the entire cell content. Or do I wanted to just find that value within other values. Going to search using regular expressions. Don't want to search within formulas, right? So I'm not going to do any of those. I'm going to just do it. This woman say replace all and it tells me it found and replaced. Two instances of employees with associates can hit, done. And if I scroll around here now I can see there it is associates right there. Let's find the other instance. Let's go ahead and search for that control F. So she it's on the other instances here inside of this area there, so very easy. Once I use my shortcuts or my edit menu to get in to find them replace, to find the specific values that I want and possibly replace them. 42. Using Spell Check: Let's talk about everybody's best friend. Spell check. All right, so we want to make sure before we print our spreadsheet that they're in the spelling errors in it, because that's embarrassing. All right, so we're gonna go to the Tools menu. We'll take a look at some of our spelling options here. Tools spelling. Let's go ahead and go to spell check. All right, so this is going to take me to each individual word that may be misspelled. Soc Division's eyes, misspelled over here is going to allow me to change or ignore. So once they change this change that we see it doing that for us Commission. Let's go ahead and change that as well. And I say, I don't have any more spelling errors happening in here now, one of the things that we see here when we do, let's undo our last one here so we can see the option. I want to show you one of things that we see is an option toe. Add this to the dictionary. So if we added to the dictionary and that's great for words that might not recognize, sometimes last names will get you in trouble. Maybe the name of a company, the name of a specific feature or just a certain spelling of something. You can add that to your personal dictionary if you want it to do so. All right. So I could say Add to dictionary. It adds this to my personal dictionary. Now, if I go to tools spelling, I can see personal dictionary. When I choose that, I can see the words in there in there, I can start adding words in manually. Let's add in McCray. All right, Um, and then that's it. But anything I want, I can manually add in. So now it will spell using these options here. Uh huh. So I can go to tools spelling, run, spell check, and manipulate my personal dictionary. 43. Preparing a Spreadsheet for Printing: Let's look at some of the options for printing and setting up our worksheet for printing. I'm gonna go to file print now. You could also do control. P will take you here as well. Look at some of the options we have. My first option is I can choose what I'm printing. I don't want to print the current sheets of the whole sheet or just selected cells, so I actually would like to select some cells here. I'm gonna just grab my title and all of my data. I'm going to control P. I'm gonna say selected cells. All right. Secondly, I can choose my page paper size, right. Thirdly, I can choose my page orientation, portrait, war landscape. I think I'm gonna go landscape here and then I get to choose my scaling that Here's what we need to be careful. Let's switch back the portrait for a sec. Here's where we need to be careful when I go to scaling and scaling is the size of my print job. I can choose to put in the specific percentage number. Let's scale this to 70%. Can we see? It gives us more data. So the more you scale of the smaller you scale, the smaller your print job is going to be in terms of size. What I like to do is come over here and I can choose a specific fit. I could do a fit toe with meaning. It's not going to do any column page breaks. I like to do that way. Columns page breaks are just weird to me. I could say fit to height, and that's not always the best idea. Or I could just get right down to it and say Fit to page again. Also, not always the best idea, because it's going to scrunch both your rose or your rose and your columns. Columns aren't typically, the problem is getting all the rose on one page. If you have a long list that could be ugly. Someone changed this back to fit toe with, and I'm gonna change this back toe landscape and that we have a pretty nice looking situation here. Now I can adjust my margins normal, narrow. Let's do some narrow margins here, and then I could come down here and start doing some customization. Some formatting here I can have it show grid lines or notes. I can adjust my alignment. Go ahead in the line. Everything center and not vertically will on it top and then center horizontally. I can do headers or footers, so I come here. I couldn't do things like headers and footers. Page numbers. It'll put them in there. Workbook, title sheet Name could do date and time has pre made places to put all these different things. I could do an edit area here and start doing something customs. I could go to each area and choose what I want down below. Here. If I had a frozen row or column, I could choose to repeat that as well. Come. So let's say I did that. Let's come back up here. Let's go ahead and freeze this row view. Freeze. Go back to our print option here and I could tell that keeps all of my stuff except for my selection. Okay, so what? I need to redo my selection here. Let's just do that quickly. Selected cells keeps on my other settings, and by the fault, it's automatically repeating frozen rose. I could turn that on or off, and there we go. We have a pretty nice looking friend job here. I would hit next, and they would then take me and to be able to choose my printer and print my information out. 44. Changing Spreadsheet Settings: There are several spreadsheet settings, just general spreadsheet settings that we can adjust and change for what we want to do inside of our sheet environment. I'm gonna go to file. I want to go all the way to the bottom and go to spreadsheet settings. And we have a couple of basic settings areas. Here. We have a general area in the calculation area in the general area. I can change the locale this is gonna have to do with the formatting functions, dates, currency. I can switch this to someplace else. Let's switch this to Sweden and see what happens. It's just going to change some things here, changes some of the formatting a little bit it, as you can see. Let's see if it changed any of our formulas here. These particular formulas? No, but it did do some adjusting their Let's go back. I can change my time zone. Go ahead and switch our Tom zone here too. East coast. There we go. Then they have a calculation area here. I can choose when things were recalculated. I can have it re calculate on change and every minute or on change and every hour. So things like now Today, Rand, Rand, the Twinkie, those volatile functions is going to change how often they re calculate, Go ahead and hit save settings. And there we go with the just some of those basic sprayed spreadsheets settings for me. 45. Finalizing Printing: once we're sure everything is the way we want it to be. We can go ahead and finalize our print job, right? So back into our print preview. Let's go ahead and select this data again. Go back into our print area and we'll print the selected cells. It's all good. I'm gonna click next. So when I click next, it's going to allow me to set my destination. I can still see my preview Now, over here. If I don't have a printer, I can choose to save it as a PdF or save it to Google. Drive someone say, save his Pdf Matter of fact, I would say, Save to Google Drive and I will do. Pdf save as pdf All pages save. Where do we want to save? Let's go ahead and save it right on our desktop here. All right, take a look. Here is our pdf. And there we go. Everything works so very easy to print again. You don't have to have a printer. We do have the option of going to pdf 46. Downloading and Emailing Files: because we're working in a cloud based platform, we need to be able to download copies of our file here in formats that are compatible with people who maybe don't have access to Google Sheets on. We also maybe need to be able to email. Individuals are files as well. Let's look at options for both of those things. I'm gonna go file and I see an option here for download. Now I have different download formats I couldn't download in the next cell based format. ODS format. Pdf of course, Web page or a C S V or TSV file. Let's download this in the next cell formats. I want to say Microsoft Excel. We've downloaded it here. Let's go ahead and open this up locally And there we go. It's opening up in Excel and check it out. Everything is what it should be. Now, you, Any time you're downloading a copy, you may have some little formatting things. So I noticed that my top row was a little scrunched. Easy fix. All right, so very easy to download in whatever format you wish when I goto file, I also have an email as attachment option. So I can choose that I can choose the format that I want. Excel or pdf. I could then go ahead and put in a email address. I could put a subject a message, this email in Excel format actually send and it goes ahead and attach, is it? And it sends out, of course, through our Gmail account. Okay, so very easy to download in differing formats and easy to be able to send out as an email attachment. 47. Sharing a Spreadsheet: I want to talk to you about sharing a sheet, but I want to make sure we understand what sharing actually is alright. Often when we think about sharing is like, Oh, I'm doing email attachment. Well, an email attachment is technically not sharing its copy. So if I have 10 people on my team and I do email as an attachment, what I'm doing is I'm sending out 10 different copies of that particular document 11 including the original. If I make a change to the original, nobody else is going to see that. But me. If any of the other team members make changes to, there's no one else is going to see those changes, right. So that's when you email as an attachment. Sharing is providing a link or access to the exact same document to multiple people. Now what's the advantage of that? Well, one, any changes that are made, everyone's able to see right. So if I update it, everybody could see those updates, so that's cool. Secondly, it opens up something for or opens up a door for co authoring where multiple people can make changes in view at the same time, and we can work together as a team. So whenever we want to be collaborative, sharing is the answer. There's a button in the upper right hand corner that says, Share right, let's go ahead and click on that. And if I hover over that first of all, it tells me the sharing status. Unless we know that right now this is private to Onley me. Go ahead and click share And I couldn't do a few things I can choose to create a share a bowl link. All right, So if I click, get a share a bowl link, this is going to set it up so that just anyone who has access to that link convenient. So if I put it in like a website or if I just send it out through email, I can say anyone at our mark and edit, comment or view. Or I can get down here and say, you know, this is on to the public on for anyone with this link on just within the company. So I'm gonna say anyone within Aramark can have access to this. I'm gonna say save. And now that link is there for me. I can also put in specific individuals and I can choose the level of permission that they're gonna have. And I could go ahead and hit send, and it'll go ahead and send. Now, if someone does not have a Google account, which this address is not, Ah, Gmail account here, it's gonna make them sign in within 14 days to be able to edit. All right, that's fine. So now it tells me it's shared with one person, noticed the difference in the icon. I now see people that are more with that Lincoln view, and once the individual that I sent it to signs in, they would be able to view this as well. So sharing is great for collaboration, and right now there is a file that you can use to collaborate with, right? So if you want to go open up your project file, go ahead. Experiment with some of these print settings Ah, spellcheck and other settings that we have for finalizing a sheet 48. Inserting a Chart: All right, let's take a look at some chart creation options here. Very easy to create charts and Google sheets we've already seen. We can use the Explorer feature to do this, but let's look at how we can just manually create a chart. I'm gonna start by selecting my data. So I want to do a chart based on these monthly numbers. I'm gonna grab the mumps whenever you can. Grab headings and values you want to do. That just gives you less work to do. Later on, we're gonna do this. I'll break this down based on the names eventually, but for right now, since they're separate outside of the division will just leave it this way. I haven't insert Chart icon here in my toolbar. I can also go to my insert menu and I can choose chart and there is my chart. Now. It gives me my chart editor, and I could begin to customize the look of my chart so I can set up the chart type. I could do a line graphs I can do column graphs here, stacked or unstaffed bar graphs, all other kinds of charts, tons, different types of charts in here do we can play around with? So I think I want to do a bar chart. So when you choose a bar chart, if I wanted to stack, I could choose to do either standard stacking. So it's stacking the months on top of each other like so, or 100% stacking worse, using the complete access here. I'll leave it. There is none. I have my raw data range here. That's what my numbers and such are, and I see it gives me the ability to add a Y axis. Now my legend or my Siri's has already set up here. I could go toe. Why access? And I'm going to say that I want to put the last names in the Y axis. Click OK, and that puts those names in there for me. Easy stuff. All right, this is cool. Now I have the ability to do an aggregation here. If I wanted to, I could do that or not, where I could have it combined everything together. If I had multiple instances of the same all right, I could combine them together like so So that's cool. I'm going to scroll down further here. I have the ability to switch rows and columns, so if I hit that, it's going to switch them. So now, instead of putting the sales people here, is gonna put them in the legend. A. Leave it just like that. All right, it's gonna move this guy out the way a little bit. I'll do one more. Let's do a pie chart. Do a pie chart based on these grand totals down here, someone highlight those totals. Let's use our icon this time insert chart, and I'm going to scroll down and do a three D pie chart. Ooh, that's nice. Now it's not giving many values. I'm gonna need to switch my rows and columns to see them. Gonna add some labels in here for my months. Nice, easy stuff. All right, so there is my chart now. We have all kinds of customization options and things that weaken due in regards to formatting and chart turning on certain elements. Turning off certain limits will take a look at that. In another video 49. Formatting a Chart: Let's take a look at some of the formatting options for a chart, someone to focus on my bar chart right here, and I'm gonna click on it now when I click on the chart in the upper right hand corner, I see these three dots and this is a more options button. Whenever you see that, that always means there are options there, someone to click on that. And I see I can edit the chart. Delete it, copy it, download it. We're just gonna edit chart right now. When I choose edit chart, I'm gonna go ahead and click Customize, and this is going to give me several different customization options. Let's move this over a little bit will make it just little larger just so we can see and we'll go from the top down. So charts style. First of all, chart style. I can give my chart a background color if I want to. All right, let's put a little faint something in there. I give my chart a border color. My layout. I can reset it. I could maximize the layout. Yes, that's a cool feature, so it kind of takes up the whole space I can also switch this to be three D. Uh, I can change my font. That's pretty cool. Some very straightforward, clean options here that we can use chart access and titles. I can turn on the chart title, go ahead and give my chart a title. Q. One sales shows up there. I can choose where I want it. I want it centered. Do I wanted to have a certain color? All right. Whatever it is I want, I couldn't do there. I can adjust my title font and font size. Uh, I could do the same thing for a chart subtitle. If I want to give my child the subtitle, I can do that. I can adjust the horizontal axis title and I could do a vertical axis title. Let's put in Sales Associates for our vertical Axis title, Huh? Siri's right. If I want to do data labels, all right, put labels at the end here of each thing. If I wanted to, I don't tend to like to do that with bar charts or column charts could be kind of messy, so I'm not going to, but we could. My legend. Where do I want that to be inside top bottom. All right, I tend to like to put the legend on the top. And, of course, I have all my other formatting options for fonts, right? Those can obviously be adjusted here. Let's just change the font color. Just make it black horizontal axis. I can control the minimum and maximum values, as well as the formatting scaling and the number formatting. It's gonna pull the number formatting from the data by the fault. Switch this to custom. If I want to do a custom format. I can from data is best because you could just adjust the number formatting on your sheet little flow through to your chart exact same features for my vertical axis. I don't really need to do anything there. Let's just change our color unless I italicized it. Make it a little interesting there. I can also reverse the Axis order here, So if I want to switch him flip flop, But I can and then lastly, grid lines where that can put in major or minor grid lines. Let's actually turn the major grid lines off, and then maybe just for good measure, let's come here and let's turn the data labels on and let's position them on the outside end. Well, we'll put them inside like so. That's nice. I like that. I see how the automatically adjust. The color is there for you. That's pretty cool, all right. And so you can easily format your chart using those customization options. Now, we could do the same thing with our pie chart if we wanted to do so. It will not give us all the options as a column chart, because they're not multiple axes, but you can customize all the chart elements and formatting however you see fit. 50. Moving and Sizing a Chart: Once we have our chart created, we want a position it where we want it to be. And that position might be outside of your sheet if you want to. So let's take a look at some ways to do some things here. So, first of all, if I click on the chart, I can select it first, and then I can click and drag to move it. I can use the handles on the outside, of course, to resize it. Okay, now, if I click on the more options button here, I do see have the ability to move a chart to its own sheet. Now I have this whole sheet just dedicated to this chart. That's pretty cool. I also have the ability to download the chart so far were to say, download chart. I could download it as a picture or as a PdF download is a pdf. It's Open it up. There we go. Uh huh. So very easy here. Once we have a chart to move it around, turn it into its own sheet, copy and paste it. We can still edit it. We also have the ability the publish our chart, uh, to a Web based location. If we wanted to as well or embed it in a Web based location as well. All right, there is a project fathers you can use to get some practice with all of this chart material , go ahead and open that up and have fun making and publishing some charts. 51. Inserting Images: you may want to insert an image into your sheet, and it could be for, like, watermark purposes or just general branding like your company logo. Um, or as use, even as a background just for any purpose, you might want to insert an image. The cool thing about Google Sheets is because it's cloud based. Already, we can grab images that are in the cloud and our Google drive. We can upload things and have them inserted. If we want, we can pull from our local computer. Let's take a look at the options that we have. Wanna go to insert image. I see two options. Image in cell, meaning it's gonna put it in the cell and replace the contents of that cell. So you wanna be careful with that, an image oversells where it'll insert like a traditional image that we can move around wherever we want. Let's do insert image in cell to start, and it's going to give me different options Here. I can upload an image. I can take a snapshot. So if I had a ah camera here that I wanted to use, I could do that. I could paste in the U R L or because we're in Google sheets. We can go ahead and look for our Google drive and grab an image. Let's say I want to grab this image right here from my Google drive hit, Select and it goes, and that puts that in the cell. Now again, this is not always ideal here. It is rather small, actually See what happens if I merge some of these cells together here and see what it does to our image. There we go now increases the size of our image, but as you can see, the quality is not that good. So putting things in the cell that's good. If you have a specific decoration or icon or something like that that you want to use to replace the values of a cell, let's insert another image. Let's do image oversells and let's actually upload something, someone to choose an image to upload, and I'm gonna go ahead and grab this large logo is gonna upload it, puts it in our Google drive, and there is are large logo. I could drag this around. I can use my handles, of course, to resize so very easy to insert image again. The good thing about this is when we upload is putting it right in our Google drive, and that's where it will be. We have the ability to put the images in the cell and replace the values or have it over the cell where we could move it around and manipulated. 52. Creating Drawing: If you don't have a pre made picture, you can do a drawing. When we insert a drawing, it's going to give us a whole new window where we can do our drawing. And then we could put it in our spreadsheet. Let's take a look I want to do insert drawing and it gives me this whole campus here. Work and draw. Now let's look at some of the things we can do across the top. I have my selection tool. I could do a line tool, arrow, elbow, connector, curve, scribble. I could do different shapes. Text box or an image. Let's go ahead and insert a couple of shapes here and we'll make a little logo. All right, so I can insert whatever it is that I want. Let's insert some things, all right, and we've got ourselves a little something. Now when I go to each thing here, I can format all right, so I could highlight format this stuff, however I want. All right, there we go. I also have the ability. If I goto actions here, I can download this. I can also do word arts. Let's insert some word art puts my word out right here. That's kind of throw this inside of our little logo here. Oh, that's lovely. Lovely artwork here, folks. All right, strength that down a little bit. So I can sit here, and I can really draw whatever it is that I want to draw. Set it up. However I want Let's go ahead and put some formatting here. I don't want that. All right, this is good. Saving close. And there we go. My image pops in. I can resize it. However I want moving around. If I double click on it, it will bring me back into my edit mode, and I can further and it this image, Let's go ahead and download this as a JPEG. Open it up and there it iss All right, this is good. So very easy for me to be able to download Manipulate, used this image. Go ahead and take a look at the project file associated with this lesson and get some practice with images 53. Course Recap: man. Google Sheets is an amazing platform. I told you that we're gonna learn some interesting things, and I know that we did. I remind you of a couple of things. One. Make sure you use that explore feature that's really going to save you some time and allow you to create some creative things. Some charts, some calculations and things of that nature. When you're getting ready to find them, replace data. Remember those shortcuts you can use? Remember control F just to find and control. H is going to allow it to both find and replace. And lastly, I want you to remember that there's a difference between sharing and doing an email attachment. If you wanna have collaboration share. If you just want to share data or allow other people to access data but not be able to change it or view updates, then save it as an email attachment. So thank you so much for attending this course, and it's been my pleasure to share this information with you. Can't wait to see you In another video