14,019 views
???? LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... ???? DOWNLOAD FREE SPREADSHEET: https://excelentejoao.com.br/wp-conte... In this Excel video lesson, we will learn how to connect different spreadsheets in Excel. We will basically filter information from one spreadsheet to another using an advanced filter tool in Excel that helps us filter information from a database or table in Excel Following the criteria that we define in our filter. In this Excel video lesson, we will learn how to build an advanced filter in Excel. Every time you click the filter button automatically, your entire database will be filtered interactively and dynamically. Let's learn in practice and step by step in this free Excel tutorial. We will learn how to make an advanced filter in Excel from a search field in Excel. We can type the terms we want to filter and our Excel table will be automatically filtered whenever we click on the Excel dynamic button. We can use several criteria to filter our database. We can use several different conditions. We can filter by unique values or even combine filters to create an advanced filter in the Excel spreadsheet. The first thing we need to do is have a database in Excel, a table in Excel, a spreadsheet with information that we will use in our advanced filter. The second thing we need to do is enable the developer tab so that we can automate tasks in Excel in order to create a macro. How to create a macro in Excel is very important, because the macro can help us automate tasks. This way, we can save time with Excel and automate tasks and processes. The macro saves all the buttons we press, all the clicks we make, and all the buttons we press in Excel. Now, we just need to create a header so that it can be our filter in Excel. We will use it as a dynamic and automatic search field in the Excel spreadsheet. After that, just use the Excel tool called advanced filter. And from this tool, we will be able to automate filters in Excel, that is, instead of filtering information manually, we can use this advanced and automatic filter so that all information in the spreadsheet is filtered automatically. #ExcellentJoão #Excel #Dashboard