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...
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...
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...
Sometimes you want to display negative time values, but Excel will only display ######. There are several ways to escape this problem. Read more...
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 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 feature is great if you're creating simple spreadsheets, but they can cause problems for more advanced projects. Read more...
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...
In this section, we are going to show you a few tips for formulas. Read more...
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...