filmov
tv
Data Sorting & Filtering in Excel (Basic + Advanced) | FREE Excel Course
Показать описание
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.
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.
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.
⚙️ Gear I Recommend:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
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.
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.
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.
⚙️ Gear I Recommend:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Комментарии