In this video learn about:
(00:14) Introduction to Advanced Filter
1. (02:50) Extract Records based on AND Logical Test (AND Criteria). Comprehensive Example including Defined Names that are created and how to run the Advanced Filter a second or third time.
2. (09:48) Extract Records based on OR Logical Test (OR Criteria)
3. (10:39) Extract Records based on “Contains” Criteria (“Partial Text” Criteria)
4. (12:00) Advanced Filter with Complex Criteria
5. (13:00) Advanced Filter Extract to Different Sheet. Extract Data for a given year. See how to create formulas to create criteria base on year. See the functions, DATE and TEXT.
6. (18:00) Advanced Filter to get a Unique List from Column
7. (19:53) Advanced Filter with Helper Column Formula to Create Table Report with Professional and Neat Formatting and Page Setup. See the functions: AND and SEARCH.
8. (29:32) Advanced Filter with Formula Criteria on Large Data Set to Create Report
Xem thêm bài viết khác: https://issep2014.org/cong-nghe
Xem thêm Bài Viết:
- 7 GOPRO 7 quá KINH KHỦNG TỞM ✅
- ✅ DESCARGAR ADOBE READER XL ¡GRATIS! | 32 y 64 Bits | En Español + Licencia De Por Vida 2020
- Dịch từ Anh sang Việt – file PDF bằng Foxit Reader – Install Foxit Reader & translate PDF
- How to download any pc software full version free || Crack Any latest 2020 Software Free Download.
- Pdf files – full working facilities Adobe Reader