تقييمات الطلاب
( 5 من 5 )
١ تقييمات
فيديو شرح Data Sorting & Filtering in Excel (Basic + Advanced) FREE Excel Course ضمن كورس اكسيل المحاسبي شرح قناة TrumpExcel، الفديو رقم 19 مجانى معتمد اونلاين
This video covers all the basic and advanced concepts about data sorting and data filtering in Excel.
It starts with the absolute basics and covers advanced examples.
It covers the following topics:
-- Data Sorting (by name, text, color, icon and custom list)
-- Multi-Levels of Sorting
-- Data Filter (by text, number, date, and color)
-- Advanced Filter in Excel
-- Filtering and Sorting in Excel Data Tables
Excel has a lot of sorting options such as sorting from left to right, sorting based on color and icon and doing multi-level sorting. All these sorting options can be accessed from the single sorting dialog box.
Similarly, you have a lot of filtering options - such as filter based on numbers, text, dates and even colors.
Excel has many data analysis functionalities and a good knowledge of filtering and sorting data in Excel will help you analyze a huge amount of data easily.
Download File - https://trumpexcel.com/course-downloa.
If you find the videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?vUPABcYhugZk&listPLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).
This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial