The next topic that I want to get into is a common question that I get since I make Excel trainings. This deals with changing the width of a column and the height of a row. this shows up in various questions that I get for many different reasons. One …

We have seen a little bit of copy and paste. what about adding additional rows and additional columns into an already built spreadsheet. If I want to introduce an additional bill into my monthly budget. You can do this a couple of ways. There are a few things that we …

During this section we are going to talk about modifying Excel worksheet, modifying the spreadsheet. We will also talk a little bit about modifying the workbook structure, such as adding and deleting worksheets within the workbook. First let us talk a little bit about moving and copying content, talk about …

So I want to show off one more item here and this is something. that I use all the time when I am dealing with calculations inside of Excel. And for that matter there is other scenarios outside of calculations that I use this for as well. It is a …

We are talking about the AutoSum I gave you a couple of ways to do it, You can do it on a single cell, Hit the AutoSum button. You could select a range of cells and use the AutoSum. That takes us back to the discussion about relative references, because …

At the beginning of this section we started talking about functions in general, and then we got into some function, and I mentioned early on that we are going to start out by doing things the long way. First, we really started out by building a calculation that was like …

Let us pause for just a moment and kind of move away from using functions. I want to show something off here because it is a common question that I get at this point within this Excel training. If you take-a-look at spreadsheet, we got some row labels with bills, …

Let us look at one more of the basic functions built into Microsoft Excel. We have looked at some Min, Max an Average. Let us now take-a-look at the COUNT function. I am back inside of my Excel document (Mothly Budget). I am going to drop down just into A14, …

Let us take-a-look at another basic Excel function. We just got done looking at the SUM function and the Min, the Max function. Let us now take-a-look at the average function. Now you think of average, What’s type of math goes into completing an average. I want to be able …

The next two functions that we are going to take-a-look at here are pretty common as well. Perhaps not as common as some function but you are going to see these two pretty often inside of Excel documents. We are going to look at the built in Min and Max …