MS-Excel - Functions and Formula Tutorials

This tutorial shows how you can display the entire path of your worksheet in a cell using the CELL function.

In this tutorial, we'll show how to extract the last word, the first word, and the nth word from a string of text.

Sometimes you want to display negative time values, but Excel will only display ######. There are several ways to escape this problem.

Every now and then you might want to sum every second, third, fourth, etc, cell in a spreadsheet. Now you can, with the following tutorial.

Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets.

Excel's date and time feature is great if you're creating simple spreadsheets, but they can cause problems for more advanced projects.

Here we are going to learn some basics of MS-Excel Formula and Functions.

In this section, we are going to show you a few tips for formulas.

Range names are extremely useful not only for documenting the function of the formulas in your worksheet, but also for finding and selecting cell ranges quickly and easily.

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