Fun in the Sum

Offset Function

The offset function starts with a reference cell and returns a value a specified number of rows and columns away from the reference.  For Read more...

Sum

The sum function sums all the values in a data set or array.

=SUM(A1:A3)

Equation 2‑6

In Equation 2‑6, the Read more...

Introduction to Formulas

Writing formulas in Excel allows the user to perform calculations, evaluate logic functions and look up values.  These operations all share a few commonalities.  Read more...

And Statement

And Statements are a logic function that evaluates two or more logical expressions simultaneously.  If all logical expressions contained within the And Statement are Read more...

Or Statement

The Or Statement is similar to the And Statement, but with one difference.  In order for an And Statement to produce a True result, Read more...

Vlookup

Vlookup Function

The Vlookup function matches a reference value to a value in the first (left-most) column of a data table and returns a value Read more...

Cursor Movement

Using the arrow keys in Excel, allows the user to move from one cell to another.

CTRL – By pressing the control key while Read more...

Accessing the Ribbon

Excel 2007 allows easy access to the Ribbon from the keyboard.  When the ALT key is pressed, Excel displays the letters, Key Tips, corresponding Read more...

Introduction to If Statements

If Statements

If statements are a logic function that chooses between two options based on the result of a logical expression.  If statements can be Read more...

Right and Left Functions

The Right function returns a specified number of characters from a string of text starting from the right hand side. It requires two inputs: Read more...