Google Docs Advanced Tutorial Office

Google Docs Advanced Tutorial Office Elissa Smith: Hey, everyone. Welcome to our advanced course for Google docs. My name is Alyssa Smith. I've been a software applications trainer for over 20 years. I'm super excited to be guiding you on this journey into advanced features of Google docs. Now, in this course, we're going to explore some great features like how to create and format tables. We're also going to look at textiles and how you can create your own textiles along with bringing images into Google docs and other advanced features like being able to bring in data charts and even create more advanced documents that have things like bookmarks and even footnotes in them..

So join us as always, if you're enjoying these videos, please like, and subscribe. And if you're looking to earn certificates and watch videos without ads, sign up for the learn at any time, it's our dedicated online training subscription service. Check the link in the description for more info on. If you have any questions you want answered by one of our awesome instructors, please join our offsite community. The link is also in our description and as always, if the course has exercise files, you'll find them in the video description below..

Hey everyone. We are ready to create some tables inside of Google docs. So I'm going to come up and actually create a new blank. Google doc, just by clicking of course the blank button. This takes me into a new blank, Google doc, and I want to add a table at the very top. So I'm going to come up to the insert dropdown menu table is the second item. Now, what I'm going to do is actually take my mouse on the secondary menu and run it over the number of columns. And then down to the number of rows that I want. I want my table to be three columns wide by three rows down..

So that's what I've done. You can do tables up to 20 by 20. So basically 20 rows down, 20 columns over. It's pretty large. As soon as I click, I will see my table get put into my Google doc. Now let's take a minute and talk about how you move in a table. Well, first of all, we can use the tried and true click. This will move your cursor to the cell that you click in, but you can also use some great keyboard tools. The tab button is great for moving from again, one cell to the next it'll move you horizontally over, and then you can use shift tab to move yourself back..

You can always use the arrow keys to move you up and down left. And right now to select an entire row, for example, you're going to bring your mouse pointer over on the left hand side and just left drag over it. And that will select that particular row columns work the same way. You're going to rest your mouse pointer over the top of the column and drag down. You just have to be careful because it also likes to select the entire table as you can see here. So sometimes it helps to bring your mouse pointer kind of down into the first cell of the table and then drag down. Now, what about some shortcuts for adding like a new row at the bottom of a table?.

If you go to the last cell of your table and hit the tab button, this is a great shortcut for adding additional. So now my table is four by four. And you know, a lot of the table tools that you may have used in other word, processing applications, like Microsoft word, they work in similar ways inside of Google docs. So again, we'd love to have you try it out, open up a new blank, Google doc, and try creating your own table by going up to that insert drop down menu, and again, make a table of your own..

Google Docs Advanced Tutorial

Hi, everybody. I want to be able to take my table in a Google doc and add new rows and columns, delete rows and columns, and also, you know, change how the width of the rows and columns are working. So let's take a peek at that. First of all, how do I add new rows and columns to my table? I already saw that if I go to the bottom of the last cell of my table and I hit tab, when my cursor's blinking in that cell, I get a new row. So it's a great way to, for example, do data entry. Cause as soon as you get to that last row, last cell hit tab. You've got a new row. You can keep typing, but what if I'm in the middle of the table and I need a new column..

This is where if you're on a PC, right? Clicking is a great way to go. So if you right click, you'll see that you get a secondary menu. About the third tier fourth tier down in this menu, you've got great tools for helping you insert both rows and columns, and it lets you pick where they're going to go. So I want a new column to go to the right. So I'm going to come into this secondary menu and left click on insert column. Right? You'll see. That's exactly what it does and notice how it auto fits the columns so that they're all staying within the width of the page. Now a new row, same thing I can come in, right click and.

Say new row above or below. In this case, I'll say below, and you'll notice it puts my new row right in where I need it to go. Now, what about adjusting the width and the height of columns and rows? Let's start with column width. I'm going to bring my mouse pointer right between the columns and I'm just going to left drag. And this is very common in a lot of your, again, both spreadsheet and word processing applications. You can basically auto fit your columns just by left dragging and adjusting the width that way..

Additionally, when it comes to row height, same thing. I'm going to rest my mouse pointer between the. That I want to adjust just left drag down and that particular row we'll get taller. You can also go to a row that you're typing in and hit your enter key. That's an additional way to add extra line space into those columns and rows. Now, as always, we want you to try this out. So please go into our exercise files. There's a file there called table one a and of course it has a table in it, and we want you to practice adding your own columns and rows to that. Google doc, go for it..

Hey everybody. Welcome back to Google docs. Advanced. I want to show you how to format a table also, how to delete rows and columns, merge cells, just some great tools to help you make this table. Look the way you want it to. So let's start notice I'm in a Google doc called office return plan. If you go to our exercise files folder and open up office return plan dash a, you can try out this same stuff in that Google doc. Now the first thing I need, and my document is I really need a title row at the top of the table to do this. I need to insert a new row in my table. So what I want to do is click on the road that I want my new row to go above..

Now I could right click and do this. But there's actually also a menu in the format dropdown menu that you can get to. So I'm going to go up to format, come down to table and you'll see that you get some of the same options you would have if you were to right click. And I'm going to go ahead and select insert row above. So I get a new row. It does have four cells in it, and I need these cells to all become one. This is called merging to do that. I'm going to highlight the cells in that row. And then this one is easiest to get to if you right click. So I'm going to right click and you'll notice that about towards the middle bottom of the right click menu. I have a merge cells and it takes all of those cells and makes them into one..

    Now I can type a above the top.

    My title for my table. Now, if I would like to format this text, it's really easy. It's just like formatting normal text in a paragraph. I'm going to drag over the top of it with my mouse, come up to the tool bar notice I can increase the font size, make it maybe a 14 point font size, put it in bold. I can use my center alignment to center it. I can even change the font size by using the text color, but..

    Let's go for a lovely shade of blue. And now I've added a little bit of formatting. What if I have an extra column in this table that I would like to get rid of? You'll see here, I have near a sanitizing and near as hand washing area. I really don't need both. They're kind of redundant. So I'm going to right click in the column. I would like to get rid of, I don't even need to highlight it. I can just right click, but you'll notice that when I do. It it's easiest. If you do it away from text that I do get an option to delete the column. When I do this, it's pretty cool because it actually you'll notice resizes. The other columns underneath..

    And my top row is an impacted because it's just all one cell. Now, finally, one more thing that you can do sometimes in tables, it's very common to get on equal column width. So you can see that here. And this is just because people have been dragging the columns and changing their width. But if you would like to make them all consistent, you can highlight the columns or the rows, right. Click inside of them and come down to distribute columns. What this does is it gives all the columns, the same width. If I were to do the same thing with the rows, the same thing, what happened now, finally, if I need to delete an extra row, same thing, I'm going to right..

    Click. Come down and say, delete in this case row. And you'll notice it just gets rid of that extra row for me. So the right click menu is really important as always. We'd love to have you try this out. So please go into the exercise files folder, open up office return plan a and try again, formatting that table. Hi, everyone. I want to take a table in a Google doc and really get in and format that table..

    So we've already seen how you can use options on the toolbar to help you format text. But what about things like the background, color of your table? Also the border color of the cells, things like that. So notice I am in a file called office plan, office return plan dash format in the exercise files folder. There's also an office return plan dash format a if you want to try this out. So the first thing I'm going to do is I'm going to actually come into an area called the table properties. So for this I'm going to right click anywhere inside of my table and notice..

    Fourth or fifth from the bottom. You'll see table properties. If you were not on a PC and could right click, if you go up to the format dropdown menu and come down to table, you'll see the bottom of that menu will also take you to table properties. So there's, there's multiple ways to get here. When you get into this box, you're going to see again, properties for the entire table. First of all. What is your color border? Now the default is black. Notice. I could come in and make this white. If I do that though, notice when I come to my table, I don't see the borders anymore. This is a great way to create really lined up texts without.

    Having to have borders turned on. I'm going to turn that off just so we can see them again. And then I'm going to right click and go back down to table properties. I want to change my borders to maybe a dark, well, let's say a dark gray. I can also increase their font size notice right here. The fonts are done in points. Then I also have a cell background. Sometimes this is referred to as the fill color of your cells, I'm going to come in and change it to kind of a light yellow. Now sell vertical alignment. This means if your cells are really tall, are they aligned at the top, middle or bottom?.

    I'm going to put mine in the middle that you can't really tell right now because all of my cells are so narrow in their height, but we're going to change that in a minute and notice right here, if the table doesn't take up the whole page, you can also see what your cell alignment is. Now. Cell padding is going to be the amount of space between the top bottom left and right of each cell. And then notice here, you can also manually adjust your column widths. So maybe I want to change all my comments to just two. I'm going to click on. Okay. I noticed that in this case, because I didn't have the rest of the table selected, it's just done it to my one cell that I was in..

    But do notice here that the borders have all updated. So this time I'm going to highlight the entire table and right. Click and go down to, in this case wellness, when I right click, I'm not seeing that option. It's because I've selected outside the table. So if that happens, go up to the format, drop down menu and actually come down to table and then go to table properties. Now in here, if I make those changes, Right. If I go ahead and make those changes, notice the column with is still there, but I'm also going to adjust the column widths, and.

    Then I'm going to click on, okay. This time, notice the changes have been applied to the entire table and even my column wits have adjusted.

    Now I want you just to see that if I make this particular row a little bit taller, notice how the alignment of text is always at the top. And that's because that was the cell alignment that I selected as always, we want you to try this out. So, like we said, go into the exercise files folder, open office return plan dash format a and try formatting your table..

    Hey everybody. Welcome back. We're ready to apply some textiles in a Google doc. Now right now I have a file called agent meeting open. Please remember if you go to our exercise files folder, you can also open an open up agent meeting dash a and try out some again, textiles in that Google doc. Now, first of all, what is a textile? A textile is a combination of prebuilt formats that are going to include font size, font color. Even if something is an italics or bold, all combined into one word to quickly.

    Apply all those formats at the same time. Uh, great news. Google docs has some built in textiles that you can use. Sometimes they're also referred to as paragraph styles. So to use one of their default again, paragraph styles, the first thing you need to do is actually click in the paragraph where you'd like to apply the style. So I've come in here and I'm going to click in my very top line and come up to the toolbar. You'll see, right now it just says normal texts. This is the default style, which means there really isn't a preset style right now applied. But if I click on it, you're going to see that I have several, all the.

    Way from title down to heading three. Do not. Once you pick heading three, there. Three more headings. It goes all the way down to heading six that you can use, but you won't see it until you apply heading three. So I'm going to go ahead and click on title and you'll notice it applies it to that specific line of text. Now, if I come down to another line again, another paragraph, and this time I'm going to select heading two, you'll notice it applies it there. And I could continue to come down in the document and apply again, these different pre-built styles..

    And it's a really great way to quickly update my document as I come in and just quickly add these headings to my doc and it creates consistency. It's also a way later on to build outlines out of your Google docs and they automatically save, and you don't have to create them because they're built into the document. We'd love to have you try this out. So go to the exercise files folder, open up agent meeting Dashay and apply some of these prebuilt paragraph styles to your own Google..

    Hey everybody. We've been using paragraph styles in a Google doc, but what if we want to take the paragraph styles that Google has provided and add some zing to them? I mean, be able to adjust them, make them our own. So I have a Google doc open called agent meeting dash styles. If you go to the again, exercise files folder, you can open up agent meaning dash dials, a. Play with the styles in there, just like we're going to do so, first of all, I've applied, heading to, to a couple of the paragraphs in this document, you.

    Can see up here because when I look at the tool bar, it tells me where that particular style has been applied. It's great, but I'd like to update it. And the great thing about. Style is if you update it in one place, Google doc updates it wherever you've applied the style. So it's a great way to make sure that you have consistent formatting in your Google doc. First thing I'm going to do is actually just click anywhere in that paragraph and I'm going to make some changes to it. I'm going to highlight actually all of it, because these will be some additional formatting changes..

    I'm going to come in and apply a new font color. I'm also going to apply a new highlight color. So notice now it has the red font color with the yellow background. It sticks out a lot. Now at this point, if I look at the other places where I've applied, heading to, they have not updated, so I can make sure that they also look like this new change I've made. I'm going to click in that paragraph, come up to the format again, drop down menu, and I'm going to come down to. Paragraph styles. Now I know it's heading to that..

    I've been playing with, so I'm going to come down to heading two and you'll let us right now that next to heading to, I see the check mark apply heading to, but I've updated my heading to, I'm going to select update heading two to match. Now it's super cool is everywhere where I applied, heading to it. Now looks the same as the heading to that I've updated. So this is a great way for you to take existing styles and update them. Like I said, with some zing of your own. So..

    Hey everyone. Welcome back. We want to create an outline of a Google doc. Now, one of the great things about using paragraph styles in a Google doc is that it will automatically create an outline for you. So just a quick review on what those paragraph styles are. Remember a style is a combination of formats, everything from font style to size of font and even color. So right here, if I look at this document, and by the way, if you want to try this out, go to the exercise files, open up consulting agreement, 2021 dash one, and you can give this a try yourself. But when I click inside the very top paragraph and I look at my again, tool..

    I'm going to see right here. It tells me that the title style has been applied to that particular paragraph. If I scroll further down in the document, I'm going to start seeing that there are headings. And when I click on one of those paragraphs, I can see it tells me it's heading one. Now, by doing this, I'm actually creating an outline of my document. And let's look at the purpose behind creating an outline to open the outline up. I'm going to come to the top left-hand corner, really right under the undo and redo buttons. And I'm going to see this show document outlined button. When you click on this, you're going to see a list of where.

    Those different heading styles or different paragraph styles have been applied inside of the Google doc. All you do to use them is click and it actually takes your cursor up to the front of the given. So, not only is it an outline, but also it's a way to jump to specific points in the document, much like a bookmark or a hyperlink, and in a really long document, it's a spectacular way to quickly jump to different sections that you need to get to. Now, the other thing that can happen, and if you come down towards the.

    Bottom of the document, you can actually add to the outline to do this. You're going to apply paragraph styles. So I'm going to come right here to start with, and I'm going to click in my number 12, heading that I haven't yet applied a heading style to now I can come up here and use the toolbar by applying the heading there. I can also come to the format ribbon and go to paragraph styles. This is kind of like going the long way. Go down to heading one and then select paragraph style. You'll notice that that one actually did the entire paragraph. So I'm going to come down a little bit, so it doesn't include the paragraph above.

    And then I'm going to do heading one. Now, another thing to note is that it doesn't have to just be heading one. If you look here any of the styles in this list, including some additional styles that you'll only see when you go to the format, drop down menu and then go to paragraph styles, you'll see they go all the way down to heading six. These will also be included in your outline. So right here in the signatures line, if I were to come and I were to apply a heading two to that, you'll see that it's already added it to my outline automatically. And again, this is a great way for me to quickly update my outline by adding additional styles, you can use this not only as a way to create the outline,.

    But again, as a way to quickly jump to specific sections, try it out on your. Hey, everybody, I'm ready to add some images to one of my Google docs. You know, the thing about images is that they add so much detail and they also cue people's interests. What's the saying a picture is worth a thousand words. Well, that's exactly what we're trying to do. So right now I have a Google doc open called travel brochure. If you go into the exercise files, you can find a travel brochure dash one, that you can try this same thing out in. Now, what this is is basically a document talking about different.

    Travel destinations that a travel company is offering. And right here, you're going to see that I have Rome, Ireland and Iceland listened in my document. I'd like to have a picture underneath each of these locations, just help cue people's interests and get them into. So I've clicked right after the word Rome. And I'm going to hit enter now over on the right. I already have it open, but I'm going to close it so you can see how to open it to search Google for an image that you would like to insert into your doc. We're going to come up here to the insert dropdown menu and images, the very top item..

    And you'll see that there are different places that I can get images from. Now, if you don't have an image, a good place to start is to search the web. This is using the Google image search. I still remember the first time I did it and how impressed I was with all the images that came back. We do have to be aware of copyright when we use this tool, but in this case, we just want a picture. So we're going to click on search. You'll notice that it opens up a search tool where I can type in something that I'm looking for in this case, pictures of the beautiful city of Rome. And as soon as I hit enter, it starts searching for me..

    And here I can see all the different images to select one of them. I'm going to come over and click. You'll see that when I click, it gets a blue circle with a white check mark in it in the top left hand corner. Now, down on the bottom, right? This is really important to finish inserting the image. I need to click on the insert button. This is what will actually bring the image into my Google doc. Now you got to remember that when you bring in images, chances are they're going to be too big or too small. So it's up to you to click on the image. Notice you get the blue sizing handles on the middle of the.

    Borders and also the four corners. And you can actually use your mouse pointer on any of the corners to drag the image in or out to make it smaller or make it larger. This is a great way to size it down so you can get it to fit more correctly in your Google doc. Remember, we want you to try it out. So go to the exercise files folder, open up travel brochure dash one, and try searching Google and finding an image of your own to put into your Google. Hey everyone. Welcome back. We want to look at some more options for inserting images into a Google doc..

    So right now I have the travel brochure from computer open. If you go into the exercise files folder, you can open up the same thing by going in and opening travel brochure from computer dash a. So you can try this out. Now, what we want to do at this point is actually get an image that's stored locally on a network or hard drive of the device that we're using. But again, the steps are very similar. I still need to click where I would like the image to go in this case. It's an image of Ireland and I do have an image of Ireland stored locally on.

    The computer that I'm working from. So I'm going to hit enter so that my image will be placed below the word. And then I'm going to go up to the insert dropdown menu. And come to image. And again, we're going to see the different locations where I can get my image in this case. I'm going to go ahead and use the very first one, which is upload from computer a little bit different because we have to remember that Google docs is a cloud-based application, which means for me to be able to bring the image from my device, it's actually going to have to upload or copy it. But first I need to get the image..

    So I'm going to select upload from computer. It's going to ask me where that image is located. I'm going to need to travel to it. Once I find the image, I'm going to click. And then I'm going to say open, but really what's going to happen is it's going to copy it into my Google doc and upload it for me. Will it still be back on my local computer? Yes. This is not where it's moving. It. It is a copy and it is also an upload, which means sometimes it can be a little bit slow depending on your internet speed. You'll see, for me, it came in really quickly. Now, can I adjust the size of this image?.

    Like I did up above with Rome? I sure can. I can come to the corners and drag it and adjust it size and get it placed, uh, again, size wise and also location wise where I want it to go. Thanks so much for joining us. And remember, you can try this out by going into the exercise. Hey everyone. I want to be able to take an image that stored in my Google drive and actually bring it into my Google doc. Now, first of all, let's just see where this image is located..

    If I come to the top left-hand corner of any Google doc, I'm going to see that there's a little blue page. This will allow me to go to the docs homepage. When I click on this, I just want you to see that it shows me any again of the templates or even recent documents that I've worked on to the left-hand side of this. I actually have the main. For my Google docs account. If I click on this, I can actually come down to my Google drive and just reminder that Google drive is where you can store all of your Google content, including Google docs and images..

    When I go to drive, you'll see here that it shows me anything that's in my Google drive and this can include images. And right here, I can actually see this Iceland image that I would like to bring into my Google doc. So what I want to do is go back again to the document that I'm working with. So I'm going to go ahead and go back to the browser tab that I was just in. And then I'm going to come down to my recent documents and actually open up. The document that I want to put this into. Now, if you want to try this out in the exercise files folder, you'll see again, a doc called travel brochure from a Google drive, and you can use it.

    To try this out now to actually bring that Iceland picture into the document. I'm going to scroll down to where I see again, the information about Iceland and I'm going to hit enter then to actually bring that image from my Google drive into Google docs. I'm going to go to the insert dropdown menu, come to image, and then I'm going to select drive. It's the third item down now. What's great about this is it opens up a task pane over here on the right. And you'll see at the top that it lets me see any recent images I've worked with. It'll also take me just directly to my Google docs..

    My drive within Google. And then also here you'll notice if I have any shared areas within Google docs and he shared folders, it would let me see those. But if I go back to my drive, notice it showing me images, because that's what I've selected. I'm going to select the image of Iceland. Notice at the bottom. There's an insert button on the bottom right-hand corner of the task pane. And that's what we'll pop the image in. And just like with my previous images, I can click on it and size it by using those sizing handles on the corners, which is really nice.

    Because it sizes it both horizontally and vertically at the same time. So you've got lots of options for bringing images in. Hey everybody. Welcome back. We want to look at how you can set up the text wrapping around your images. This means how does text and my image work together in a document. So, first of all, I want to go ahead and bring another image into my document to use. I'm going to click right here and go up to the. Drop down menu, come to image. And this time I'm just going to search the web. Remember I can come over to the right and use the Google search.

    To look for anything that I need. Just remember these are not copyrighted, but it's a great way to bring an image quickly in to your document. And I'll see my image get put in here in just a moment. It's come in a little bit big, but notice that it's gone exactly where my mouse cursor was. I can click on that image and I can size it. But notice right now it's set up to be inline with text, meaning the text in the image. The same level. And I'm going to go ahead and come up to my toolbar and zoom in just a little bit, because I want you to be able to see these options..

    DISCLAIMER: In this description contains affiliate links, which means that if you click on one of the product links, I'll receive a small commission. This helps support the channel and allows us to continue to make videos like this. All Content Responsibility lies with the Channel Producer. For Download, see The Author's channel. The content of this Post was transcribed from the Channel: https://www.youtube.com/watch?v=eHNHY70Hepk
Postagem Anterior Próxima Postagem