MS-Excel - Functions and Formula Tutorials

Add/Subtract Months from a Date

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, and workbooks can be particularly difficult. Read more...

Return a Worksheet Name to a Cell

This tutorial shows how you can display the entire path of your worksheet in a cell using the CELL function. Then, a combination of the MID and FIND functions extracts only the worksheet name from the full pathname. Read more...

Extract Specified Words from a Text String

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

Display Negative Time Values

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

Sum Every Second, Third, or Nth Row or Cell

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. Read more...

Formulas and Functions Techniques

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. Read more...

Excel's Date and Time Features

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

Excel Formula & Functions Basics

Here we are going to learn some basics of MS-Excel Formula and Functions. When you copy a formula, Excel adjusts the formula's cell references when you paste it to a different location. Read more...

Excel Formula Tips

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

Using Ranges names 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. Read more...