Formula and Function

For making numeric data readable, there's nothing like a chart -- but chances are, your coworkers or clients are sick of seeing the same old bars, columns, and pies. Whether changing columns to cones or adding stylish backdrops and pictographs, here's how to create Excel charts that stand out.

Sure, Microsoft's spreadsheet provides plenty of built-in functions -- but none for performing multiple conditional tests for manipulating just a subset of your data. Instead of breaking down these custom calculations into multiple steps, learn about Excel's array formulas and do sophisticated data analysis with no sweat.

n Microsoft Excel, you can enter numbers as labels or as values. Labels are alphabetic, alphanumeric...

In Microsoft Excel, you can enter numbers and mathematical formulas into cells. When a number is entered into a cell...

The following exercises demonstrate how to perform mathematical calculations...

The AutoSum icon on the Standard toolbar automatically adds a column of numbers. The following illustrates the SUM function...

If you have automatic calculation turned on, Microsoft Excel recalculates the worksheet as you change cell entries...

Reference operators refer to a cell or a group of cells. There are two types of reference operators, range and union....

Microsoft Excel has a set of prewritten formulas called functions. Functions differ from regular formulas in that you supply the value but not the operators....

See tip link for description.