[Excel Practice] 8. Advanced Filter & Macro_Filtering Problems?
Reference Videos
[Excel Practice] 7. Do You Really Understand Excel Filtering? _Comparison of Filtering Editing Tools_Auto Filter & Filter Function & Advanced Filter + Macro Comparison: • [엑셀실무] 7.너거들 엑셀 필터링 제대로 알고 있나?_필터링 편집툴 비교_...
49. Advanced Filter_Basics: • 49.고급필터_기초
50. Advanced Filter_Advanced: • 50.고급필터_고급
65. Understanding Macros: • 65.매크로_이해하기
66. Setting Up and Saving Macros: • 66.매크로_설정 및 저장
67. Playing with Macros: • 67.매크로_가지고놀기
68. Setting Up Macro Shortcuts: • 68.매크로_단축키설정
Mania Official Open KakaoTalk Room: https://open.kakao.com/o/gLti8djb
There are many skilled people in the chatroom. Come ask questions and hone your Excel skills.
Example file: https://blog.naver.com/pig075/2211997...
Sponsor: Kakao Bank 3333-05-8219282 Lee Yoon-ha
Individual inquiries and requests: [email protected]
(Online remote lectures, on-site lectures, small-scale tutoring for certifications, customized Excel data design and management for companies)
Timestamp
0:00 Start and Introduction
1:19 Advanced Filter_Start
1:28 Advanced Filter_Convert to Table
3:36 Advanced Filter_How to Enter Conditions
8:47 Advanced Filter_Applying Conditions
12:38 Macro Overview
14:30 Running Advanced Filters with Macros
16:33 Filtering Other Sheets
19:28 Running Macros Automatically