UrbanPro
true

Learn Business Analytics Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Data Sorting In Excel

ITech Analytic Solutions
03/01/2018 0 0

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.

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

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Be FOCUS !!
We must be very focused about learning & Goals. While learning please check your progress and take feedback at various level. Try Again & Again & Again !!! Deepak Garg

Big Data & Hadoop - Introductory Session - Data Science for Everyone
Data Science for Everyone An introductory video lesson on Big Data, the need, necessity, evolution and contributing factors. This is presented by Skill Sigma as part of the "Data Science for Everyone" series.

Learning excel complex function by using simple steps
Step 1: Understand and practice the individual excel functions thoroughly Step 2: Split the problem statement into N number of small pieces. Step 3: Use individual functions to solve the small piece...

What Is SPSS Software (SPSS Data Analysis Tool) ?
SPSS is a Windows-based program that can be used to perform data entry and analysis and to create tables and graphs. SPSS is capable of handling large amounts of data and can perform all of the analyses...

Approach for Mastering Data Science
Few tips to Master Data Science 1)Do not start your learning with some software like R/Python/SAS etc 2)Start with very basics like 10th class Matrices/Coordinate Geometry/ 3) Understand little bit...
X

Looking for Business Analytics Training Classes?

The best tutors for Business Analytics Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Business Analytics Training with the Best Tutors

The best Tutors for Business Analytics Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more