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 Goal
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
Use Custom Formatting instead of Conditional Formatting in Excel. Smart Uses of Custom Formatting We normally use custom formatting to show numbers with thousand separator, as percentage or even to show green for positive and red for negative values. But we hardly
Smart Uses of Custom Formatting - Part 2 Explore the possibilities of Custom Formatting with Part 2 of our guide. If you missed it, check out Part 1. CHAPTER 4: Any Symbol of your choice for Deviations