Home / admin (page 6)

admin

5.3. Changing the Width and Height of Cells

Changing the Width and Height of Cells 10

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 …

Read More »

5.2. Inserting and Deleting Rows and Columns

Inserting and Deleting Rows and Columns 8

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 …

Read More »

5.1 Moving and Copying Data in an Excel Worksheet

Moving and Copying Data in an Excel Worksheet 9

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 …

Read More »

4.8 Excel’s AutoSum Shortcut Key

AutoSum Shortcut Key 2

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 …

Read More »

4.7 Using the AutoSum Command

Using the AutoSum Command 6

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 …

Read More »

4.6 Adjacent Cells Error in Excel Calculations

Adjacent Cells Error in Excel Calculations 5

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, …

Read More »

4.5 Working with the COUNT() Function

COUNT() Function 2

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, …

Read More »

4.4 Working with the AVERAGE() Function

Working with the AVERAGE() Function 2

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 …

Read More »