3.4 Working with Cell References

Working with Cell References 2

Now before we get into creating some formulas there is something that I want to kind of recap. We have talked about it just a little bit and even just kind of in passing but it is a very important concept as far as formulas are concerned. Let us make …

Read More »

3.3 Entering Date Values in Excel

Entering Date Values in Excel 4

We have talked about two different types of data that you can input into an Excel document. There is actually a few more and I want to talk a little bit about one of the other types of data that you are going to be inputting into an Excel spreadsheet. …

Read More »

3.2 Working with Numeric Data in Excel

Working with Numeric Data in Excel 4

Next step in creating this Excel spreadsheet is to enter some numeric values some currency amounts for the amounts that we are spending for each bill across all the months. Inside this section in my case from cell B4 right below January inside rent from B4 down to D8, you …

Read More »

3.1 Entering Text to Create Spreadsheet Titles

Entering Text to Create Spreadsheet Titles

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 …

Read More »

2.10 Common Excel Shortcut Keys

Common Excel Shortcut Keys

One of my goals within this book dealing with Microsoft Excel is to help you not only learn the application and learn the various features in there but to become as efficient as possible as you work and master Microsoft Excel. one of the best ways to become more efficient …

Read More »

2.9 Opening an Existing Excel Document

Opening an Existing Excel Document

How about opening the existing documents, you have already been working inside of a cell. You have saved a document perhaps on your local computer network drive wherever. Now You want to be able to open up that document and continue working with it. Well this just like saving it …

Read More »

2.8 Saving an Excel Document

Saving an Excel Document

After you create a new workbook, you do not have any data in there just yet Now You want to save it to my computer or save it out to the network drive whatever it might be. So inside of Excel You are just going to go to my final …

Read More »

2.6 More on the Excel Interface

Excel Interface

Let us further our lesson about the Excel interface itself. There is a few more things that I want to point out here. We have seen that quick access toolbar you have got your ribbon directly below that there is the ribbon, you have got the name box in the …

Read More »