MS-Excel - Functions and Formula Tutorials

Operators in MS-Excel Formulas

An operators is the basic element of a formula. An operator is a symbol that represents an operation. Read more...

Working with Excel Lookup Functions

In this tutorial, you get a chance to practice creating formulas that automate table lookup, including looking up a single value.... Read more...

Date and Time Formulas in Excel

Formulas that perform calculations between elapsed dates and times are quite common in spreadsheets. In this tutorial give you a chance to build formulas that calculate the difference between starting. Read more...

Excel Counting and Summing Worksheet Cells

A summing formula returns the sum of the values of the cells in a range that meet certain criteria. The range you want counted or summed may or may not consist of a worksheet database. Read more...

Excel Function Argument Types

In this tutorial, you will notice that all the functions use a set of parentheses. Read more...

Excel Formula Shortcuts

You have learned how to build a formula by entering it manually. That's a good way to start out because it forces you to understand the basics of formula writing. Read more...

Errors in Formulas

It's not uncommon to enter a formula only to find that the formula returns an error. In this tutorial types of error values that may appear in a cell that has a formula. Read more...

Calculating Formulas

You have probably noticed that the formulas in your worksheet get calculated immediately. If you change any cells that the formula uses, the formula displays a new result with no effort on your part. Read more...

Logical Functions in Excel

This tutorial will teaches you how to use Logical Functions in Excel. Logical Functions is an Independent and Confidential Management Consulting, Marketing and Design Firm Focused on Individual Customer Solutions. Read more...

Formulas in Excel

This tutorial will teaches you how to use Formulas in Excel. Following: Calculate the age of a person in days (A worksheet lists the names of friends in column A and their birth dates in column B. Read more...