Lesson 24: How to SORT data in ASCENDING order in Excel

In this lesson, I’m going to be showing you how to:

  1. Sort data in ascending order in Excel

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 25: Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Or go back to:

Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22: How to RENAME a worksheet in Excel

Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

12 thoughts on “Lesson 24: How to SORT data in ASCENDING order in Excel”

  1. Excel seems to be a very useful tool. It has a lot of useful functions and experts like yourself can always show us how to use it. Just curious, do the sheets in Google drive work have the same user functions as excel?

    • Thank you Ekufaa. Google sheets comes nowhere near as excel in terms of its complex functionality available. However, Google Sheets is free to use, so one cannot really complain. Hope this helps 🙂

      Habib (ICT Tutor)

  2. Hi Habib,

    Thanks for this useful tip to sort data in excel. I must admit that I make the number in an ascending order one by one before I watch your video, and it saves me tons of time now. Will love to come back for more videos from you.


    • Oh gosh Matt – that gives me pain hearing you used to do it manually. Now you know, you can sort and order with a few clicks 🙂

      Habib (ICT Tutor)

  3. I always found sorting data harder to do, but I am glad you covered this in your tutorial. Now it is much clearer to me! I will keep on following your tutorials, to refresh my Excel skills 🙂
    Thank you!

  4. Excellent tutorial on sorting. I will have to start using this, it will be a time saver. Thank you for cautioning us about using the first method when having totals or other data that might not fit into the sorting data.

  5. Excel really is a great tool. It’s pretty amazing to learn everything you can do with it. I didn’t know how to sort data in ascending order, so this was another great tutorial for me!

    • Sorting data in excel is the key to organising your spreadsheets as you wish – whether it is in ascending or descending order. Excel is amazing 🙂

      Habib (ICT Tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap