Easy Explanation Notes with Examples

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 […]

Filter by color in Excel

See first: How to filter in Excel? To filter by color, execute the following steps: 1- Select the data and press Alt + A + T. Arrows will appear in columns’ header. 2- After clicking on an arrow, filter menu will open. 3- On the filter menu, press I or go to the Filter by […]

How to filter in Excel

Filter in Excel is a feature, used to show the relevant information quickly from a whole data. For example, if you have sale data across the globe, through the filter you can find out quickly sale made in the UK during the specific tenure. In this article, we will illustrate the use of the filter […]

Sort by dates in Excel

While working on Excel, you may confront a situation where you need dates in order however data is in raw form. To sort by dates (oldest on top or newest on top), execute following steps: 1- Select data from a column you want to sort. 2- In the Home tab, under Sort & Filter, click […]

Sort by Color in Excel

In this example, we will illustrate how to sort by color. 1- Click on any cell inside the data set. 2- On the Data tab, click on Sort in the Sort & Filter section. Short key alert: Press Alt + A + SS to do the same. 2- On the appeared box, Sort by date […]

Sort data in a range or table

Sort is a feature in Excel, through which you can sort your data in following manners: A to Z (Alphabetically) Z to A Smallest to Largest or Largest to Smallest Oldest to Newest or Newest to Oldest e.g. sort by dates Color Custom (Own choice) Sort by (One column) You can sort data either in […]

COLUMNS function in Excel

Use The COLUMNS function uses to find out the number of columns in a selected array or reference. For example, =COLUMNS(D2:F3) returns 3, because the range D2:F3 contains three columns. Syntax COLUMNS(array) The COLUMNS function has the following argument: Array – Required. A reference to a range of cells for which to want the number […]

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