Entering Text to Create Spreadsheet Titles
- During the next few sections we are going to be building our very own Microsoft Excel spreadsheet.
- We are going to start out which is the completely blank worksheet and we are going to build up a monthly budget spreadsheet.
- We are going to start out just simple take it step by step.
- We are going to do things like enter labels like our column in our real labels.
- We are going to enter some numeric values in there representing our dollar amounts are currency values.
- The harder money that we are spending each and every month on all of our bills we will talk about building calculations.
- We get things like totals for each month or each bill while talking about some other types of calculations as well.
- We are going do some formatting we are going to make it look super awesome but we are going to start from complete scratch.
- So, our first step we have got to open up a new Excel document and we are going to start to put some labels or headers into our spreadsheet.
- Now occasionally I just really want to give you a heads up if you are also a part of the Office 365 subscription, Microsoft likes to push out updates now as of this recording that is February of 2019.
- When you open it up your interface might look a little bit different because Microsoft pushes out updates, So nothing big.
Once again if you are on the office 365 you may occasionally when you first launch up Excel you may get a yellow bar at the top of your screen saying hey Microsoft got some updates ready for you do you want to go ahead and update and they’ll give you a button right there to build update. I am not getting it right now and we may see it at some point within this book as I close and I reopen excel and Microsoft may be pushing out updates but just keep an eye on that instead of your own interface updates are great, Microsoft is fixing dance creating new features for you, it is huge.
So, typically we start out and set a Cell a one within our new worksheet and there is a one what better place to put a title.
So, I am going to go ahead put a title, I will call this Monthly budget. This is going to be our Monthly budget spreadsheet.
I am just inside a column a row one type that value, I mean hit my Enter key on my keyboard that will haunt me out of the Cell.
For now we are just going to put some labels in there and start to build the basic structure of our spreadsheet.
I am going to create a column here that is going to act as the labels for all of the bills that I have for each of the months.
And now I am going to create a list. Nice little column here of various bills that I have for each month.
Now you can copy me exactly if you like to, hopefully you are following along with me right you copy the exact same stuff if you like. But I want to encourage you, one of the best ways to learn something new is not only participate in a book like this and to learn but to put it to practice.
The sooner that you can start to put this into your own real-world scenarios the better off you are going to be.
I am going to call good right there of book I have got more inside there may want to put car in there. You got electricity gas you got garbage water you got this that and the other thing.
Let us go and create a list there and eventually we are going to start to put in the values for each of the months that we are spending on these various bills start to start to make it feel kind of bad where all your money is going right.
That is going to give us some totals for the various months that we will have for each of our bills.
So, these are you real headers your real labels.
Hit Enter key to go to next row
Het Tab key to go to next column
Let us go out and continue building the structure, jump up into cell B3.
You are just clicking up there and I mean to put some labels up here for each of the months.
Keep it really simple if you’d like you can continue going right the more practice you get the better
We have got that one right there because eventually we are going to have some a row total here for each column but then I am going to have one here because I want to do totals for each of the bills as well
This is this is kind of the basic structure of a spreadsheet you have got real labels in this case bills you have got column labels representing some type of date now there is our basic structure our labels and these are just text values.
We are going to start to talk about entering numeric values and putting some currency amounts inside of these months for these bills so get that done we will jump into the next section.