Excel Tutorial – How to Sort in Excel, sort multiple columns, advanced sort

Contents

Video Tutorial


In this lesson we cover how to sort in Excel from an actuarial science perspective.
You’ll learn:
-sorting
-filter sorting
-advanced sorting (sort multiple columns)

Excel Sort Types

You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns. You can also sort by a custom list (such as Large, Medium, and Small) or by format, including cell color, font color, or icon set. Most sort operations are column sorts, but you can also sort by rows.

Excel Sort Criteria

Sort criteria for an Excel table are saved with the workbook so that you can reapply the sort to that table each time that you open the workbook, but sort criteria are not saved for a range of cells. If you want to save sort criteria so that you can periodically reapply a sort when you open a workbook, it’s a good idea to use a table. This is especially important for multicolumn sorts or for sorts that take a long time to create.

Reapply Sort

When you reapply a sort, different results may appear for the following reasons:
##Data has been modified, added to, or deleted from the range of cells or table column.
##Values returned by a formula have changed and the worksheet has been recalculated.

Like this content? Share with your friends!Share on linkedin
Linkedin
Share on facebook
Facebook
Share on twitter
Twitter
Share on stumbleupon
Stumbleupon
Share on tumblr
Tumblr