Easy Explanation Notes with Examples

How to use Goal Seek in Excel for What-If analysis

What is Excel Goal Seek? If you know a final value that a formula produces but does not know the input value to be used in that formula to get the final value, use the Excel Goal Seek built-in feature. For example, suppose you sold Product A for 5$ each and earned a profit of […]

Consolidate in Excel

To consolidate data from different sheets into a one master sheet, execute the following steps: 1- Make sure that source data is arranged correctly. If you want the Excel’s consolidate feature to work accurately then ensure that each sheet has a similar layout, in which each column should contain similar data along with the header […]

How to limit text length in excel

Main Lesson: Data Validation in Excel To restrict a user to enter a limited text length, execute the following steps: 1- Select the range of cells A3:A7. 2- In the Data tabs, from the Data Tools section, select the Data Validation. 3- From the appeared Data Validation box, select Text length from the Allow option, […]

Data Validation: Restrict to enter dates between two dates only

Main Lesson: Data validation in Excel To restrict a user to enter dates between two dates only, use the Data Validation feature. In this example, we will illustrate, how to restrict to enter dates between two dates only. For this, execute the following steps: 1- Select a range of cells where you want to apply […]

Dependent Drop-down Lists in Excel

Main Lesson: Data Validation in Excel Earlier, we have learned how to create a drop-down list in Excel. in this example, we will illustrate the use of dependent drop-down lists that display choices depending on the value selected in the first drop-down menu. Once you have created a simple drop-down list, execute the following steps […]

Add Input Restrictions to Validate Data

Main Lesson: How to do Data Validation in Excel? In this example, we will illustrate how to add input restrictions to validate data. We will make the following restricts: starts with letter S and followed by 6 numbers only. 1- Select a range of cells (A2:A7). 2- Press Alt + A + V or alternatively, […]

Prevent Duplicate Entries in Excel

Main Lesson: Data Validation in Excel In this example, we will illustrate how to prevent duplicate entries using the data validation feature. 1- Select range of cells (A4:A23). 2- Press Alt + A + V or alternatively, go to the Data tab, in the Data Tools section, select Data Validation. 3- The Data Validation box […]

Copyright © 2016 - 2019 Explainry.com | All Rights Reserved