Features

FIFA world Cup 2018 is approaching fast and I thought to share an Excel template that adds to the fun and excitement of the World Cup month. Use it to keep track of the dates & times of the games, input your predictions, make

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

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

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

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

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

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

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