Ms Excel All Filter Option. এক ক্লাসে সকল ফিল্টার অফশন।

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 ก.พ. 2024
  • #MsExcel #HomeTab #FilterOptions
    Hi, thanks for watching our video about Ms Excel All Filter Option
    In Microsoft Excel, the filter option is a powerful tool used to display only the data that meets certain criteria, while hiding the rest. This feature is particularly useful when working with large datasets and you need to focus on specific information.
    Here's a step-by-step description of how to use the filter option in Excel:
    Select Your Data: Click on any cell within the dataset you want to filter. If your data has headers, make sure they're clearly labeled.
    Open the Filter Menu: Go to the "Data" tab on the Excel ribbon. In the "Sort & Filter" group, you'll see the "Filter" button. Click on it. Alternatively, you can right-click on any cell within your data and choose "Filter" from the context menu.
    Filter Dropdown Arrows: Once you've clicked the "Filter" button, you'll notice small dropdown arrows appear next to each column header in your dataset.
    Filtering Data: Click on the dropdown arrow next to the column you want to filter. You'll see a list of unique values in that column. You can either select specific values you want to include or exclude, or you can use search functionality to find specific values.
    Apply Filter: After selecting your filter criteria, click "OK" or "Apply" to apply the filter. Excel will hide the rows that don't meet your specified criteria, showing only the rows that match.
    *Clearing Filters: *To remove the filter and display all the data again, simply go back to the column with the filter applied and click on the dropdown arrow. Then, select "Clear Filter" or "All" to clear the filter for that column. You can also clear all filters at once by clicking "Clear" in the "Sort & Filter" group on the "Data" tab.
    Filtering by Multiple Criteria: You can apply filters to multiple columns simultaneously, allowing you to refine your dataset further. For example, you can filter by one column and then further refine the results by applying filters to other columns.
    Using Excel's filter option can help you quickly analyze and manipulate your data, allowing you to focus on the information that's most relevant to your needs.
    ---------------------------------------------------
    CHECK OUT OUR OTHER VIDEOS
    • Muzhey Kupah Waloo Mus...
    • The Beautiful Prayer o...
    • জানাযার নামাজের নিয়ম ن...
    ---------------------------------------------------
    FIND US AT
    www.tc-computer.com
    ---------------------------------------------------
    GET IN TOUCH
    Contact us at info@company.com
    ---------------------------------------------------
    FOLLOW US ON SOCIAL
    Get updates or reach out to Get updates on our Social Media Profiles!
    ---------------------------------------------------
    Twitter: / tc_nasir
    Facebook: / nasirit52fr
    Instagram: / nasirit52fr
    Telegram: t.me/Tctlg
    linkedin: / md-nasir-uddin-tc-comp...
    Pinterest: / nasirbasir06
    Spotify:
    ---------------------------------------------------
    ---------------------------------------------------
    About🧡Tc-Computer💛Education
    Our channel is about computer Technology and other educational Topics. We cover lots of cool stuff such as Technology, Islamic Content, Graphic Design, And Web Design. First of all I request you, subscribe to our TH-cam channel and click the bell icon. "TC-Computer Education" Click the link to visit our channel. / @t-computer
    ---------------------------------------------------
  • วิทยาศาสตร์และเทคโนโลยี

ความคิดเห็น • 1