Features

Excel Custom Data Validation

Check for text, numbers & length Excel Custom Data Validation Custom data validation is especially useful when the normal data validation criteria options are insufficient, this way, formulas can be used to define the restrictions.   TIP: Since the formula text box in the

Data Validation in Excel

Should you include these in your files? Data Validation in Excel Excel’s Data Validation feature ensures that the data collected is clean and to minimize the errors and hence the time it takes to correct them.  This is especially helpful when multiple

Excel Filter: Basic to Advanced

Filter Basics First Excel's AutoFilter is a great feature to quickly display the rows in your data table that meet a certain criteria. The remaining rows that don't match your criteria are automatically hidden. Once you have your selection in view, you can edit

Conditional Format Index Match Result

Highlight the lookup value in Excel Excel Conditional Formatting the Index Match result in a data table In some cases, it would be a good idea to highlight the result of the Index Match lookup formula inside the original data set based

Excel Solver example and step-by-step explanation

Handle complex data models and solve for the optimal solution. Excel Solver example and step-by-step explanation Excel’s Solver tool can do complex statistical modeling. There are many ways to benefit from it when you want to manipulate multiple cells to get

Excel Goal Seek Explained in Simple Steps

Find the required numbers to achieve a target value. Excel Goal Seek Explained in Simple Steps In cases where you have a target value that is derived from a formula and you need to find the required numbers to achieve it, Excel’s

How to Set a Default Theme in Excel

Set your default Excel theme to the theme of your choice. How to Set a Default Theme in Excel When you create a new Excel workbook, you'll notice that it always reverts to the Office theme color by default.   However, in some cases, you might