Books+ Search Results
The advanced filter in Excel
Title
The advanced filter in Excel.
Edition
[First edition].
Publication
[Place of publication not identified] : Assemble You, 2024.
Physical Description
1 online resource (1 video file (5 min.)) : sound, color.
Local Notes
Access is available to the Yale community.
Access and use
Access restricted by licensing agreement.
Summary
The Advanced Filter feature provides an alternative to the more commonly used dropdown menus and the FILTER function. This lesson guides you through the steps of using the Advanced Filter to extract specific data based on criteria. While it proves effective in isolating desired information, we also address a drawback - the lack of automatic updates for changed criteria. However, we offer a quick solution: creating a user-friendly macro and assigning it to a button for seamless data refresh, making the Advanced Filter even more accessible and efficient. Whether you're a seasoned Excel user or just starting, this lesson is a valuable addition to your toolkit.
Variant and related titles
O'Reilly Safari. OCLC KB.
Format
Images / Online / Video & Film
Language
English
Added to Catalog
April 02, 2024
Performers
Assemble You Limited, instructor.
Subjects
Genre/Form
Instructional films.
Nonfiction films.
Internet videos.
Also listed under
Assemble You Limited, instructor, publisher.
Bookmark As
Citation
