Home / admin (page 7)

admin

4.2 Working with the SUM() Function – Excel

Working with the SUM() Function 7

We are going to take-a-look at our first function those predefined calculations that are built inside of a cell. The first one that we are going to take-a-look at cell B8 is the SUM function. This is the most common most widely used function in all of Excel worldwide. Let …

Read More »

4.1 The structure of an Excel Function

The structure of an Excel Function

In the previous section of this book we talked about earlier, We began to talk about building calculations within Excel. And we saw just a simple little calculation rework, We were able to do some additions as far as referencing cells. We were able to take a cell reference such …

Read More »

3.7 Understanding the Order of Operation

Understanding the Order of Operation 10

Before we got into creating calculations inside of Excel I mentioned as long as you know what you want to do addition subtraction and multiplication division, so you understand the basics of the math. Excel does the rest for you but there is something else that we need to be …

Read More »

3.5 Creating Basic Formulas in Excel

Creating Basic Formulas in Excel 5

Now that we have got cell references at just kind of a high level an introductory level, I know some of you have been using them forever. Some of us are newer into the system. If you have got any questions on it again jump into the review section ask …

Read More »

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 »