Home / MS-Excel / Functions and Formula

MS-Excel - Functions and Formula Tutorials

MS-Excel Formulas
MS-Excel Formulas

Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of a second-order differential equation.

Evaluate a Text Equation
Evaluate a Text Equation

By using an old Excel4 macro function called EVALUATE in a special way, you can easily evaluate text equations (an equation formatted as text and interpreted as such by Excel) as actual calculations.

Count Words in a Cell or Range of Cells
Count Words in a Cell or Range of Cells

To get a word count of any cell or range of cells, we'll use a combination of SUBSTITUTE and LEN function/formulas.

Create Custom Functions Using Names
Create Custom Functions Using Names

Although referencing data by name is convenient, it's sometimes more helpful to store a constant value or even a formula, especially if you've been creating custom functions in VBA.

Make Your Formulas Increment by Rows
Make Your Formulas Increment by Rows

Excel's automatic incrementing of cell references works well most of the time, but sometimes you might want to override how it works.

Highlight Every Other Row or Column
Highlight Every Other Row or Column

You've surely seen Excel spreadsheets that have alternating row colors. For instance, odd-numbered rows might be white, while even-numbered rows might be gray. Conditional formatting makes this easy.

Use Replace to Remove Unwanted Characters
Use Replace to Remove Unwanted Characters

Using this tutorial, you can spare yourself the trouble of removing them by hand.

Validation Lists Change Based Selection Another List
Validation Lists Change Based Selection Another List

Validation needs can vary depending on the context in which the validation is used. However, you can create a spreadsheet in which one validation list changes depending on what you select in another.

Support Multiple Lists in a ComboBox
Support Multiple Lists in a ComboBox

When working with multiple lists, you can force a list to change by using a combination of option buttons plus a ComboBox.

Turn Conditional Formatting and Data Validation On and Off with a Checkbox
Turn Conditional Formatting and Data Validation On and Off with a Checkbox

Data validation can make it far less likely that a user will accidentally enter incorrect data. Sometimes, however, you might need to make it easier to enter data that otherwise would be flagged as incorrect by conditional formatting or blocked completely

Categories