Personal Productivity Using Microsoft Excel - Plan Your Life | Chris B. | Skillshare

Personal Productivity Using Microsoft Excel - Plan Your Life

Chris B., Instructor, MBA and CFO

Personal Productivity Using Microsoft Excel - Plan Your Life

Chris B., Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
14 Lessons (1h 32m)
    • 1. Course Introduction

      1:28
    • 2. Instructor Introduction

      1:30
    • 3. Excel Basics

      10:57
    • 4. Personal Budget

      11:32
    • 5. Password List

      7:32
    • 6. Weight Tracking

      5:16
    • 7. Travel Planning

      9:24
    • 8. Home Inventory

      8:28
    • 9. Credit Cards

      6:18
    • 10. Prior Addresses

      5:19
    • 11. Gift List

      4:34
    • 12. Savings Goals

      10:36
    • 13. Life Goals

      6:41
    • 14. Course Conclusion

      1:56
  • --
  • 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.

259

Students

--

Projects

About This Class

Do You Feel Like Your Life Is More Chaotic Than It Should Be?

Do You Often Hear About How Powerful Excel Is But Have No Idea How To Use It?

Are You Pretty Good At Focusing And Staying On Task But Need That Extra Tool To Really Be Great?

Are You Someone Who Seeks Out New and Better Ways To Accomplish Tasks?

If You Answered "Yes" To Any Of The Above, Look No Further.  This Is The Course For You!

Start today and join the 100,000+ successful students I have taught as a Top Rated instructor!

Three reasons to TAKE THIS COURSE right now:

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads

  2. You can ask me questions and see me respond to every single one of them thoroughly! 

  3. You will are being taught by a professional with a proven track record of success!

  4. Bonus reason: Udemy has a 30 day 100% money back guarantee if for some reason you don't enjoy the course!

Recent Review:

Chris R. says "Great course, I felt pretty lost honestly before this, and knowing I needed to change is what brought me to this course.  By using Excel (which is super easy fyi) I was able to organize my thoughts, tasks, budget and more.  For once I finally feel in control of my life instead of drifting. Such a great tool, and Chris was just the guy to teach me how to do it. He may be an accountant but he'd make an amazing life coach also!"

Why You Should Take This Course:

Gain control of your life with these simple to use ideas for using Excel in your life.  Learn how to create a budget, a travel plan, savings goals and much more with this course.  At the end of the course you can also download the Excel workbook we build in the course to use for your own!

Become a pro at Excel basics AND managing your life all in this course!

What We Do In The Course:  

  • Create a personal budget

  • Create a travel plan and budget

  • Set up a savings goal and learn what it takes to reach it

  • Make lists of all kinds to make your life simple

  • And Much More!!

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  

***JOIN NOW AND LEARN HOW TO USE EXCEL TO GAIN PERSONAL PRODUCTIVITY! ***

About The Instructor

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, financial statements, personal budgeting and personal finance.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

Meet Your Teacher

Teacher Profile Image

Chris B.

Instructor, MBA and CFO

Teacher

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.

Your creative journey starts here.

  • Unlimited access to every class
  • Supportive online creative community
  • Learn offline with Skillshare’s app

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.

phone

Transcripts

1. Course Introduction: Hi, everyone. Welcome to the course using Excel to manage your life. Personal productivity. My name is Chris Benjamin and I'll be your instructor. I'm so glad you signed up for this course. It's a really useful tool that we build. So just a reminder. Before we talk about it at the end of the course, you can download the exact workbook that we build it through the entire course. So this in course will pretty much all be in excel. You'll see exactly what I'm doing on the screen after this and my other instructor intro video we're gonna go through. We're gonna build 10 different worksheets that will. Each of them will make you a better person. Make your life that much more efficient. Hopefully give me a lot of other ideas on other workbooks that you could create just a streamline your life. So, as an example, we're gonna create right off the bat a personal budget for one month. That is something you could take and extrapolate out for the entire year. And I show you and honestly, within about 15 minutes we have an entire personal budget created for your month. You can see the ins and outs give you ideas on how much you could maybe be saving or other ways it could be spending. Your money will create things like a travel planner. Not just, you know, where would I like to go? But when should I go? How much do I need to say for that? What am I going to spend on each individual type of? Ah, category of expense. When I go play for that, we're gonna look at saving schools. We're gonna look at other ways to track list useful things, gift ideas for family and friends. Lots more as well, guys. So I'm really glad you sign up for the course. Let's go ahead and get started on making your life more productive using my Microsoft itself. 2. Instructor Introduction: All right, everyone. So before we get started with the course, I just want to give you a brief introduction to myself. My name is Chris Benjamin. I work as a chief financial officer, more of a consultant. I got MBA from the University of Washington. And most important, I'm gonna be your instructor on this course today. So over my entire career, in or my entire life, I've been using Microsoft Excel for probably 25 years. Now it it's a very powerful tool. And we're going to use some of that power of Microsoft Excel to make your life better in this course. So definitely, over the course of my career, I've figured out different ways to use it. And as I mentioned in the introduction, I built my own workbook pretty much exactly what we're gonna build today. In the course that I use every day, I have things like a personal budget password list, places I want to travel, savings, goal calculator and much more. So I'm gonna be teaching all that I believe me. This is a really powerful tool. So as long as you're willing to pop in there, you know, look at your file and update. It occasionally definitely will help you out in life. A few things as you're taking the course. If you have any questions, definitely send me a message through the course website. Happy they answer them for you. At the end of the course of the course conclusion video, you can download the actual file that we build in Excel, so definitely check that out. And lastly, I encourage you to look at my other courses. If you go to my profile, see all the other courses I have over 40 courses on different things. Counting finance, entrepreneurship, personal budgeting where I get way more in depth than we do in this course, etcetera. So that's my words of advice for you. Let's go ahead and get started on building this personal productivity workbook. 3. Excel Basics: Alright, everybody. So before we get in the course, that's want to teach you a few sort of basic functions and sort of uses an excel. So nothing specific to the individual items were gonna get into just more things like formatting and centering and just how to use excel. Essentially. So if you're familiar with Excel, you know the sort of basic things like how to create a new workbook, how to save at how toe formats, some of the data. Basically, if you're comfortable with this home tab, you pretty much know everything you need to know for this course, so you can go ahead and skip this, have lecture, but if you're not or you want to refresher than stick around and let's get to it. So, um so, first of all, I've created a new workbook. This will be the one that we working for the entire course. And as I mentioned in the description, it's available for you to download. So as we go through, of course, we'll build out individual tabs for everything that we're creating. Um, so I've gone ahead and saved it already. Personal product to the excel dot XLs s so would encourage you to do the same thing. Created new workbook. Save it somewhere right away. Give it a name. Unless, of course, you want to just sort of follow on the course and then download the one that I'm actually building. That's perfectly fine as well. But again, this is just sort of general sort of best best practices and excel, if you will. So any time you creating a workbook, definitely save it off first thing. Ah, so if you're not familiar with Excel, it's very It's a modular type of its spreadsheet, essentially so that each of these is called a cell, and each cell has a reference. Each column is labeled with a letter, so a B C D. Each row is number 12345 and goes up infinitely. Actually think it stops like 11,000 or somewhere around there. But, um, so any given cell has a cross reference. Then this one is E for a C eight, etcetera, and you'll notice as I click in any given cell Thea Row in the column. They highlight kind of see how D is kind of darker there in seventh, kind of darker so say you're way over here and you want to know what this was easy. It is, 0 17 because that's what's highlighted. Um, so we can type anything in these sales letters, numbers, symbols such as Let's just type. Let's just type some simple things like, say, we're gonna make a list of ah, name address on the phone number and that who knows what else. Maybe they're Brent amounts. Maybe you're keeping a list of people that pay rent every month. You owned some properties. This is again. It's just a examples. Multiple things you can do in Excel as we'll be learning. Um, Stephen type in any given cell, you'll notice you can type. Just start typing wherever, or you can type up here. This is called the Formula Bar. Typically, it's where you'd write the formulas as well, but you can certainly just type is well. But of course, just click in a cell and start typing. It'll, uh, it will take it. One thing start unrelated to that. Just while I think of it, we're gonna create multiple sheets down here, so I'm gonna create a second sheet just to show you what that looks like. she too. So I think this is almost like a book. And these air chapters, if you will, each sheet is independent of the other ones. Anything I type here, just put something really quick is on this sheet. If we back to sheet one, it still has the original information we typed. Um, I'm just gonna delete this now we can rename sheet, so and we will be actually, during the course will assure you that now, So this 1 may be will call, um, budget. That's actually going to be one of the first things we build. So budget. And then the second thing we might do is a password list. So I'm just gonna password list best practices. Keep these kind of short. You don't need the type of big, long name. Um, So for example, in this course, heavily, we do 10 different sheets. So by the end of it, of course, this is gonna be pretty full now, there isn't necessarily limit on how many sheets you could hurt. Tad collies, sometimes of colleagues have. Sometimes I call them sheets. Same thing. There's a necessarily limit. But when you get over here, then they'll start sort of rotating and you kind of vote We'll see them all at once. Doesn't mean they're not there. It's just a little bit easier sometimes toe, keep them, keep them brief, and, uh, you'll see as well during the course we're gonna put like headers. Appears to be able to see what each one is as we click on it. But, you know, password list budget, and then as we go through the course will create the other ones for formatting is going to use a four man business. So pretty much everything like I said, is gonna be on this tab that we're gonna be using Nothing complex. Um, let's say let's just start on the left and move across and kind of go through a few things . Um, the main things here will be copy and pasting to say I wanted to copy. Um, all of this. So if you click, if you left, click on any South and then hold it in. So hold it down, Um, and then rotate your mouths. You'll highlight stuff. Unless I'm just rolling my mouse around here as soon as I let go. And actually, I'm gonna do it just on these, then that's highlighted. I can then copy these. So this is open. Sorry, this is copy right here. And then I see you'll see the little dot it sort of line goes around. That means that's been copied and go anywhere else to say, I was gonna put down here and you can hit paste and it'll paste. Um, I'll just show you this time. I don't know that we're necessarily going to use it. There's other ways. 60 Paste is not even an option right now because we don't have been copied right now. The clipboard. We already pasted it. Let's copy this again. You'll see paste highlights anywhere you see a little drop down arrow. That means there's more options. So this is kind of the main option. You can just paste it. But if we club put this down, there's lots of different ways we can paste. We can paste just straight paste. You can paste formulas to say there's a bunch of formulas, and here we could copy just the formulas and not the formatting. Um, these we wanted me and into, um because, honestly, the woman's would typically use their paste paste formulas we're paste values. So, um, we won't necessarily that here, but so say Say I had bowled at all of this. So let's speaking of Let's go to the next sort of box. This will bold italics and underline. Bold tends to be the one that we use the most. If anything, we use it for, like, headers and whatnot. Let's just boldness. And then just to show you what I meant about the copy paste thing to say, we copy it. We come over here and we want to paste it. But we don't want to paste the format. We just want the values. Um, we can do this and you'll see it's already sort of pretty pasted it, showing us what it would look like. So if I just paste, it's gonna taste exactly what I copied. If I paste it without the formatting, um, were essentially just values, then it doesn't include any formatting we did to it. Um, so we talked about bold. It's a simple as highlight what you want. A bold. You could highlight just one cell hit bowl that would just do that same thing exactly with italics. If you see that, that's cell right here. Um, again, there's different options in a double underline, etcetera. You change the font as well. We typically won't change the font during our spreadsheet. Think that mostly might make something bigger, like, say, head or something? Um, and it's a simple as again, we could click here and drop down the list of fonts and there's quite a few. Or we could drop down a list of different sizes for the funds so we could make something bigger. Um, these one might use its essentially filling so you can either change the font color, which is a with the little color and simple has dropped on the box. Choose a different color when they see Now it's orange. You can also fill the entire cell. So, um, dropped on this and pick it colored picked like I don't know, like blue. And there you go. So lots of ways toe sort of do that, and I tend to do that on header rows. So for things like our budget, we create a real, simple budget. We might, you know, put a color on it or a total off. To do that on totals may be bold it and give it a little bit of shading just to make it stand out. We can change the alignment of cells, so that's what this next area is primarily will touch these three. This is the vertical alignment and this the horizontal alignment So we might center. Things would be, honestly, the main thing that we do. So, um, what it did just They're just Sometimes I do things out of habit and don't even think about showing people you could make. Obviously, columns and rows bigger, smaller. The way you do that, it's just position your mouse right over that break in between to click and holds the left click again and hold and then move your mouse and you can resize. If you double click on any break, it'll automatically resize to fit the data that's in there. So say that was a really long word. It would have stayed really big. That's a simple is that we can in dent and whatnot, we probably won't Let's just all to show what it looks like. So say we had a main name and then we wanted to indemnities. We could do one of these in the civil arrow to the right, and it just moves it over a little bit. Um, wrap, text emerge center we won't use. I'm not gonna want to throw too much at you if you're not that we don't need, um this is different ways of formatting the cells and what it is. So So these have just been taxed, so it's no big deal. But say, um, rent is gonna be a dollar amounts to say it's $500 so we type in 500. Just shows as 500. Well, here we can do a few things, something we can make it a dollar sign. Perfect. Say, we want to get rid of those decimal points. We don't need them. Um, these two right here increase and decrease the decimal point. So if I click on this, twice decreased it. And one thing I didn't mention my hopefully you're picking up on this. Whatever we do up here only applies to the cells that we have highlighted. So when I did the dollar something, it only applied to the cell, cause that's all I had highlighted. Um, se I knew I was gonna have numbers all the ways across even if you don't have data in there yet, you could highlight them. Hit the dollar sign, do this. And then even if I type the number now say 400 it's automatically format because these air already formatted just from what we did, um, we won't go into conditional formatting. This we don't really use. Um the only other two and the only other main things are uncertain delete. I mean, there's actually some keyboard shortcuts for those, but I'll tell you what they are. So say we had whatever list and we decided we wanted, you know, insert of row here. Um, if you click on any, you know, column or row like sort of maine the number it'll highlight that entire row. You can go over to insert insert cells or insert rose. They'll doubles work the same, and it just moves everything down in certain entire row right here. Um, if we just do so, insert cells when we have everything, copy is gonna move everything down. Anyways, if we were here and we just went in search Ah, cell. It's gonna ask us. Do you want us to move everything down or to the right um, we would sit down and you see, moved everything down. I'm same thing for delete works exact same way delete cells. Delete Rose. So I think that's it, guys. I mean, that's a nice, just sort of basic, you know, just so you know, when we were flying around through excel, you know, we're not doing anything to to crazier elaborate, um, no big formulas. We'll have some formulas on a few of our A list, but I'll just explain those at the time, um, in each of those lessons. So that's it. This video Zaria to 11 minutes. So let's call it quits and let's get started on the course. 4. Personal Budget: Oh, right, everyone. So our first lesson here, we're gonna learn to create a personal budget. Now, um, we're still be do a very simple budget. This condemn, flee, become a lot bigger project. But I want to give you sort of the nuts and bolts of how you would do this in excel give you the ideas, and then you can certainly take it expanded from their side Note. If you have an interest actually, a full course on personal budging where we build sort of a full blown 12 month budget. Definitely check that out. If you look at my other courses, um, and then is while you can download that template as well after that course and use it as room, but nonetheless, so for this one, um, so we already have our personal productivity. Excel Workbook, if you haven't already, if you're following along and you're actually gonna be doing this, um, yourself, I'd encourage you to save your workbook, give it a name. That name works perfectly well and, um, as well. So we're going to creating individual sheets for each of our sort. A little projects that we're doing here. So this 1st 1 will be our budget. So I'm just gonna name this one budget. And again, if you're not familiar, it is double click on any sheet. Her tab name. He can then rename it. Okay, so what do we need for budget? And again, we're doing a very simplistic one here. And I'm not gonna be, um, kind explaining every single little thing I do. I'm assuming you kind of know one excel, you know, some basics. Or if you watch the Excel Basics lesson before in the introductory section, that will definitely sort of teach you some of the things you need to know. So, essentially, what we would need is a hetero, and then we would, you know, with, say, the months, every doing a budget for months. So say it was gonna be for January. This is type the word January. Um, we're gonna have incoming sources of monies like your job and what nots. Let's just put our income. And then I'm gonna leave a few spaces, and then we go down and say expenses. And then I was still from there, we can always manipulate, move stuff. That's why I don't mind too much. Just sort of leave some space is we don't need to know exactly how many I know that I want to put in a few them. Okay, so I always like to leave. So we're going to a couple things first of all, so let's assume let's type a few expenses and I'll show you some re sizing. So say your income is our main job. Say we, um whatever it was called job come whatever your job might be, you know where your weekly income and you might want to put, say, job 15th and Job 30 s if you get paid twice a month, for example, so we'll break it out, then maybe you sell stuff on eBay. Just a guess, Source. Whatever other sources do you have, um, why not put 1/4 1 in? Let's just insert, um, let's say you, um I mean, if you sell stuff on eBay, maybe also sell on Amazon or I'm even thinking, maybe have a one time thing in January. Maybe you're getting your tax refund. So it's just a tax refund, and you want to include that in here from incoming money. Now you can tell array. This list is getting a little jumbled, you know, like January's over here. These are over here and comes over here. Let's start re sizing some of these columns really quick. So we're gonna use our tool. If remembering you hold between the two columns, click and hold, you can resize. So I'm gonna resize this one small. So you see what that did now see its income and these air nicely under it. Um, now, these air kind of too long. So if remember also, I tell you the trip if you double click on any cell, it'll resize it just to the biggest text in any of the cells on that list. I kind of want to give it a bit more space just cause for one, I think some of our expenses or end up being longer and I just like toe give this a bit of space. Let's do feel their things just before we get too too far I like I like centering that. The titles, guys, that's just me. Like centering that. Like bolding, um, most gonna bold income and expenses to see already. This is just cleaner looking that it was, you know, a few minutes ago. I'm gonna make this one just slightly wider just cause I think it might end up being slightly wider. You hit save. Only because I like to save as I'm going now for expenses. Obviously have to list out what you need. Let's go with some simple ones. Rent, um, spending money, food, gas, maybe pet care. You might want to group these. So then So maybe after sort of actually listing a pet care lets this kind of more like living type stuff, right? Then maybe you have your utility see of your power bill, your cell phone, your cable, Internet, then maybe put in a space and maybe you want to speak now put in the, you know, pet care. Um, what else? Travel. Maybe you liked, you know, budget for travel every month. Um, let's go with one more. Um, whatever. It may be sports events. Maybe you like to go watch sports events. So let's go ahead and write the word total here. And let's put it in that sort of offset sell just because we know it's going to be, you know, sort of the total Also gonna boldness. And if you hit control or I should say, hold down control and press B that will bold something. Um, I'm also gonna put in some underlines here. I like toe. I come from an accounting background. So if you drop down here, your cell formatting boxer, the borders like the top in double bottom and you'll see what that looks like. Just a nice That's like the total then. So one other thing you might notice here is we scrolled on our list. We don't see January anymore. And maybe we don't care because we only have one month. But, you know, I hope you're starting to get the idea you could do February, March, April, May, June. You could have this all the way across and then say you're down here and your here. You're not gonna exactly what month it is. I mean, sure you can. You know, Jamie Fair in March, April May. Okay, that's May, but why not just set it so that we see the top row always sort of the top two the way we do that, Um, if we position our mouths in whatever cell has the crossroads of where we want to freeze. So we wanna we always want to see these top two rows, and we always want to see the stuff on the left. Now, we have a lot empty space over here. So actually, before we go any further, assistant leave. These two really is. There's no need for them. Perfect. Um and honestly, there's not really a need for this top road now. Well, actually, you know what there is. I'm gonna put in a header here, call it personal budget, do a few things here. I'm gonna bold it, going to make a bigger just what stands out. And we're gonna do this for each bar tab. So it's clear what? That WAAS. So we want to freeze everything above this and everything toe left of this. So if we scroll across, that will stay there. If we scroll down, January will stay there. Position your cursor. We want a free things. Um, we are gonna venture off our home tab. I promise that we probably wouldn't much, But in this case, we need to And where we go on sometimes I have to look for it. Here it is. It's under view. It's under view. You'll see something called freeze panes are sorry. 222 frieze pains. We click on freeze panes. You notice that light gray line right there. So if we scroll down now, everything is frozen. If we scroll to the right, the leftist frozen. All right, guys, um, that's so other than putting in some numbers, here's what we're gonna do. Um, we need to put a total here. And first things first. We need a no. Only the total income. Let's insert a row here. Told you we went. Wait. Juice mixture Here. Um, is this gonna total income? I'm actually going to leave it in here. Total income. I'm gonna bold it, though. And I'm gonna put that underlying we're gonna do just of single topping. Let's see. You know what? There's no some single top and bottom he can after to them individually. So first will do bottom. Then we'll do top. There we go. And we're gonna do the same for expenses. And then what will do at the bottom is do a total, um, uncynical is total us do this total net budget. Whereas this will just be total expenses. The same thing we're gonna hit control be and bold it. We're gonna put our borders on it. Perfect. So without any numbers in here told me zero. But let's put some formulas in here. You know, I'm gonna show you the some formula space. We just need some and the subtract formulas all we're gonna be using. So, um equals and we have type it out. And this is where you could just copy what I'm doing. Type the word some, which is set to add up all the numbers. Put a open bracket now using your mouse click. So we want to some these four, right, click and hold. And just highlight those cells. Close your bracket. And there you go. Um, same thing here. So it's practice that again we're gonna add our expenses equals some. And you think of either direction up or down. We want some of that, Inka. Now our total net budget. What will that be? Well, that will be our income less our expenses. So this one is very simple. We have the equal sign since it's just two cells. We're gonna do this. We're gonna go this self select it hit the minus. Sign this cell, the C eight minus c 24 0 So before we put in numbers in, we already know this is gonna be dollars. So let's just go ahead and format this with dollars. Um, I'm not a fan of, like, the decimal points when it comes to budgeting, just kind of, you know, without the decimals works, I'm gonna move them into. So now, as we type things, let's say we bring in 2500 here. 2500 here. EBay. We make 300 a month, and we're expecting a $500 tax return. All right, so in January, we are gonna have in 5800. Let's put our rent. All right. Say we pay 1100 rent. We spend roughly 600 on whatever that is dining out. Um, you know, shopping on Amazon, buying household supplies, whatever you want to categorize us spending foods to say you break out your grocery budget . Maybe you spend 300 bucks a month in groceries has been 200 gas power bills. 100 Your cell phones. 1 20 cable 80 Internet. 80 pet care. Maybe spend 100. And that clues buying pet food or going to the vet. Um, and and maybe these categories are more like savings. Things like, if you don't spend the 100 you put it aside for the next time the same thing. But travel, maybe don't actually travel every month. You just put it aside. Um, let's say 1 50 and then sports events say you spend 100 bucks on sports events you go to, like, one or two games. All right, so we have We didn't bowl this one, I notice. So we have total income of 5800. Every month we spend 29. That leaves us with 28. So even with these savings, we saw 2800. That's perfect. That's essentially it for budget guys. I mean, you can obviously do a lot with this. Then you can go. OK, well, maybe I'm gonna spend more on travel. I'm gonna make this 400 a month, and I'm gonna say it spent 200 on that. Or maybe you add in other categories, like savings, and you just say, hey, maybe always want this to be zero, you say Okay, we're gonna dump the rest into saving. So however you want to manage that, um you can see how quick that was in 11 minutes, Lee made ourselves a nice little personal budget. So, like I said, um, certainly feel free to forecast this out a year. I can tell you, just from my own personal life, this is exactly what I do. I have a personal budget with rolling 12 months, just room continually, sort of forecasting. You know what my expenses will be seeing where I'll be at. So it's definitely a useful tool. And like I mentioned, check out my other course on building your own personal budget. If you want to see more, we get a bit more into and make it a little bit more elaborate. We do do the 12 months. That's that trap. I'm talking a little bit more about planning in that core. So that is it, guys, for this lesson, 5. Password List: all right. Every once. The next thing we're gonna do is a password list. Now, this was not gonna be for everybody, because a lot of people you know, if you're sensitive about your data and definitely this is risky. But essentially, what it would be is a list of websites and then your user name and password, Obviously not something you want to get out. So, um, so this is one. Definitely don't keep it. If you're at all worried about your data, Um, definitely. You want to make sure you have good sort of file security, and I'm gonna show you one or two things here in a second related to that. But I'm just saying, you know, up front, if this isn't really your cup of tea could certainly skip this this lesson. Um, I'll say personally. I mean, I've been keeping password list in Excel for over 10 years, never a problem. But then again, I make sure that my files air saved locally. I don't have it anywhere else where somebody could, you know, access that I keep it fairly hidden as well. Where I keep this file, um, and then the other thing, which I'm gonna show you how to do is to password protect this entire workbook. So, um, let's look at that now. So when you so we already saved our workbook and we gave her name. So let's do protect workbook. So encrypt with password. That's what we want to do. So basically, let's Yeah, let's type of passwords. So anyone who wants to open this file once we close it needs a password to open it. So I'm gonna give this a password for now. And I'm actually gonna remove it when I upload this file for you guys to download. But certainly if you did use the password list thing, I would re put a password on this. So But just to show you so give it a password. I'm just gonna give the password. Um, how about Excel Excel List? How about that? Just something simple. It's gonna ask me to re type it, and that's it. So, um, if we close this now, we hit save, so I'll show you what that looks like. If we were to, then let me find just two seconds. Bear with me. Ah, OK. Scroll this down here. So I have multiple screens. That's why I was working off screen. Um, so let's tap back to here, so I'm gonna close this. Okay, So here's the file. This is where I haven't saved. We need a double. Click it, open it, and you should see in a second. But it's on my other screen. Let me drag it down and a pop up with this. So we said it some excel list, and sure enough, unfortunately, opened on my other screen. But there it is. The file open. So, um, it's a simple as that, so I'm gonna actually remove that password. Now, let's see. Um, I believe I just go back here and delete it out and put in a blank that will work. What's it? Let's close this, um, save changes. The change was, I got rid of password. Let's try and reopen it now. It's probably gonna open on my other screen, but yep, but it didn't prompt for a password. So there goes. That was a simple is adding and removing a password to a file. So, um, definitely if you keep any sensitive information here in excel, you want to use definitely password. Protect your file um, give it a name. Um, you know, maybe don't name your file my list of passwords and websites. Nothing like that. Um, those would be my two tips for you. Like I said, I've done this my entire life. I've got I mean, I belong to somebody's. I'm literally say, like, 10 20 years worth of websites and passwords. It's definitely useful. I use this thing almost at least several times a week where I go to some website. I can't remember what password I use. This is a great place. So, um, it's a simp last, like the way I manage minus I give a category, and I'll show you what I mean by this in a second. Actually, before we do this scroll down. This is gonna be password list. I'm gonna bold. This will try to do the same sort of formatting for each of them. I think we went with 14. So category, um, website, user name passwords, and then maybe comments. So we're certainly know that website will be longer. User name. We're not sure. Password. It's a truck. Comments, maybe water. Okay, Probably this a bold you probably if we covered some of this in the previous one. And also, since we expect this list to be fairly long, I'm already gonna freeze this pain. So if I just put my cursor here, go to view again, if you're not familiar with this, we did it in the first lesson based, we're gonna freeze the pain. So now, as we scroll down, you see the rose kind of disappearing there. There's hiding behind this, but it's keeping those 123 roads visible for us. So as we scroll down will always be able to see. Um OK, so let's start off with just some websites. So say we have some bank websites like, uh, chase dot com be away dot com Now, you know, it's one thing Excel a medically it cause, like, blue and underlines it recognizes these air links. So if we click on this Islamic, we go to the site, which is a nice feature. If I just type b away dot com it won't do that. Maybe fidelity. Okay, then maybe we go Teoh, eBay and, um, Travelocity. Expedia. Well, let's do a few here. Um, that works. Actually, that's plenty. So when it comes to category, then I would type something like bank or banking. Maybe banking, uh, banking. Maybe this is just shopping. This is travel. Well, this is travel. The reason I do this is so say I might just want to look at all my travel sites. I'm h you know, said stay down the road, you know, have more banks that I adhere, etcetera. I couldn't sort this list by category. So all my banks air together. That's why I like to include a category again. Keep in mind, I have ah, password lists with hundreds of sites. So it's handy for me to be able to jump around and sort of how I like. Okay, it's the next thing would be your user name. So whatever using a might be, it's Charles. 123 you know Becky are well, you probably have similar user names, but say it's also Charles. 123 Charles. Oops. Maybe on eBay Used Charles Charles the buyer with maybe like Travelocity, like Charles the traveler, and Charles the traveler. So we can resize this column. Just hold up. And then maybe your password is whatever it iss um, you know, 123 You probably want state password. They have any reasoning, but maybe it's a 1980? Um, you know, bank of the year, Bank of the year, and then maybe use the same password here and here. You know, I'm not going here to give you a lecture on what your password conventions should be. I'm just giving you ideas on how to make a list. Um, maybe your eBay password is, um, Charles loves to buy, you know. 123 Um, you know, travel for life. Any put life and caps. Maybe that's your travel pass. Would you like to use so again, your passwords little bit big here? No, I'm gonna simple. Is that so? Again, Obviously, this is not information you want getting out to anyone. They would have access to your bank accounts, etcetera. So again, use with caution, guys. And I can't say that enough. Um 6. Weight Tracking: All right, everyone. So next one, um, good idea. Keeping track of your weight. This is one that adds value over years. Now, you know, you might say, Hey, there's 20 million APS on my phone. I can use the track. My weight, um, agreed 100%. Agree. What? I found those that over the years I've changed phones. I've changed brands. This app, you know, goes out of business, etcetera. So, data that I had maybe 10 years ago I don't have any more. Do you really need that? Well, that's up to you. So if you want to be able to keep a long lasting history of your weight, maybe this is something you just update one. So once a week, once a month. Whatever you figure out what works for you. Come. But I would like to provide you with the ideas and how I would go about that. So this one's fairly simple. I mean, obviously, So we'll just put weight tracking will make this bold. Go back to our home tab here, make it 14. First of all, and then we'll name our tabun awaits. Let's get caught weight. So not too hard. Guys. What do we want to do? We want track the date. We're trying our weight. I think not enough. There's much more to it. Um, I would always a lot of times you want include notes or comments, type of things, Um, in the center of these and bold, Um, And again, we're going to do our freezing tip just cause we know as we scroll down, we're gonna lose our information. Um, so we'll freeze panes. So there we go. We're going to scroll down now. So a couple of things you could do with this and I'll give you ideas beyond just making less. The Seo won 18. So you did do it every day. So a few tips here, Justin, this might be more usability. So you want to set this list up in advance? So you want to encourage yourself to enter your weight every day? So you're pre loading this within, like, every single date you could type every day, But that's gonna take it. Sometimes I'm gonna show you a little trick and excel here. We're gonna go back to our home tab. Um, so if you click so you start a list so we didn't even need one to. Let's just get rid of that type in the first date. Here's what you do on your home tab over to this fill box and then you want a Siri's so up and down and left and right will just fill the same information we want. A serious though we will. We'll share where this is going. It's gonna ask you, where do you want the Siri's that we actually want? The column. We wanted to go downward, so we wanted in columns. Um, it already figured out that it's a date, so leave it his date and the unit. It's a day, and so step values To put this all together, take the column. It's a date. Increase it by day and one at a time. If we had done month, that would have when it'll go January, February March. But we're doing by day and you'll see what it'll do. So step value one. So one day at a time stop value. Let's say we want to do 12. 31 18 as our stop valley. We're gonna put an entire year watch what happens now. They didn't fill that entire column with data. So in, like, under a minute, probably in under 20 seconds, were able to make a list of 365 days. Whereas you could have spent a good, you know, half hour typing all this out. So there's a little trick for you. Ah, wait. So whatever your weight is, let's say you weigh £150 you probably want a decimal point about people tend to track, you know, one fifties, maybe the next day was 1 51.1 May be then it's 1 50.2 Maybe Then you start losing some way on 49.5 etcetera. And then you could make a little notes, whatever your notes your heart desires. So, you know, um, worked out 30 minutes. Um, etcetera didn't work out. Um, etcetera. Another justice, maybe O C d or something I always like to, like, keep things, you know, capital. I do like proper sort of sentencing. It looks this presents nicer. Um, last thing. I can give us an idea. Here. Maybe. Is too. Use this to create cool graphs. I mean, let's make a little graphic of this. The highlight. The date actually, we're gonna capture the header. Um, if you're not familiar with graphs, if you go to insert and then here's all your graphs it has recommended we could try Hit recommended. See what it does when it comes up with. All right, there's a little bar chart. Perfect. It's like all we wanted. Here's by day. Here's, you know, the different weights course. Over the course of a year, you would have a much more, you know, usable chart other than five days. But a simple is that to create a chart. You see how quick that was to do that? I'm gonna She's gonna leave this here for you guys, cause memory going be able to download this file once we're all done. So I think that's it, guys. I mean, a simple thing. But again, you saw quick, that is to set up. And this is long lasting. Now you could go back. And if you maintain this, you know, and certainly we go through phases where we might forget to update it, etcetera, Um, aps that use on your phone. Maybe you can export that data. I know a lot of them do so in excel so you could maybe then copy Pasted. And here's to see Didn't update this for a month. But then you could export the data is copy it in. Or sometimes it's good to to have to say you forgot updates this for six months. You know, shame on you. But starting in six months, you could see well, where was I back in the last time? I updated it and get a sense of where you've come. Um, you think it's used again and I have mine for last over a decade, so I can kind of track, you know, how have I done with my wait over the last decade is kind of useful information. Uh, that's it for this guy's a simple one, but I think definitely a useful tool for excel. 7. Travel Planning: All right, guys, the next one. This one's kind of find me. They're all fun, believe me. But this one you know who doesn't like to travel. So we're gonna make a little travel planner, and I'll show you what I mean by that. First, let's just label this one travel. Um, and we'll call this travel planner groups bull this and make it 14. So what I would consider doing here is a few things. Um, I really like making lists and excel is probably coming obvious. Now, um, I would do a couple of things here, one I would I would just write down some travel ideas like it's a simple list of travel ideas. And then the second thing we'll do is we'll make a little budget of travel budget. So, um, and we could do it all just here on the same sheet. It's not, doesn't have to be elaborate, So let's write out. So we want toe travel ideas, and then maybe we put like a proposed, like a like a win, possibly win to really give us some motivations. Let's bold that. So travel ideas. When may we want to go to Costa Rica and we want to go to Thailand and Australia. Um, maybe you want to visit England and eventually won a visit? Ireland. All right, so those are your big ones and then maybe have some more domestic ones you want to visit. Las Vegas and Los Angeles are state Disneyland. Put in some. All right, So, wind. So maybe. And maybe these air Jerrick. You're saying you know what I mean? These are bigger trips were not going to go. Maybe we'll go in 2020. Um 2020 22 2024. May we plan on doing a big trip every other year? 2026. Maybe that maybe there's some milestone. Maybe you turned 50 you know, when do you think? Okay, let's make this like the time I turned 50. That's when we'll goto Ireland. So and you could obviously put notes like we just hit on all of our other ones. That's center that, um, you know, 50th birthday or something? Oops. 50th birthday. Um, you know, our may and maybe this is your spouse's birthday. This is Ah, 40th birthday for ah, Julie. Groups that spell birthday, Ronald. First of all, for Julie and this is for, um oops. I hit F one. Just if you want to know if you hit off when it brings up the health box, Um, for Robert hurt, whoever it may be. So you put in some notes what it is. I mean, you can extend this obviously over a bit perfect. And maybe these air more north near term, you're thinking, Ah, June 2018 and December. Now, see, before we take in several, you'll see it kind of formatted based on because actually start to write out like a real date. And you see appearances 61 18. I just want to say June 2018 if usually posture for you another little Excel trip. Type the apostrophe first, then type anything. It won't format it. It will just take what you type, and that's all it leaves. So June 2018 and maybe this is gonna be for, ah, December 2018. And this is actually me for New Year's. And this will be maybe here you put the dates like fifth around around the 15th. Something like that. Um, you could center the I mean could then format this how you want centric. Maybe it save? Another idea would do on here. Just keep it kind of clear. I would put the underlined hopes on this. There we go. Now we have a little idea. Travel ideas. So, um, hopefully you're saying to like, we've only got four tap. So far, we've got a bunch to go. This workbook is kind of a handy work, but, I mean, come in here. You could look at your budget. You know, check out your passwords, your weight travel. Um, I can tell you I pretty much have this more or less exact workbook myself that I've used the last decade. And when I do, too. Then as I sorted. So once we have Oliver tab, I put the ones that I use the most of left. Like I look at my budget, you know, a lot, you know, But I don't You know, maybe I use my weight tracker a lot, but I don't update my travel every day. So that's more towards the end of the workbook. But I know it's There comes the next thing. Let's do a trouble budget all in one. That's bold. That, um, we could even you know what? Let's Let's put this up here and make it kind of more of a main category, just for fun. So here we have our planner. Um, and here we have our budget. So for any given trip. So maybe here we label the trip and we say, Well, the next one coming up is Las Vegas. So we go Las Vegas, actually, let's put it here is a sub header. If you will maybe bulled up so And if you wanted to, we could give ourselves some more room. Maybe we moving over one. So it's not like right next to that that other stuff we typed, Um, here we type, Um, what it is and how much is essentially out needs so could do by date. Like, say, you're gonna plan out a week. Tramp, You budget freeze day. I tend to budget more on the actual thing, like the trout like the the plane ride, the food, the hotel etcetera. So, um, certainly do it however you like. But I would put some whatever you call it, the event in amount. Simple. Is that Let's give it a underline. I'm going to do one other thing here. I'm actually gonna put Las Vegas up here and we had deleted from here. I, like, create a bit of space. It's just a bit cleaner. So event is maybe plane tickets, plane tickets, um, hotel. And maybe we also put Las Vegas three days. So we know that everything here relates to three full days. Um, plane tickets, hotel food, gambling shows, um, taxis or uber's We almost right taxi, But certainly be uber. Or if you rent a car being here, um, maybe tips. You know, um and then maybe Miss Guy always like to include a miss category, cause I know I'm going to spend money on something else that I'm not thinking of. Maybe shopping as well. You'll see when I double click that resize that based on that 1st 1 we don't need it that big. Let's just do it to here. Let's do some shopping and then do misc down here. Let's put in a total was bowled it put in our double our single or double if you remember that from before, um, these are all gonna be dollar signs, so I know moving a bit faster, guys apartments because we've done this in other lessons, so I don't want to reiterate how you do. Each is little things each single time. Um, this one. I'll show again the some so equal some open bracket. Highlight what it is you want to some together. Close your bracket hit. Enter. There you go. If you go to any selling hit F two, it will bring up the edit box and it's on a formula. It shows you what what it's doing. And it's summing those cells. Simple. Is that guys? So maybe then hotel airplane tickets for 600 hotels gonna be for 50 food. We spend 100 bucks a day. We spent 300. May we put in a little buffer? 3 50 Gambling Least plan on spending 500 shows. We're gonna go to shows its 400. You know, we got decent seats. Tax easily. Estimate, 200 tips, maybe 100 shopping. We want to do some shopping off, maybe 500. Get close. I don't know. Um, Miss So before we do misc Just a tip. I'm so for one, you can't see this number because it's too big for the column. Just resize this really quick. So we're up to 30. 100 for me personally, I put in MISC. I try to do like a 10% buffer, if you will. So corrupt it's or 30. 100. I probably put in like a $300 miss. Just the buffer. Essentially. So there you go. So 3400 is our total. May we bolt that as well? And there we go. So here we have our list of ideas here we have our You know what we're planning for this trip. What could you do then? I know what you could do. Come back to your budget. The first thing we built put in a category travel. And maybe then you make this more specific. You go travel, um, Vegas and say you had the next three months. Jamie February. March, you plan on going? We were going in June. So maybe you're gonna save, you know, $1000 a month or $500 a month to get to your goal. And what do you do? You tie this back to hear you just say Okay. Well, we need 3400 by June. I think that's when we said we're going to Las Vegas. Um, certainly we want to have that money before June. So we need that by May. Let's just divide that by five equals that divided by 5 680 months. So maybe our budget needs to be 700 a month, and then you could even write that you could write notes, you know, title save up for 30. 400 for Vegas, etcetera. That's it, guys. So there you go. You have some ideas and certainly the other thing you could do. So once you have this laid out, I'll say you want to plan out your Disneyland trip is Well, just copy this and then maybe put that one right here. All right, let's put that now. It's a replica of the Vegas one. Now, just resize your columns. Um, change your categories as you need to, like, you probably have gambling for Disney. Um, and you could make this, uh, Disney trip Disney trip. You know, maybe it's five days and then just go through and re edit this. Put in everything you need in a way. You go. Um, I'm gonna Here's what we'll do. I'm just gonna delete out these amounts, and we'll leave that blank. So when you get this file at the end of the course, this is exactly what you'll see. There you go, guys. A good way to use Excel to plan out your travel. 8. Home Inventory: Alright, guys. So up next, let's make a home inventory lists now. Ah, this is something. A lot of people don't do it, but it's actually really important if your home ever got broken into, you know, hopefully not, but if it did, this is really useful. It's useful for you to remember what you had. Its. Ah, definitely useful for the police. So they know what to look for and as well for your insurance company. So you can say, Hey, here's all the things we owned and what was stolen. Let's make a home inventory list. Gonna bold it as usual and make it 14. All right, well, let's name our time as well. Home inventory list. Just compliment Natori again. We don't want the tab names to be too too big. It's nice that they all fit on one screen. We'll have to scroll across. All right, So what types of things do we need? Including the hair? Well, top of my head. We need the date purchased. We need the items. So actually, you know what? I'm gonna I'm gonna x I hit Control X, which is to cut. I'm gonna pace this over here, so control V Paste. Remember how in the past we were? Do you copy? Then paste up here, you can use the keyboard shortcut. So holding now control and see copies Who announced Control and X Cuts and control V Pace. And I just did all that in the same cell so it wouldn't move. You want the item? Let's do item. That seems like a good one. Now, right off, before we start making our headers, let's just go ahead and center everything that's in this road. We know that we're gonna want to be centered. We're gonna want to be bold it. And now we're gonna want to be underlined. I'm not a fan of highlighting a whole row and formatting. You know, I don't mind bold and things like that, but I don't want to like underlying cause that underline will go the entire like it'll just go infinitely across up. Let's just go to here. Maybe we might not need that many columns, but we'll see on the bottom there. The item name. Well, certainly, whatever we have, we're probably gonna have to be a bit description. Um, so maybe item is just like a short name maybe. Then we put ah where we bought it. Actually, you know what? Let's think so. It's but date purchased over here as copy that. Now let's do this. Um, where? So where? Purchased? Um, so it's another few things you can do here. So if we hit wrap text on the state purchase, we certainly don't need a really wide sell for a date. But if we make this too narrow, then it gets hidden. Let's hit wrap, text. What that does is it extends the depth of the row, and now we can see birth both words. So it just wrapped it. And now we can make this a small as we want to make it to small obviously than that gets hidden. But we can make it just And that seems like a reasonable with for a, uh, for a date where purchase we could type where purchased and apply are wrapping feature we just learned. Now you see, it kind of cuts that word off and probably the name of where we purchase it might need to be a bit bigger. So let's do that. We could certainly write, um, thinking like where What room is it in what room was wrapped that again and maybe guys, let's just go ahead and highlight this entire thing and hit rap tax little to supply than every single thing that we type. All right, so we're type birthday. Let's throw in an item. So maybe it'll spur some ideas to, um, you know, we have our home computer, and maybe we want more details, so I encourage you to put. And one thing we're actually gonna put is more detail over here, so But I would at least give it a name. Maybe it's your Dell desktop computer. All right, so obviously, we need our item going to be a bit lighter. Kind of. May we purchase that on? Ah, was a New Year's Day. Ah, purchase in 2016 here. I would just leave the date I like, You know, on the other ones, we like the date just the month of the year here. I would leave specifics. They purchase. Maybe we bought it on dell dot com. What room is? It's in the office. How much do we spend? I mean, that's obviously important, right? How much? Um, it was $1500. So this one we're gonna have to format is dollars. So let's just go ahead and do that. And I mean, it could certainly leave the sense, um, up to you on that one. Honestly, it did get rid of the rap. Actually, no, it's still wrapped. It's just because of the formatting. It's a little bit bigger. That's fine. You hit save again. Just we have that. So, what else do we want? No, Guys, we have our desktop. We know when we bought up where we bought it, where it wasn't her home, how much I would at least put Well, we might want include some other information. I'm not sure what else Um, like, I would want to put, um you want to make sure this list is up to date as well? So other thing I would do up here is maybe put last. Actually, let's just put it here. Last updated. And we do, um oh, for a 1 2018 So then we know if we ever come back to this list, we go. Okay. This list was last updated X date. So we know that a then we bought since then, we need to include maybe we get rid of this computer at some point, so we know, Say, we're we got rid of that computer in June. Um, well, maybe that's something you have put over here when disposed of. Now, most people don't buy things that get rid of them. Not too much, but it be useful column, and we'll just be blank if you don't end up using it. So no harm there. Um, I would put more notes, additional info. Now, I kind of abbreviate that my chances are you're gonna have to actually write out, like, quite a bit. Like, um, maybe you put that it's the monitor keyboard. Um, you know, desktop, um, and mouse like that's everything you bought together. And what else could you put over here? One thing that I've seen that's creative, and we're not going to do it here, but put ah image. If you had a picture, you could actually embed a picture here so you could insert, um, Where is that? I'm trying to see. So maybe it's not. Insert there We go under illustrations on the insert. You could insert a picture. Or maybe you host what I would actually recommend you do, since you don't obviously want a ton of pictures on this. Um, you know, if you have some sort of online drive that use Google Dr One drive, whatever it might be, keep a folder. Let's your home inventory. Another thing. I just thought of here. You know what else we want? Might want to clue in. I just want a number. This list. So, uh, I'm gonna insert just to show you what I would do. Here, insert this. I want to move these back over to here. I want to underline that same as before, not to get and then just put a number. Are Let's put toe item number. The numbers time. This is gonna be one. Now, let's use our crazy Phil formula that where you were not formula, but tool that we learned before. Serious. We want to go down. We want to be linear. It's just numbers. There's no days or weeks or anything. Step value one. Maybe We want 50 items. There we go. So we're gonna number everything. So then what? Going back to what I was saying is, um, created on my drive. Have a folder that's home inventory take a picture of your computer set up and then know what you name that file is you name it like, uh oh one dash Dell computer. And then you just put a link directly to that file here. That's exactly what I would do. That's about it. For home inventory, guys. That's all I can think of. I mean, certainly again, you know, go crazy with it. Do what you want. Include anything they purchase when dispose how much like if you want to bring out the tax and maybe this shipping, Um, Or maybe you sold it. You know, when disposed, maybe include a column. Like where, um, you know where disposed. Like maybe you sold it. Maybe sell this computer on eBay later and you buy a new computer. That's perfect. Do that. So, um, there goes guys, that's a little handy again. Completely. Not the most exciting list that you're gonna be updating every day or anything. But believe me, if you get to a point in life where you need this list, you're gonna be really, really glad that you made it. So I definitely encourage you to do this 9. Credit Cards: Alright, guys. So the next one, much like the password list, this is another one of those things that's got really sensitive info. So this isn't going to be for everybody. I certainly understand. A lot of people would be like, No, I don't really want to keep that stuff in Excel on my computer. Um, but because of the password feature on Excel and again used my tips from the password list , you know, video, you know, password. Protect this file. If you have any sense of information in here, um, don't name it. Anything conspicuous? Um, save it somewhere. You know, maybe that's not easily found, like not on your desktop. That's that trap. Um, and just use good sort of security measures to make sure that you know your data safe again . I've done this for last 20 years. Probably never had an issue, but I relate that to good search security. Update the password. I change it. I don't have multiple versions of the filing around, etcetera. So what it is is going to be a credit card list. That's, um, rename this soups. I always try that again. Credit cards now. Well, let me just put in the title. I'll tell you a little bit more about this, uh, credit cards. Okay. So again, we'll do our bold. So we're gonna find this useful is you know, any car that a half's not just credit cards, but your debit cards. If you have any pre paid cards, what I do is I keep here a the name of the card, the card number, the expiration date and the three digit code. Definitely obviously sense of information. And you don't need getting out there. So at a minimum, please password protect your file. But where this comes in useful is could you do a lot of shopping online, paying your bills, etcetera? I mean, I personally find it slightly a hassle to constantly have to type in my entire credit card number on my computer, um, and whatnot. So what I do is I keep this list and then I can easily copy paste. And that's the whole reason for this list of cards. Really nothing else as well. Occasionally, just cause I have personally, I might have different banks. I have had different credit cards over the years. Some of expired, maybe lost the card had to get a new one? No. So say then. I've had different cards and I go to some website. They say, Oh, you know, we tried to process your account on card number ending in 1234 and we weren't able to. And you don't recognize that card number. You can come to your lists and go. Okay. Yeah. That was my old debit card that I replaced a year ago. I just forgot the number. Um, here giving. I'll give you the new one. It's just good for reference sake, if you will, in that sense. So again, a simple list, it would be. See the issuer? Um, you could write credit or debit car number dates are expiration. That I guess Sec xy, CVS the three digit code. Um, again, let's give this a bold maybe center. Now we know that it sure will be slightly bigger. Credit card number will be decent length. I'm Oops. Sorry. That's creditor. Deborah. Credit card number. Expiration date. Ccv. That's fine. Let's do this. Let's underline it. All right? It's a simple house, you know, Maybe this is a B away. Bank of America, this is Chase. Ah, maybe. And maybe you have to chase ones now when I tend to do is actually so I might write chase personal and maybe right chase, you know, business. Be away Personal. Hey, got you Could created additional extra column if you wanted to say, Hey, this is personal or business, you know, manage that. How you want personally, It's just how I handle it. Ah, maybe you then have an American Express, American Express, personal and whatever Make a list. So creditor Deborah, you get this type credit or let's say these are all Damn, it's This is credit perfect card number. So because it's a number, um, sometimes little format weird. I recommend to use the apostrophe chick. We learned one of the other videos so hidden apostrophe and anything you type will stay exactly how it ISS. So I tend to also like to you have two ways for you Could almost credit cards or 16 digits , right? At least you know, the main sort of visa MasterCard. Sino American Express is slightly different, and so was discovered, but, um so you might write for oh, for four space. 1234 Space 1234 states. 1234 Kind of like how it looks on your card. That's fine. The only promise. When you paste this into some websites, some websites will combine the numbers. Others won't, they'll say, or they'll just truncated. They'll say, Oh, that's too many digits So I personally tend to just put in the numbers. No spaces. Um, just make it easy. So when I copy and paste this into any given website, it goes perfectly expiration date again. I used the apostrophe tools. I might say, 0 to 2020 and ccv apostrophe just out of habit. I mean, it's 123 There you go, guys. It's a simple is that American Express Does they have, ah, to see CVS have, like, a four digit code on the front and ah, three digit code on the back. I think you could included extra column if you want it and put that in here. If you did have an American Express that you wanted to track and that's about it, guys. I mean, it's a simple Is that again? Not for everybody, but I mean, to be honest, I love the functionality of being able to just copy. Paste this into different websites. Not have to go, you know, grab my wallet every time I want to, you know, buy something, type in the numbers, etcetera. Um, this works really well. Um, other recommendation was based to say you had cars that expired or you got rid of this card . Maybe make a second list down here. It doesn't have to be a fancy. Could just expired or replaced up to you How much detail you would want to do. But then I would just honestly, cop. I would cut this out of here and put it. Oops. Put it down here. And then I know everything below here is gone. If you wanted to make notes, you know, certainly put headers on here and be like, Hey, when was it replaced? I don't Honestly, I'm not sure that you really care that much about it, but, hey, if you do, you're gonna go. This firing might a little track as much as you want. So, uh, just another idea. So then this is only your active cards that you have up in this section, and that's about it for credit cards. Guys, 10. Prior Addresses: Okay, guys. So this next list is gonna be a list of prior addresses, places you've lived. So, um, as I type here, ah, explain kind of the importance of this one. So, you know, personally, I've lived a lot of different places in life, you know, Um and I want it. I want to build a reference back and say, Well, what was my address or where was I say in any given year where this has actually come in handy? ISS besides, just out of personal interest, you know, I'm going. Oh, wow. Look at all the places I've lived. Um, um, if you ever have to verify your identity, so say you're taking out a loan or calling your bank or whatever it might be, Um, And they run that report and they do the background check in the Alaska questions for verification. They might have been asked things, like, you know, in 1982 what street did you live on? Well, you know, I surely don't remember that in my memory. Just isn't that good. That's not information I retained. So this is where this prior address list rate comes in handy. Um, as or as well. You know, say I get some, um, you know, male, that's forwarded to me, or I want to, you know, go back and sort of, uh, for whatever reason, have to look up an old address. Or maybe I just wanna bring it up on Google maps and see what something looks like. I've done that before. I want to look up. You know, where I grew up is a kid. I want to bring it up on Google Maps, but unless I have the address I wasn't able to sort of narrow down on it. I didn't quite remember. So simple list again. Definitely not something you're updating every day, obviously. But we'll definitely save you some pain if you ever have to actually recall where you lived at a certain time, Um, or just out of personal interest. So, I mean, this one's fairly straightforward. Um, you might put the date, uh, date from day two. Um, you know, streets, city zip, are, you know, in the country received I've actually personally lived in a couple different countries. So, uh, date from day to street address will probably be a little bit longer. City, probably longer a zip country. Sure. So again, let's do what we normally do. It's bold. These Let's center. Um, let's underline, um, and I just go one beyond it doesn't look too horrible tohave it. Kind of extending in that way if we think of something else we want, um, so, you know, maybe hey, from when you know, and And you could honestly have a comments box if you want thinking of why in a second. So, you know, maybe I have my address is from whatever wanna one. I'm just making updates isn't actually my birthday, but still, I was, you know, a one a 1 10 years old. 1990. Um, I lived on 1 to 3 West road in ah, wherever, let's say Seattle, Uh, I guess you could put the state so we didn't actually think to put the state. Not a bad idea. Now again, that guy's obviously Taylor. This if you know you live in other countries might be provinces. Your address format might be different. That's fine. One thing I don't like here. I'm gonna actually, um, that's okay. Let's just leave that state that's washed in 98. 123 I don't quite remember USA etcetera. So you might put, you know, this was, uh, whatever the brown house or something now, so you would go on and make a list. And it's a simple is that, um I would encourage you as well if you ever had a P o box type of thing. Put that on here. Maybe you live somewhere temporarily. I know myself. I personally live somewhere for just about three months. Once when I was in between why it sold my house. And I know it's gonna be moving and leaving the city by the one. So I just ran a temporary place. It's good to have that address because I believe me, I could not tell you. I've taught my head even what road that was on what subdivision? Etcetera. At this point, it's just, you know, it was so long ago, So it's good to keep track of that P O boxes, especially if you have businesses or you just have a P o box for your own personal use. Good to have that on here because, you know, that's certainly stuff that we don't always retain. So, um, like I said, I mean I probably lived, I would guess roughly 10 to 15 places in my life. And then if you add in P o boxes, I've either had for my own personal use, because maybe, for example, one point I rented a house with two other people, and I just didn't want my mail going there. So I rented a P o box that my mail sent to. Well, it's good to have that address in the future, Um, or of rent appeal boxes is for businesses before. Just so you know, again, I'd have to say, Use my house address. I just had a P o box down the street that I was able to use. And that's the type of comments you could make. You could say p o box for Business, ABC or whatever. Um, you know, p o box, um, for personal, because lived in house, lived with roommates or something. Just little notes. I mean, doesn't take you long, but in the future, if you ever have to go back and reference this, you've got it all in one spot. So another think to here, let's do our quick freeze panes Just for fun. Always forget what tab. That's on, um, view, I believe frieze pains. So that's a handy trick guy. So if you scroll down, So anyways, um, there you go. Another idea. Just keep a list. Your prior addresses. You know you have it. Then when you move, you know, So, you know, you don't have to update the day you move, but at some point, you'll be like looking through your file, and they'd be like, due to do, you know, addresses. Yeah, I need to add, like, my newest address, and then you have it. So good use of excel, guys. 11. Gift List: All right, guys, this next one has definitely saved me or save me some frustration at times in life on. And it's simply a gift list idea. Um, let's just type that gift list. Um, gift idealist. I guess it would be a gift. Ideas there is called gift ideas, that story usual thing. Make it 14 rename or tab gift ideas. So this is simple. So when it comes holidays, people's birthdays, you're trying to figure out what to buy for them. It's always, you know, I don't know. I never seems to come easy to people. You know? What should I buy this person? I don't know. Is there anything that really into etcetera? So what I have made a habit of doing is is throughout the year, as I'm just interacting with different people, family, friends, co workers. If they say something that strikes a chord like, Oh, that's something they're really into Or that's something specific that they said they wanted. I will write it down. So then, when it comes the holidays or their birthday, whatever the case may be, I just pop on my gift list idea, and I see what notes I made for that person. Sounds simple, letting it sounds stupid, but honestly, you would be surprised how often I've used this thing. Um, so I would just, you know, again, write their name. Um, I mean, if you really want to get specific, you could say, How do you know them? Are they related? Are they coworker, Etcetera? I don't do that. And, you know, when I see their name, I typically know who the people are. I'm not keeping gift ideas for to too many people. Um, And then the simplest gift ideas. I mean, and I just this one I keep very simple. I just make a list, like, out. So say, um, let's just pulled this, though. I love ah, Let my bowling and centering. So, you know, maybe it's my mother, you know? Mother, Father, Brother, Um, you know your sister. Maybe your wife, your kids, and obviously you could put their names in here, maybe coworker that you're close to co hooker one. And let's see, it may be your maybe your paperboy, um, or your pool guy. Paperboy pool boy. You know, you want to get them something at Christmas and what you're gonna get them. Who knows? Maybe even it's not something specific that they've said. It's just something like you saw. Maybe you're out at Costco or Wal homered wherever you might be. And you see something ago, maybe see a funny mug that says something about, you know, my pool boy is number one if you don't buy it on the spot. I just shot the idea down because often to how many times? If you'd say not got it. Then six months later, it comes time to buy them something. Go. You know what I remember is something. I saw him. I just don't remember what it was, but it was perfect for them. Well, that's where you pop on your gift list idea, and you see, and you say pool boy number one lug out Wal Marts. Perfect. Maybe for your kid. You go. Okay. They're really into Ah, Legos, Um, Batman, Um, Marvel Comics, Marvel comics and, uh, the left. Right. And, um, maybe they love Oreos. I don't know. It's hard to think of gift ideas for people that I'm sort of fabricating, but you get the idea, um, something like this, Especially sort of haphazard people like somebody's in your life, day to day. It's probably bit easier someone like this, though. I'm not so great. Um, I can't say, though to So for example, my brother is turning 40 this year. So one thing that my mother had thought of ahead and she said I would be really cool toe have sort of some hand like custom made. I believe there cufflinks with their initials are with his initials, I should say, And it's something, you know, that she thought of a long time ago, you know, Right, an idea down like that cause then when it comes time, you can you know again refer back to your gift list idea. See what you wrote for them. So it's a perfect way. So any time a gift idea spurs the all in your head pop on this list, make it keep it And then what comes time to buy something. Bingo. It's here. And you'd be surprised things like this that you see in ago that's perfect for that person . You don't buy it at the time and then again six months later and you're right. Jeez, I wish I had bought whatever that was because I remember it was perfect, and I have no idea what it was anymore. Um, so something like this will save you a little bit of frustration in the long run. Um, and just the more people interact with in life, you have to buy gifts for, especially with my guests are a lot of people say you have a big family you buy gifts for, you know, your aunts and uncles and you know, their kids and everybody else. The bigger this list gets, the more important it actually become. So definitely just a little idea again. Simple one. Perfect, though, for, ah, make your life of that much easier. 12. Savings Goals: Okay, so next let's let's get back to something money related. And maybe this is when you consider a bit more important that might actually be in and out of a bit more. So just before we get into one thing I mentioned, you know what's work done? We might We're going to sort these a little bit. So things like, you know, addresses. You're probably gonna use that very much. Like how often people movie. If you move once a year, that's once a year. You're probably gonna updated. And then how? After I'm going to use it? Not a lot. It's useful when you have it, but I'm still gift ideas. You might use that a bit more way tracking. Probably more. Um, so this was going to your savings goals. This one? You might update fairly regularly, but maybe not as much as your weight. So we're gonna organize these by priority eventually. Um, so it's right that down. So savings goals do your usual bold and make it 14 and right. Oops. That created an extra worksheets. All right, well, that's fine. We can use that for next time. Saving someone's gonna call it savings. Um one other side. Just kind of idea reference, if you guys will. So this girl bar scrolls within the sheet? Obviously. You see Oliver Tabs here. Now, we've already got so many tabs that we've kind of hidden are other ones. We see these three dots here. If you click on that, we can go one at a time and move over. Same thing on this side. Um, the other thing can do is if you don't tend to use this bar, you can resize it. You could make it actually. Really, really small. You can get rid of it if you want, but I don't recommend that. But I would you know, something like that. Then what you can do is, um Let's move this over one more. Now we can see all of our sheet tabs, and we know we're actually gonna tense. Let's just go ahead and create that 10th 1 Um, actually, no. What? No. This is the last one right here so we can get rid of this. If you right click on these guys, you can delete them. Um oops. I goofed up again. We do actually have one more. I've been all over the place. All right, savings. And then we do have one more. Okay, guys, back to saving. Since we've stalled long enough, real simple here, I would list out specific savings goals that you want to make. Maybe it's time. It's the usual things. Retirement, Um, travel. You want to set aside so much? Maybe money for your kids, maybe for college. You know, a few things like that. Just a few ideas. Maybe you just want a buffer. You want a buffer in case you lose your job. So, um, what I would ideally do here, I mean, lots of ways to form at this. The way I would personally do it is I would, um I would almost set up a little box, if you will, and you'll see what I mean. A sec for each of the goal. So, um, you say this is college savings. Let's say this is, um, just general savings and my general I mean, I lose my job, and I need money to live off of savings and then maybe travel savings. And this one is maybe generic. I'm not, uh, you haven't allocated this towards ailing specific. I just know that I like to travel as we discussed before. And um, yes. So that's what that before I just noticed guys. Somehow I move she 10 way down here the blank when I think when I was clicking around, let's just delete that I knew I had one too many sheets at one point. Nonetheless, let's get back to our savings sheets. Okay, so let's start with one, and then we'll get the idea and we can easily do the other sub. Gonna bold these just because. So what do we want, Guys, when it comes to savings, well, we probably have a total amount we want. And we probably have a date that we want to reach it by. Right. So let's just kind of do that. Let's just write things down sometimes that's all it is. So, um, goal. Maybe right gold amounts and gold date. So no underlying these as well just to kind of create some separation here, guys. All right, it's a goal amount. Let's just think college savings and maybe put which child a tour. We need $100,000. Quit big number. This is gonna be dollars. We don't really need the senses there kind of targets, if you will, um, gold dates say our kid is only two years old, so we don't need it for another 18 years. Um, so we just say we want this by Let's just say January of 2030. Who knows? Whatever your goal is, that's what's most important to you and hit Save real quick. Um, than what I would do is honestly say I would start figuring out some metrics like, OK, well, its 2018 now by 2030 we 100,000. That's 12 years from now. We're giving ourselves a bit of a buffer. You know, I miss their kids, go to school for 18 years or 16 more years. Um, the thing I'm not some not this for me is more of a just a general sense to keep it on my forefront. And on my radar. I'm not calculated to the penny and not calculating with interest. All that stuff, I'm just basically saying, Hey, if I want to save $100,000 roughly how much do I have to save every year? Um, per year savings. Now, I know it's probably gonna be a bit less than this because I'm gonna be earning interest, but I don't care. I'd rather be conservative. So, um, we know that that's roughly 12 years from now. Let's just take this amount. Divided by 12 8333 leg, endlessly ditch are So we got OK, that's how much we need per year. Well, that's before we get too far. Let's let's do these other ones as well. When? See? Now I'm going to reduce the amount of space kind of in between just because so go amount. So one thing we could do here, guys, So we already have our um You know what? I'm gonna reform at this a little bit now that I'm seeing this. And this happens sometimes you start building something you realize you know what? There's a better way to do this. Here's what we're gonna do. Guys, we have our main headings, and these are gonna be the same for each of these categories. So rather than do it per, we're gonna move this here. We're gonna move this here. We're gonna resize each of them. So there, Big enough to get rid of that. We're gonna make, uh, this was obviously belonged to college. We can just reduce this one. Or we could delete that South. So here doesn't make a lot more sense now. Gold amount, and it's by category. So just like that, we fixed up our spreadsheets. So I wish I could say I did that on purpose to show you how to do some changes on the fly. Um, it really did, though. It's one of those things where you start building something and you realize, you know what? There's a better way to lay this out. Hey, it's worthwhile. It took me like, less than 30 seconds, and now it's all completely laid out a little bit better. Uh, the nice thing here is, So now what do we have? We have our per your savings. And this is a formula, right? It's if I hit off to its that divided by 12. Um, now each of these is gonna be different based on the timeline of the goal. So you need to be careful that I was going to see could copy this formula, but it's always going to divide by 12 songs. You remember that? Edit it. So, um, nonetheless So let's do let's just fill these in just giving ideas to stay by the end of the year. I wanna have so by January 2019. So a little less than a year. But you get the idea. Um, we want to have $20,000 saved up. And I'm not gonna format anything quite yet. Guys, let's just types of numbers and travel savings. I wanna have again. You could go to your travel budget. I mean, I know we did a whole planner, etcetera, but, you know, we decided we needed 3400 here by June. Our say we're just gonna guess we need another five here. Say we need a We need $9000 in general. Let's go to our savings. Let's just there. It's $10,000. We want $10,000 by year end, but we know that we're going to use some of that in June. That's okay. We just know Overall, we wanna have put aside $10,000. Whether that could spent or not is irrelevant. Um, and that's gonna be by December 2018. Okay, Now, before we form any thing before we go and start format everything, we already know that this column has the format that we like, right? Let's just copy that format and pasted over here. So if you remember from the early lessons, there's a way you copy data, but you can just copy formatting as well. So there's two ways of doing it. I'm gonna give you the shortest, shortest way. There's something called the format painter. It Excel realizes that this happens a lot where you just want to copy the format. So they gave us, like, a direct kind of linked, if you will, the copping format. So I'm gonna highlight what I want to copy the format of gonna hit the paintbrush. And then I'm gonna do this now, as long as the boxes air kind of the same size, right, it's gonna figure out the right format. Let's do that. And boom, You see it already? It's aligned, right? It's dollars. And if we type of formula in here, it'll be dollars as well. So we need this divided by, um Well, you know what we could say. Hey, you know what? This is really just eight months away, so let's do eight months, and we could say, Hey, this is you know seven months away, Um, equals this divided by seven because it's April. Right now, let's get rid of our dollar signs. It's not of and there we go. So we could go okay for your savings. Actually, you know what? Now that I'm looking at this, this is slightly misleading, cause these weeded by the month this we did do by the year. So you know what we could do? Guys, since this is by month, this is by month, Let's just say per month. So we need to change this formula, though. So instead of being by 12 that's really by 12 years, type 12 months. So, um, I'm actually gonna write that formula, so it's 12 years, but there's 12 months in each formula. There we go. So, roughly $700 a month quick is that we made another little change on the fly, if you will. But this all makes a lot more sense now. So one way to look at this as we could go. Well, what's our total savings need? And this would be, uh, this amount right here. So it's gonna be some all of these. So there we go. Total savings. Need per month. Um, you could do anything. You could highlight this if you want to. So it's. Or maybe you just highlight. Let's undo that. Let's just make it. No, Phil, Maybe we do this. Put it in green. Since the number, you could write that name next to this down here if you want. However, you want to lay it out, guys. But you could see now we have a little tool to sort of calculate. All right, break down each of our goals. Break it down my month. Okay, What does that translate into On a per month basis? And here you go. And then once again, you could really tie this back into your budget. So maybe, rather than have different savings, if he will categories just have one that says savings. And then you pop over your savings tab and you see what the savings is being allocated towards. There you go, guys. A little way to sort of track and sort of create your savings goals and, uh, hopefully put you right on track. Teoh. Sort of staying with the numbers that you need to meet your goals 13. Life Goals: alright guys, to this last one. Um, I previously safer last cause it's ah, it's important to cycles in life. So we're going to say that life goals do your usual thing. That's bold. It make bigger rename er to have life goals, as we see as I kind of mentioned all along Nice. Here we have all of our different tabs, right from all the different things we've done. We could even make this a bit bigger without hiding anything. Perfect. So without having typed any life goals yet, we have a nice list friend. She Look what we've got. We've got our budget or password weight travel above about right. We have a lot of stuff on here that we get to track. So life goals tab. Here's what I personally use this for. I literally make a list. Let's say it's 2018 and I have, you know, ideas of things I want accomplish this year. I don't go too crazy. I just say, Hey, here's the next, like 3 to 5 things that really want accomplish this year and then maybe at the same time, I'm thinking of things that I do want to do in life. But I know it's not gonna happen this year like, say, like, I have 10 different places I want to travel to, certainly on our travel tab. You know, we had the list and we guessed some years I would probably put that on here is Well, though, I'd be like, OK, in 2020 I want to travel to Ireland by 2014 or 2024. I want travel toe, Spain, whatever the girls might be. So it's nice to have a little list, and then what I do at the end of each year's I revisit the list, Um, and anything that I didn't accomplish if I still really want to do it, I carried forward to the next year and I say, OK, or I just reallocate saying something I didn't do this year. And I know you know what? Next year is probably gonna happen. Well, let's schedule for two years from now. So, um, it's a simple, as you know, year and then maybe goal. And then the way I do mine is just to give you a sense. Gonna fold this. Um, I'm gonna make this just a little bit bigger. Probably center. These do our usual. Okay. And then I also write notes over here. Should did that. That will make that big. So it's gonna be very simple list. But so, you know, I have all my prior years as well. So maybe, you know, back in two, down seven, my goal was to start my own consulting business. Um, and then I write it out. Started in October 22,007. The other thing I do once I get my list going is the things that I accomplished. I highlight in green. It's really rewarding toe. Look at your list and go. Wow. Look at all the things that I've actually done. So maybe in 2007 I had, like, a bunch of goals. Um, you know, move moved to, um, Los Angeles. Um, maybe I had to go to buy a new car, buy a new car, um, traveled to our, you know, visit Disneyland. Seems simple, but, hey, maybe that was my goal for the year. So say I ended up doing those three things. Are those things like highlight? I'm agreeing to make a little comment, maybe design and it and quite making the digital. And so you know what? In 2008 and what I tend to do is I leave a little break. I'm just between the years I'm gonna get rid of that formatting. Um, so I would have my 2000 equals. Um, but what I would do with them, it's just copy this down. So maybe I do this one in. Ah, yellow. You know, you don't want to be too abrasive. You don't need to give it a dark red. Like I blew that. Um, maybe just the yellow like that. Then here, you put I would put carry forward from 2007. Um, seven, maybe. Now my goals are to visit Miami. Ah, do whatever else you know, Put it some business related wounds, you know, grow business to 10 clients. Ah, whatever. Um, do ah, you know, 20 courses online, Or maybe it's learned some new skills or whatever it might be. So then you can see again guys to say, end up doing You know, this this and this. Ah, hide in my green. I don't end up doing this highlighted in my yellow. And then, you know, 2009 you get the idea 2009 Again. Sorry, it's copping down the format. There seems good. No, Phil, do the same thing. Visit Miami, Visit Miami, carry forwards from 2008. Now we need to get rid of that formatting. But you get the idea, guys, as this goes on, know what's really cool? Say, 10 years from now, you'll look back on your life and you look at this list. You go. Wow, Look at all the things I accomplished. Sometimes in the day to day, it's easy to get caught up. I just feel like maybe not getting anywhere. You're not doing the stuff you want life, but it's really cool to be able to look back on sort of your life goals list and say, Oh, look at all the things that did do. Or maybe you see something from 2008 like Visit Miami. That's something I would personally, myself like to do that I've never done so. You know, I might look back on that and go. You know what? I really lost sight of that goal, but it's still something I want to do. So I'm gonna included for 2018 you know, here we are. 10 years later. Let me include that life goal as well. So, uh, definitely get nothing. No, no brain science. Nothing tricky and excel with this. But how cool is that? At some point, you know, maybe once a year revisit your life goals and go, Hey, you know, look at all the stuff I did accomplish. And like, the things that I did do. That's terrific. Now, let me set my goals for the next year, and then you have something, you know, written down concrete that you can revisit. So, um, that's it for that, guys. What? The Only other thing I promise you I do on the show. You how to read? Sort of sort these tabs, if you will. So budget for me is always number one. That's something I'm in and out of almost daily password list. Maybe not, but maybe my weight, I am. You know, I want to track it every day. So, um, if you click on the tab and just move it, you'll see a little black arrow there. That's where your positioning it. Um, same thing. Home inventory. Not really gonna visit that too often. I'm gonna move down here. My savings goals, though. Yeah, I use that quite a bit. Maybe life goals. Maybe I put my life goals first because I want I want to see it every day. I want to go in here and go. You know what? Like cause I tend to myself personally, it's just kind of look, And the further right I looked the last important it gets. I wanted front and center. So I want my life goals right up there for my budget track. My weight, uh, my savings goals, then maybe my travel cetera. And then the rest of this is maybe more of reference. Maybe gift ideas use a bit more than, say, in home inventory, etcetera. So that's it, guys. So we built a pretty cool personal productivity. An excel workbook. Um, and honestly, I guarantee you, this is almost exactly what I personally used in my own life. And then I have other tabs to that relate to stuff that's may be specific to my life. So what I'd encourage you to do is really just think about other stuff. Other ways you could use excel to track stuff, make your life better. So, uh, that is it, guys, 14. Course Conclusion: All right, guys, just to wrap up. And I kind of start to wrap up in that last video for life goals. So I apologize. There I realized I was kind of bantering on, but nonetheless. So now we have our workbook. Um, 123456789 10 ways to use Excel to sort of make your life busy. So, um, I kind of already reorganized them in case you didn't catch it. If you click on any tab and move it, you'll see a little black arrow. You can move a tab wherever you like. I'm already kind of sorted thes based on importance. Tender like sea life goals first, just so I can keep track of it, then budget way travel. And then you start getting a more reference type of of list, which is good. I mean, so now you have Ah, nice one stop list where you can come and really manage your life. You'd be surprised how often I use this file. I premature his mind daily whether it's entering. Wait, do editing my budget, Planning something out, maybe get a travel idea. Want to do maybe get a gift idea for somebody. I create an account on some X y Z website that I wanted to write down here. Um, you know, so lots of ways to use this hopefully have really found this useful. Um, I'm really excited for you guys. I'm God. And again you can download this exact worksheet as you see it. I'm attaching it to this video lesson. The course conclusion. Eso definitely. Go ahead. Download it. Make it your own final two points. One occurred. You check out all my other videos there. Sorry. All my other courses have several course ideas. Our search several courses on different ways. You can do things in excel. Lots of accounting and finance loss of entrepreneurial type courses. So I encourage you to check those out. And then, lastly, I love hearing your feedback. So if you can leave your review, um, I love hearing your feedback. Let me know what you thought of the course. Definitely. Anything I can do for you to get those five star reviews much appreciate it. And that is it. Guys. Thanks so much. And enjoy your sort of life. Dashboard personal productivity Workbook