Easy Explanation Notes with Examples

Create a drop-down list in Excel

Drop-down list in Excel is created to make sure that users select an option from a list instead of typing, hence chances of error may decrease and efficiency improve. 1- Type available options in another sheet. 2- On the first sheet, select B3 cell. 3- Go to the Data tab, in the Data Tools section, […]

Data validation in Excel

Data validation is a feature in MS Excel that ensures accuracy of input data. In this example, we will illustrate how the data validation feature work. 1- Select the cell in which you want to create a rule. 2- Go to the Data tab, in the Data Tools section, Select Data Validation. Or alternatively, press […]

How to remove duplicates in excel

In this example, you will learn how to remove duplicate values from a data set in Excel. Note: Whenever you remove duplicates, Excel delete them permanently. So before removing duplicates, a suggested way to save from a permanent delete is that copy the original data to another worksheet so that in case of an accidental […]

Text to Column (Split text into different columns in excel)

The Text to Column Wizard splits text into different columns. For example, you can split a list of full names into first and second name with separate columns. For this, do the following steps: 1- Select text to split into different columns. 2- Go to the Data tab, in the Data Tools section, select Text […]

Advanced Filter in Excel

In this example, we will illustrate how to use the advanced filter to show results based on a user defined criteria. To perform the advanced filter, you need to specify a list_range and a criteria_range. list_range – The range of cells that need to be filtered. criteria_range – The user defined criteria to be used […]

Date Filters in Excel

Previous lesson: Number and Text Filter in Excel In this example, we will illustrate how to use a date filter to display record that meet certain criteria. 1- Select data and type Alt + A + T. Or go to the Data tab, in the Sort & Filter section and select Filter. 2- Arrows will […]

Number and Text Filter in Excel

Previous lesson: Filter by color Number and Text Filter is used to display results that meet certain criteria e.g. show values greater than 500 or show only those rows that contain “specific text” etc. To execute the number and text filter, execute following steps: 1- Select data and press Alt + A + T. Or […]

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