Advertisment
Convert PDF to Excel is so easy now! You don't need to copy and paste from PDF to Excel for further calculation work. This tutorial will teach...
Understand what a spreadsheet is, and what parts make it up.
In a spreadsheet there are three basic types of data that can be entered.
Views: 1418 | | by Stephen
MS Excel - Basics
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...
Probably the most popular function in any spreadsheet is the SUM function. The Sum function takes all of the values in each of the specified cells...
The average function finds the average of the specified data.
The MAX function in Excel will return the largest (max) value in the selected range of cells.
The MIN function in Excel will return the smallest (Min) value in the selected range of cells.
The Count function in Excel will return the number of entries (actually counts each cell that contains number data) in the selected range of cells.
The CountA function in Excel will return the number of entries (actually counts each cell that contains number data OR text data) in the selected...
The IF function will check the logical condition of a statement and return one value if true and a different value if false.
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...
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.
In Excel there is a help tool for functions called the Function Wizard. Learn how to easily use functions with the function wizard.
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...
Views: 1402 | | by Slicer
MS Excel - Basics
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...
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.
Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the...
We often need to format the numbers to display the appropriate number of decimals, dollar signs, percentage, red (for negative dollars), etc. It is...
A question that everyone (who has ever worked on a spreadsheet) has asked at one time or another is, 'Where did all my numbers go?' or...