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
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
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 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
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
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
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.7 Understanding the Structure of an Excel Workbook
Let us take a closer look at the Excel workbook and really what makes up the Excel workbook interface. Excel workbook or the workbook type is your main excel file, that is where you are going to be working in. In the Excel workbook but you have got what is …
Read More »2.6 More on the 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 »2.5 Customizing the Excel Quick Access Toolbar
A neat tool that is kind of lesser known kind of hidden but a neat tool. This is the quick access toolbar it is part of the Excel interface and it is been around since the 2007 edition of Excel. The quick access toolbar The quick access toolbar is …
Read More »