Excel has a powerful SORTING engine. SORT is the most popular function in Excel, and it can sort by many types of data, many attributes and even custom sorting configurations. In this video, I walk you through 7 major SORT function tips and procedures. We look at how to ensure the data is ready to sort, selecting the appropriate sorting range, and making sure there are no blank rows or columns.
Then we sort in Excel by one column, multiple columns, by color, by date, custom sorting, and also sorting mixed data, ensuring that if we have numbers and numbers stored as text, we can correct that and still sort the data properly.
Chapters:
00:00 Introduction
00:46 Check your data
02:05 Sort by one column
04:31 Sort by multiple columns
06:47 Sort by color
09:03 Sort by month
09:59 Custom sort
12:24 Sort mixed data
16:11 Closing remarks
Identify Numbers stored as Text in Excel:
• Excel - 5 easy ways to...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ RU-vid keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
5 июл 2024
