How to SORT Data in Excel | 7 Tips скачать в хорошем качестве

How to SORT Data in Excel | 7 Tips

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 identify numbers st...   LinkedIn Article https://www.linkedin.com/posts/chris-... And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://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!