18,763 views
Excel, this! Advanced filter + macro, about its simplicity! The key is to recognize the list and how to use AND, OR! Example files can be downloaded from the blog below. https://blog.naver.com/excings/222121... Everyone be happy. Excel- [BASIC-EASY-SIMPLE] Excel practice! Just remember this! There are so many books on the market, online, and offline! What should I look at? Now is the HOW-WHERE era! We live in an era where we need to know where to find information to be competitive. In that sense, you have come to the right place. I am a 13-year MD! Tutor ENGINE. I have collected only the core functions and features that I have used in practice. And studying should be fun. I will prepare a lecture so that you can learn FUN, BASIC, EASY, easy to learn, and SIMPLE simply! Thank you! #Excel #ExcelBasics #OfficeWorkerExcel #BASICExcel #ExcelFunctionBasics #EXCEL #LearnExcelBasics #ExcelNestedFunctions #LearnExcel #LearnExcelBasics #BasicExcel #ExcelBasicFunctions #ThisExcelOnly #PivotTable #ExcelBeginner #LearnNestedFunctions #ExcelBASIC #EXCELBasics #BASICEXCEL #VLOOKUP #XLOOKUP, #DataInput, #IFFunction, #SUMIF, #SUMPRODUCT, #MID, #RIGHT, #LEFT, #LEN, #FIND, #OFFSET, #DataValidation, #MultipleDataValidationCheck #EXCELBASIC #EXCELMULTIPLE #REPLACE #LENFunction #INDEXMATCHNestedFunction #INDEX #MATCHFunction #OvercomingVLOOKUPFunctionLimitations #INDEXMATCHLogic #SUMIFSFunction #Multiple condition function #Creating an Excel table #Creating a table #INDEXMATCH nested function #Nested function #XLOOKUP wildcard #Wildcard #XLOOKUP sort #XLOOKUP find last value #Define name #Import image #INDEXMATCH already loaded #Creating a table #Creating a quotation #Advanced filter #Macro