Easy Explanation Notes with Examples

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

COLUMN function in Excel

Use The COLUMN function returns the column number against the given cell reference. For example, =COLUMN(B1) returns 2 which means B column is the 2nd column. Syntax COLUMN([reference]) The COLUMN function has the following argument: [reference] – Optional. The cell reference or a range of cell against which Excel returns the column number. If omitted, […]

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