Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest.

To Sort the data follow the steps mentioned below.

Select the Column by which you want to sort data.
Choose Data Tab » Sort Below dialog appears.

If you want to sort data based on a selected column, Choose Continue with the selection or if you want sorting based on other columns, choose Expand Selection.
You can Sort based on the below Conditions.
Values − Alphabetically or numerically.
Cell Color − Based on Color of Cell.
Font Color − Based on Font color.
Cell Icon − Based on Cell Icon.

Clicking Ok will sort the data.

Sorting option is also available from the Home Tab. Choose Home Tab » Sort & Filter. You can see the same dialog to sort records.

Using Ranges in Excel

Ranges in MS Excel

A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is identified by its address, which consists of its column letter and row number. For example, cell B1 is the cell in the second column and the first row.

A group of cells is called a range. You designate a range address by specifying its upper-left cell address and its lower-right cell address, separated by a colon.

Example of Ranges −

C24 − A range that consists of a single cell.
A1:B1 − Two cells that occupy one row and two columns.
A1:A100 − 100 cells in column A.
A1:D4 − 16 cells (four rows by four columns).

Selecting Ranges

You can select a range in several ways −

Press the left mouse button and drag, highlighting the range. Then release the mouse button. If you drag to the end of the screen, the worksheet will scroll.
Press the Shift key while you use the navigation keys to select a range.
Press F8 and then move the cell pointer with the navigation keys to highlight the range. Press F8 again to return the navigation keys to normal movement.
Type the cell or range address into the Name box and press Enter. Excel selects the cell or range that you specified.

Selecting Complete Rows and Columns

When you need to select an entire row or column. You can select entire rows and columns in much the same manner as you select ranges −

Click the row or column border to select a single row or column.
To select multiple adjacent rows or columns, click a row or column border and drag to highlight additional rows or columns.
To select multiple (nonadjacent) rows or columns, press Ctrl while you click the row or column borders that you want.

So, this brings us to the end of blog. This Tecklearn ‘Data Sorting and Using Ranges in Excel’ blog helps you with commonly asked questions if you are looking out for a job in Microsoft Excel. If you wish to learn Excel and build a career in Business Intelligence domain, then check out our interactive, Microsoft Power BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Microsoft Power BI Training

Microsoft Power BI Training

About the Course

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

Why Should you take Microsoft Power BI Training?

The average annual pay for a Power BI Professional is $114,000 . -PayScale.com.
Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc, Brillio and 45,000 MNCs across 185 countries use Power BI and it has a market share of around 7% globally.
Microsoft Power BI has been ranked at No.1 position in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 13 consecutive years.

What you will Learn in this Course?

Introduction to Microsoft Power BI

Microsoft Power BI Introduction
Power BI Products
Power BI Architecture
Installing Power BI
Connecting to Data Sources

Power BI Workflow

Key features of Power BI workflow
Power BI Vs MSBI
History of Power BI
Power BI Products
Data modelling and relationships

Power Query for Data Transformation

Power Query for Data Transformation
Learning about Power Query for self-service ETL functionalities
Working with Excel data
Introduction to Query Editor
Data transformation
Pivot and UnPivot
Merge Join, relational operators, date, time calculations, working with M functions
Summary Tables
Writing custom functions and error handling
M advanced data transformations

Filters and Drill Down Report

Visualization Filter
Page Level Filter
Report LEVEL Filter
DRILL Through Filter or Report
BookMark Report

Power Pivot for Data Modelling

What is SSAS
Data Modelling
Star Schema
Snowflake Schema
Introduction to MDDB and Tabular
Data Access Modes
Tabular with DAX
Power BI with DAX
DAX Functions

Data Analysis Expression – DAX Queries

TABULAR with DAX
Power BI with DAX
Calculated Members, Row, Filter & Evaluation Context
Cumulative Charts
Calculated Tables, ranking and rank over groups
DAX advanced features

Power BI Desktop & Administration

Reports and Visualization
Learning about data modelling and data relationships
Deploying data gateways
Reports and Dashboards
On Premises Data Gateway
Gateway Clusters

Introduction to Power Q & A

Power Service
Power Q & A best practices
Integrating with SaaS applications
Gateway

607