 |
|
 |
Source Site » www.usd.edu
Search another site:
| Total: 22 | Showing: 15 | Page 1 of 2 |
 |
|
|
 Microsoft Excel / Getting Started Likewise, we can also insert rows. With the row label (number) selected you must choose the Row from the Insert menu. Again this will insert a row before the row you have selected. Site: www.usd.edu
|
||
|
|
Report |
|
|
|
Microsoft Excel / Getting Started Sometimes we (all) make mistakes or things change. If you have a spreadsheet designed and you forgot to include some important information, you can insert a column into an existing spreadsheet. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu -- Fill and Right. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the Column letter or a $ before the Row number (or both). This is called Absolute Positioning. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is called Fill Down. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Formulas are entries that have an equation that calculates the value to display. We DO NOT type in the numbers we are looking for; we type in the equation. This equation will be updated upon the change or entry of any data that is referenced in the equation. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started In a spreadsheet there are three basic types of data that can be entered. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started So let's get started digging into what makes a spreadsheet work. Spreadsheets are made up of,columns,rows,and their intersections are called cells.. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started This is a basic tutorial of Excel. START HERE Specific examples may refer to Excel (but most items discussed should work in other spreadsheets). Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula In Excel there is a help tool for functions called the Function Wizard. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Excel has most of the math and trig functions built into it. If you need to use the SIN, COS, TAN functions, they can be typed into any cell. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used for the car purchase in the first example. There are a few things that we must know in order for this function to work. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The next function we will discuss is IF. The IF function will check the logical condition of a statement and return one value if true and a different value if false. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula This tutorial describes CountA function. This will return the number of entries (actually counts each cell that contains number data OR text data) in the selected range of cells. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The function we will discuss is Count. This will return the number of entries (actually counts each cell that contains number data) in the selected range of cells. Site: www.usd.edu
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|