Advertisment
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: 1407 | 
| 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...
Sometimes we (all) make mistakes or things change. If you have a spreadsheet designed and you forgot to include some important information, you can...
Likewise, we can also insert rows.
A detailed introduction to Adobe® ImageReady® animation tool.
A simple Linux vs. Mac comparison review.
This article is all about the pros and cons of web hosting companies - including the scams and some tips on how to avoid them. After reading this...
Are you preparing to get a website hosted but confused about who to get and what you need as far service goes? Read This! It will answer most of...
Ciara forum signature
Water in Cinema 4D
Hologram
Star Wars Hailfire Droid
Create a computer case model
CSS graphic menu with rollovers
XP Style Beaker Icon
Creating a Waterfall