Excel Basic Training: Create your Personal Monthly Budget | Jan-Philipp Rötz | Skillshare
Drawer
Search

Playback Speed


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

Excel Basic Training: Create your Personal Monthly Budget

teacher avatar Jan-Philipp Rötz, Curious Engineer

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

    • 1.

      Welcome to the Class

      1:39

    • 2.

      Class Project: Real-life Example „Personal Monthly Budget“

      4:13

    • 3.

      Step 1: Interface of Excel

      3:19

    • 4.

      Step 2: Create Your Workbook

      2:24

    • 5.

      Step 3: Structure Your Workbook with Sheets

      2:59

    • 6.

      Step 4: Cells, Rows & Columns

      4:41

    • 7.

      Step 5: Create Your Content

      5:03

    • 8.

      Step 6: Format Your Content

      7:44

    • 9.

      Step 7: Formulas

      5:05

    • 10.

      Step 8: Sort & Filter

      2:47

    • 11.

      Step 9: Find & Replace

      4:23

    • 12.

      Step 10: Print Your Workbook to a PDF File

      3:17

    • 13.

      Summary and How to Move on

      2:07

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

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.

154

Students

2

Projects

About This Class

You will learn how to work with Excel while creating a Personal Monthly Budget workbook for yourself.  After taking this class you will be able to start using Excel, you will learn Excel basics and you will have a tool for your monthly financial budget planning. It’s a win-win situation for you. :-)

WHY YOU SHOULD TAKE THIS CLASS

Excel Skills are needed everywhere. At work many companies use Excel. So, if you want to be successful in your job, good Excel skills might help you.

This class is accompanied by a workbook file which you can download and use to practice the skills which are thought in each chapter. And which includes an example Personal Monthly Budget ready to use. 

As an Engineer, I am using Excel every day at work, and I have already created hundreds of workbooks. I will help you to focus on the relevant parts you need to know to work with this tool.

WHO THIS CLASS IS FOR

This class is for beginners who just started using Excel, for everybody how wants to get more familiar using the software and for those how wants to have a nice tool for their financial budget planning.

WHAT YOU’LL LEARN

This class has three Learning Goals, which are divided by several Learning Objectives.

1    Get inspired by a real-life example

  • Class Project: “Personal Monthly Budget”

2    Learn the essential basics to Excel

  • Interface of Excel
  • Create your Workbook
  • Structure with Sheets
  • Create, edit and modify Cells, Rows & Columns
  • Create your Content
  • Format your Content
  • Use Formulas
  • Sort & Filter
  • Find & Replace
  • Print to PDF

3    Have your own “Personal Monthly Budget” workbook

  • Create your own “Personal Monthly Budget”

WHAT YOU’LL NEED

Needed:

  • Microsoft Excel

Provided:

  • Workbook file to accompany the class and which includes a "Personal Monthly Budget” ready to use

Meet Your Teacher

Teacher Profile Image

Jan-Philipp Rötz

Curious Engineer

Teacher

Hi there, I'm Jan-Philipp!

If you want to learn more about me, scroll down. If you want to learn more with me, start here:

See full profile

Level: All Levels

Class Ratings

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

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. Welcome to the Class: So you want to learn XOR. Very good idea. Excellence used everywhere at work. Everybody uses excellent at home. Everybody use x or for their financial budget planning or don't you? Don't worry. I will show you a ten step approach to exit and we will create a Personal monthly budget for you. So it's a win-win situation for you. Hi, my name is Philip. I'm a German engineer. I like being productive. I am using x every day for many years now. And it really boost my productivity. And it's actually not that hard to learn. I like to share my knowledge with you to help you focus on the important things and leave away the irrelevant things that you do not need to know. This training is for beginners who just started using Excel. And for everybody who just wants to have a tool to track their financial budget every month. I have structured this training into three learning goals. The first one is, I would like to give you some inspiration so that you know what you can do with excellent. I will show you a real-life example, my personal monthly budget workbook that you can recreate a second. You will learn the essential basics. I will show you ten steps. You need to know the exit. And the last learning goal will be your own personal monthly budget workbook. You will create a workbook at the end that you can share with the community to get feedback or to show the others what you can do with excellent. So if you are as excited as me, let me show you our class project. My personal monthly budget. 2. Class Project: Real-life Example „Personal Monthly Budget“: Okay, in this chapter, I want to present to you our class project, the Personal monthly budget. If you follow all ten steps of this training, you will have a shareable personal monthly budget workbook yourself, which you might want to share with us in the project section below. I've created a work file for this training, which you can also download in the project section below with several tasks. At the end of each chapter, I will ask you to fulfill those tasks. Deep Mu understanding, and to help you practice the things that you just learned. So let's start. Okay, this is the person or monthly budget. As you can see here, there are three different rows. I will start at the end. You can see the detail rows consists of different tables. I have the salary table where you can see Jack earns 1,500 dollar and July 2000 dollar, and in total they earn 3,500 dollar. You have the other income table where you have 150 dollar income every month from whatever. And you have your expensive side. You have expenses for your housing which are in detail. The rent, the running cost, electricity or whatever comes to your mind, what you need to put in here in this little table. This sum up to a total. You have the same for food, loans, transportation, and the other tables. And all of these are let me go above. You can see here in this table. So the housing total appears again over here in this table. The same for the food. Total appears here in this table. And the same for the loans. Total appears here in this table. And all of these together sum up to your monthly expenses, which are $3,106.78. This total. You can then again see over here, total monthly expenses, the same for the earnings side. All your earnings sum up. You can see your total earnings over here. Now when you subtract the expenses from the total earnings, you have your balance, this one minus this one. And if the balance is positive, it's, it's quite good because then you have some money to spend each month. If it's negative, you may want to see if you want to lower your expenses somewhere. Okay. This is the Personal monthly budget. This workbook is also a work file for the whole class. As you can see here. This workbook has several sheets which are named according to the chapter. Each chapter, I will ask you to do some tasks which are written in this workbook. E.g. the interface of excellence. This is the first chapter which we just start. This has several tasks which I want you to fulfill. And when you have done, you can check them. And when you went through all those tasks, you can go to the next chapter. Okay? This was our class project, and we've already reached our first learning goal. You've got some inspiration. Let us check the learning objective. In the next chapters, you will learn the ten steps to create this workbook yourself and to learn the essential basics. The first step will be the interface of exit. But before we move on, I would like you to download the class project workbook. Right now. We're starting using it in the next chapter. Let's move on to step number one, the interface of exit. 3. Step 1: Interface of Excel: The first step on your way to excellence is to get to know the interface of the software. It is your tool which you are using to create something good. That is why you need to know how the software works in general. I will show you how the main window is organized and how our work book is structured. Let's go. This is the main window of excellent. All of these. It's on top where the ribbon. Here you have your spreadsheet and here you have your sheets. Let me start with the ribbon. This one here is the ribbon. The ribbon has different tabs, Home Page Layout formulas and so on. Where you can find important functions. This whole thing here is your workbook. I've written down here, Workbook. Workbook consists of different worksheets. All of these sheets you can find here. This is worksheet number one, worksheet number two, worksheet number three, and so on. You use worksheets to structure your workbook on a sheet. This one is a sheet. You can find cells, different cells. These cells have names. They are named after the column and the row they are. And this is e.g. the blue one is column M. You can see the M over here, and the orange one is rho 32. You can find that 32 over here. And this cell is p8. It's in column P. And in row eight. Here, you can see them. They're always highlighted like this. When you click in another cell, it's highlighting here. You can find the name of the cell. Over here. Names of the cells are important if you want to reference or if you want to use formulas. Another thing I wanted to show you is that you can change the appearance of office. You go to File, then you go to Options. Then you go to general. And then scroll down and you'll see office theme. And then you can change it to whatever you want, e.g. black and click, Okay. Now you have black office. I really prefer the white of a theme, but it's up to you what you choose. Let's have a look at our learning objectives again. Now you know the interface of Excel and you know how to use the software. The next step will be the creation of your own workbook. But before we move on, I would like you to work through the tasks in our class project workbook right now, if you have any question, feel free to post them in the discussions section below. Okay, you're done. Then let's move on. 4. Step 2: Create Your Workbook: This chapter, I will show you how to create a workbook file. This is the file you are working with and which you can see in the folder structure of your computer, Let's jump directly into exit. So if you want to create a workbook, you go to File and then you click on New, and then you click on blank workbook. Now you have a blank workbook created. If you want to save this workbook, you can click on this little disk. Or you go to File and then Save. Now you can choose if you want to save it on your OneDrive or if you want to save it on your computer. The advantage if you save it on OneDrive is that you have a version history. But today we want to save it on this PC. I click this PC, then we go to Documents over here. And then we choose the location where we want to save it. I want to save it on the desktop in my excellent folder. Give it a name, my workbook. And then click Save. Now it's saved. You can see it over here. It's called my workbook. And it states that it's saved. Very good. Now we can close this workbook. If you want to open the workbook again. We either open it from the folder. All we click on File Open. And then because we have saved it on this computer, will click on this PC. They will look for the folder over here. Click on desktop. Search your folder. There's my workbook. And I can open it. And we're done. Great. Now you know how to create safe and open a workbook file. We can check the learning objective. Next, I will show you how to structure workbook using sheets. Now it's your turn again. Fulfill the task of step two in our class project file. It will strengthen their understanding of what you'd just have learned. And whenever you're ready, move on to the next step. 5. Step 3: Structure Your Workbook with Sheets: Sometimes a workbook can become quite big and it will be necessary to structure it with multiple cheats. A good example is our class project workbook, which has multiple cheats. If I would have put all the content on one sheet, it would have been a mess to work with. So let me show you how to create and format sheets. Alright? So if you want to add a new sheet, you simply go to where you want to edit e.g. here. Click on the sheet. And then you go to this little plus over here. Click on it. And breakdown sheet number one was added after the sheet which we have selected before. We can rename our sheet by click, right-click, and then rename. And we can call it my sheet. If you want to move the sheet to another position, simply click on it and drag it over here. Or over here. You can click and drag it. And if you want to copy the sheet, right-click on it, Move or Copy, then you choose your position, e.g. I want to copy the sheet. Over here. You click, Create a Copy. Then. Okay. And now we have my sheet and my sheet number two. Since we just need one machine, we delete my sheet number two again, right-click. Delete. Yes, delete, and it's gone. You can also hide sheets. They are still there, but they will not appear in this row anymore. Right-click and then hide. Now it's gone, but it's still there. If you want to unhide it again, right-click on any sheet, unhide. Then you choose the sheet. You want my sheet and click. Okay. There is, again, you might have seen already that I have colored my sheets. This one is green, these are yellow and the last one is orange. And this one, the new sheet is white. I want to give it a new color. Right-click on it. Choose cap color, and then choose the color you want, e.g. red. Now you see this red. Now you have learned how to create setup and format sheets. Let's check the learning objective. Step number four will be the creation and modification of cells, rows and columns. If you already fulfilled the tasks and our class project workbook. And if you found the Hidden sheets, then you can move on. 6. Step 4: Cells, Rows & Columns: As we have learned in step number one, rows and columns consists of cells. Let me show you how to create and modify them. So as you have learned already, a sheet consists of several cells. If you want to insert a new cell somewhere, simply click on the cell, right-click and then choose Insert. Now you can choose how to insert it. If you choose shifts cells, right? All these cells which are already here will move one step to the right side. If your shoes shifts sales down, all the cells here will move one step down. Our choose shifts cells right? Now you can see the blue one is new. It automatically takes the formatting of the left cell, but you can choose it over here. Format same as left or format same as right. Now it's yellow. Or you can choose Clear Formatting. Now it's an empty, blank cell. And as you can see, all the other cells are moved one step to the right side. If you want to delete this cell again, simply right-click Delete. And now you have the same options. Shifts cells, left, shift cells up. But I want to use shifts cells left because then all these cells will go one step to the left again. Alright, now we have insert and delete it a cell. Now let's do the same for row. You can either select the position where you want to have a new row, right-click, Insert, and then you can choose entire row or cancer. This is how I always do it. You can select the entire row and here you can choose right-click, Insert. And now it will insert a new row. To the left of the row you have just selected. And it's the same for the formatting. Now you can see all these cells are blue because it automatically takes the formatting of the left side. You can format same as ride. All of these become yellow. Or you can clear formatting, then you can see it's just a blank row which we have insert. And if you want to delete this row again, we select the row. Then right-click and click Delete. Now the whole row is gone. If you want to change the dimension of a cell, you have to change the dimensions of the row and the column, e.g. if we wanted to change this cell, the dimension of this cell, you click on the side of the column, click and hold, and then you can drag it to the size you want. The same for the row. You click the side of the row and then you can drag it to the size you want. Now you can see the size of the cell changes, but also of all the other cells around. If you want to merge cells, you can click and drag to select as many cells you want. And then you go to the ribbon, to the Home tab. And then you click Merge and Center. And now we have just one cell left before there were six and now there is one cell left. Great. I really like those little colorful tables. Until now you have learned the interface of Excel. You have created your own workbook and you have structured it with sheets. And you have created and modified cells, rows and columns. Let's check the learning objective. Next, we will finally start with our personal monthly budget. Let us start with the creation of the content. But first, it is your turn again. You can do the task for step four now in our class project workbook. And if you are done, you can move on. 7. Step 5: Create Your Content: Now it's time to fill the cells with content to start creating our personal monthly budget. Let's go. So now we're starting to create our personal monthly budget. First, we need to start with the content. If you want to write in a cell, simply click it, and then start typing. Then you can hit Enter. Now you have written personal monthly budget in the cell B12. This will be our headline. So I want to merge these cells. Merge and center, so that the headline will be in the middle of our personal and monthly budget sheet. The next will be our total area. You can again select the cell, but you can also write over here in the formula bar and hit Enter. And it will appear in the cell. You can see if I select the cell, the content always appears here in the formula bar. The last way to write in a cell is that you'll double-click the cell. And then you can start writing. Hit Enter, and you're done. Now you can see the cell is a little bit smaller than the content. You have. The cell ends over here. If you want to change the dimension of the cell, you can, as we have learned, use the column selected and change the dimension. Or an easy way is that you make it smaller again, you can simply double-click the corner of the column. And then it will change automatically to the size of the biggest content in this column. We don't know how big our total monthly earnings will be. So we enter a question mark over here. We want to calculate all the things in chapter number seven with formulas. You can also copy cells. Click, right-click, and then click Copy. And then we can paste it to the cell we wish. Select the cell, right-click and then paste this one here. You have several options. Now you can simply paste. You can just use values. You can paste all the formulas. This is important if you copy a formula, e.g. if you do not want to copy the formula, but the values, you select value over here. But right now we don't have a formula, so we just pasted. Now it's written total monthly earnings, but we want to have total monthly expenses. We select the cell, we can select it over here in the formula bar are we double-click the cell. Then we simply delete earnings and write x. Penances. Enter. We do not know how big they will be. So question mark, if you want to undo something right now, I've written 123 here, but I do not want to have 123 in the cell. We select this little arrow here, undo. Then the last step will be gone. If we wanted to have it again, we select redo and 123 will be here again. But we want to have a question mark here. So I just started writing and the content disappears and will be overwritten. Now let me fast forward to complete our content for the Personal monthly budget was really fast because I already have created, of course, are result sheet, which is hidden. But you can unhide it if you want. And I've just copied all the content to here because it's a little bit faster. Right now. Hooray. We are halfway through our second learning goal. The content for our personal monthly budget is created. The next step is to format the content to improve its readability. Now you can start creating your own personal monthly budget. You can use our class project workbook, or you can use the one you have created in step number two. If you're done, move on. 8. Step 6: Format Your Content: Formatting of your content is a really important part. It guides your reader through your workbook and highlights the things that are more important than other things. And in my opinion, a good-looking workbook is really more fun to work with. So if you want to format your workbook now, you can change the fill of a cell by selecting the cell. And then you can go over here to this little bucket, color bucket. Then you select the color, and then you choose the color you want. Right now, we will choose this little, this light blue. Now you can see you'll sell is light blue. I want to have a background for our personal monthly budget, which is light blue. So I select all the cells from our personal and monthly budget. I click over here, click and hold, and then drag and highlight all the cells I want to have filled. Now, I can either click on this button to fill the color with the last color we've used. Or I can choose a new color, but I want to use the last color we have used. Now all of, all of the cells are blue. Now I want to have a border. I again, select all the cells. I want to have a border around. Then right-click Format Cells. Then you can choose border over here. Click. And now you can choose the style you want. I wanted to have a little bit thicker border in where you want to have it. I want to have it around or the cells. Then you click Okay. And now you can see we have a thick border around our cells. Now I want to change the font of our headline. I select the cell. Then I go to the font section here. I select the font. I want I want to have a real black. And I want to have it a little bit bigger, 18. And to have a little bit more space above and below our headline, I simply change the dimension of this row. Now I want to have a personal monthly budget headline in the middle of the cell. So the cell is still selected. You can change the alignment here. I want to have this alignment, it's middle aligned. So you can see Personal monthly budget is no middle of the line. You can also change the alignment from the text to the left of the center or to the right. But I want to have it in the middle, in the center. So it's in the middle and in the center. We've already created some numbers for the salary from Jack and Jill and also for our expenses. And obviously these numbers are dollars. So I want to change the format of this cell. The number format over here, from general to accounting number format. You simply click on this little dollar sign. You can also change another accounting number format wherever you are. And it automatically changes like this. These are also dollar, US dollar. You can also select several cells by click and drag. And if you want to select these cells to, you will simply click Control, hold Control. And now you can select those cells to again hold control all the time. Now you can release control and select the little dollar. Great. Now we have two over here. Okay, I will fast forward now. And format are the other things. You can also select multiple rows by select one row, then hold control and select the other row. And then you can change dimension of both rows at the same time. If you want to copy the style, if you've already created a table like this one. And if you want to copy this style, you'll simply select what you want to copy. E.g. I want to copy the style of this heading. Then click Format Painter over here. And then you click where you want to copy it to. Over here. This one, I want to have the same style as this row. So I select the row click Format Painter, and then I select this row. Here. I want to have the same style as this one. So I select this row, click Format Painter. And then I'll select this row. And now they look the same. We can also do this. Of course, for this one. Now copy the format over here. And as you can see, everything changes, not just the background but all the style. But we want to change this one to read because these are not our earnings, these are our expenses. And we're done. That looks a lot better, doesn't it? You can see at a glance what is really important, okay? Now you can format your content and the cells around them to make them look pretty. Let's check the learning objective. Next. We will make our lives easier by connecting the content on our sheet using formulas. But first, you can be creative now. Now you can format your personal monthly budget to make it really personnel. You can choose the colors you want. You can format the borders as you like. If you want to use the things that I just showed you, you can just unhide the results sheet of this step. Let's move on to the next step. 9. Step 7: Formulas: Let us talk about formulas. Formulas can make your life a lot easier, excellent capable of doing the most difficult mathematical operations. But don't worry, we will not use lab right now. I will show you how to calculate simple mathematical things using formulas. Let's go. So as I already told you, we want to get rid of those question marks by calculating them. Let's start at the bottom with the details tables. We will start with our little salary table. Select the cell, and then start typing formulas. Always start with an equal sign. So we type equal. And we want to add this one to this one, so we select the first cell. Now you can see d3 is written here, and then we type plus, and then we select the second cell. Now we have d 30 plus D3 E1 and hit Enter 3,500. And as you can see, the number format of this cell automatically changes to the number format of the other cells. So we do not have to change this one. Now I want the total of the salary table to appear over here. We do not need a formula here, but we want to have a reference. So we again start typing equals two and then select this cell and then hit Enter. Now this cell equals to the cell. So if we change anything here, e.g. Jack gods a pay raise, 1,700. Everything adapts 3,700 and over here, 3,700. Really nice. Let me change this one again. Okay. There's also another way to calculate the sum of something. Select the sale, right? Equal. And then you can type the name of the function you want to have. This one is Some. Alright. There you go. Then you hit the tab button and you can select the area. You want to have the sum of. We want to have the sum of this area. Click and hold and drag, and then hit Enter. Now, Excel automatically calculates the sum of h 32, H3N2. And as you can see in this cell that has written the result, $1.44. And in the formula bar, you can see the actual formula which is written in the cell. This is what I've meant with pasting the values or pasting the formula. In step number five, if you want to paste the formula, you will paste this one. If you want to paste the value, you will paste this one. Okay, let me fast forward from here to finish all the formulas. So at the end, let us create our balance equals our total earnings minus our total monthly expenses. Enter a credit. Now you can see our balance is 543.20, $0.02. If this is too much detail for you, you can change the number of decimals here by going to your number format. And then increase or decrease the decimals. Like this. I think it's sufficient to say your balance is 543 dollar. I always like how the content of the cells adapt when you change. Just one number. Beautiful. So we are done with our personal monthly budget. You can start using it right now. So now we know how to connect the content of our cells using formulas. Let's check that box. The next step will be to sort and filter the little tables you have just created. But first, as always, do the tasks for step number six right now. And when you're done, move on to step number seven. 10. Step 8: Sort & Filter: If you've tables grow over time, it becomes very hard to find specific content or specific roles. Or you want to sort the rows in a specific order. Excellent Hep-C here with sort and filter. Let me show you how to do it. If you want to sort a table, you have to select what you want to have sorted, e.g. this one here with the amounts. Then you go over here to sort and filter. Click. And now you can select sort from a to Z. You can see everything changes now from a to Z. Or you can change sore from that to a. That's the other way around. And everything you have selected. Now, salts, we have selected this row first. That is why we can sort according to the names. If we select this row first and then go over here, we can sort the amounts again, sort and filter. And now you can see it changes to sort smallest to largest. Click. Now you can see it or largest to smallest. And now you can see what your most expensive spending is every month. Now if you want to filter and find something specific, you have to select the whole table. And then you go to Sort and Filter again. But now you click on Filter. And you can see this little box appears. You can click this box and you can filter after what you want. E.g. I just want to see de-select Select all. I just want to see my insurance spendings. Okay? Now insurance left and the all the other ones are gone. If I want to see the other ones again, click on this little button, Select All. And now I can see everything again. By the way, filtering works a lot better if you define new area ASM table, because then you can filter after several things. But that's a topic for another training. So now you know how to sort and filter. Next, I will show you how to find and replace things. Now it's your turn again. Solve the tasks for Step eight on our class project workbook. If you are done, you can move on. 11. Step 9: Find & Replace: When you are having a big workbook with several sheets, it might be difficult to find something. Or sometimes you need to replace something with something else, e.g. you need to replace a dot by a comma and they need to do this several times on your sheet. If you do not want to do this one by one, exhale helps you would find and replace. Let me show you how to do this. If you want to find something, you can select, Find, and Replace over here. Then you click on Find. Then you have to define what you want to find. E.g. I want to find earnings. Now you can click on Find Next. So it finds the next earnings. You can see this cell was selected because there's written earnings inside. If I click on Find Next, it jumps to the next cell where it finds earnings, monthly earnings. And if you click on Find Next, it jumps to the next. You can see it jumps back because they are just two times earnings on this sheet. We're just looking for something on this sheet. You can also change this to the workbook and then you will look for earnings and all of this workbook, this includes all of the sheets you can see here. If you click on Find all, you have a list of all the places where Excel has find earnings. It's in cell C5 and C6. If you click on it, extra will directly jump to the cell. This is how you find things. If you want to replace something, let me close this one again. You go also to find and select over here. But you'll select Replace. And now we can replace something. Let me define what I want to look for housing. And I want this one to be replaced with rent. Now I can click on Find Next. Here is housing written. And now I can click on Replace. You can see housing was replaced by rent. Directly jumps to the next place where it finds housing. I can click Replace, or I can click Find Next. If I do not want to have this one replaced, I click Replace. Now it does not jump to the next place because this was the last cell where housing was written in. Click on Find Next. Extra code will find another place. Okay, let me redo this. By now. I want to look for rent and replace it by housing. I can also do this one by one again. Or I can click on Replace All and excellent automatically replaces everywhere. Rent with housing. Three replacements were made. Now we have changed it three times because excel also has changed this housing over here or this rand with housing. That was a mistake. I do not want to have housing here. I want to have rent. So if you click Replace, All, excellent, We'll really replace it everywhere. It finds it. Very good. Now you know how to find and replace things. Let's check that box. Next, I will show you the last step. We will print the file to PDF, but first, do the tasks in our class project workbook. For step number nine. Find all the savings. There are more than you actually see. 12. Step 10: Print Your Workbook to a PDF File: Okay, Our last step is to print our workbook to a PDF file. This way you make it sharable and you prevent that somebody accidentally changes something. Let me show you how to print our workbook to a PDF file. If you want to print our personal monthly budget to a PDF file, you can select the area you want to have printed. Because we do not want to print our whole sheet. We just select the area we want to have printed. Then we go to File. And then you can either go to Print and select Microsoft print to PDF if you have this one. Or I prefer to go to Export. And then create PDF file, and then click on Create PDF. Now you have to select where you want to export it to. This is already the right folder where I want to export it to. But I want to just export the selection we've made. So I click on Options and publish just the selection. Click Okay, and then click on publish. If you open your PDF file now, you can see something happened. The area which we have selected is printed to a PDF file, but somehow not on one page. So we need to change this in our print settings. Let me show you by going back to xo, the areas still selected which we want to print. We go to File, then we go to Print, and then we have to change the settings. We change to print selection. And then we go to scaling and fit sheet on one page. This looks good. Now let us export it again. Export PDF file. Now we have to change the options again to publish just our selection. Okay. Then publish. And I want to replace the PDF file which we have created before. Yes. Or now you see it's everything on one page. Now you can share this with everyone you want. Looking good. Okay? Now you can share what you have created. Maybe it's already a good time to take a screenshot of what you have done and share it below in the projects and resources section. Then you can show everybody how you personally monthly budget looks like. But bear in mind not to share your actual expenses and income. Just make some numbers up. And we have finally checked our last learning objective. And we have reached our second learning goal. Now you know the essential basic, very good. Let me summarize what we have done in the last chapter. 13. Summary and How to Move on: Okay. Before we start to summarize, I would like to ask you for a favor. Could you please give me a review? It would be great if you could let me know if I'm on the right track and help me getting better by giving me feedback. Thank you very much. Okay, Let's summarize. In the first part, I showed you our class project to give you some inspiration. What you can do with excellent. In the second part, I showed you a step-by-step approach of how you can learn the essentials. First, we started with the interface so that you've got to know the tool you are working. Then we have created a workbook and structured it with seeds. Next, we have learned how to work with cells, rows and columns, and how to create content in them. To make our work look more readable, we have formatted the content afterwards to our personal needs. And in the end, we have connected the content with formulas to make our life easier. Now we have had our final personal monthly budget. But to work with it, I've also showed you how to sort and filter things and how to find and replace content. In the end, we printed our workbook to PDF to make it sharable. I don't know if you already realized. But the third learning goal, we will not reach together. Now it's your time to take action. Create a Personal monthly budget yourself, and share it with the community. But be sure not to use your real earnings and extensive. Just make some numbers up. And again, please review this class. If you liked this class, recommended to your friends. My next course will be about tables and conditional formatting. Base, what you have just learned. So if you want to further improve your knowledge, you should definitely check out my other courses too, and consider following me to stay up-to-date. Thanks for joining and see you next time.