About this badge
Become an Excel power user and increase your Excel efficiency. This hands-on course is designed for those who are already familiar with Excel but now want to learn advanced skills. Become equipped with powerful expertise in this key business application. Discover how to build advanced formulas for manipulating data, to link workbooks, to consolidate data across workbooks, and to validate data using pull-down menus. Manipulate data using a PivotTable and a slicer, the powerful Excel tools that filter, summarize, and extract data. Become familiar with implementing conditional formatting and recording macros for automation. Learn how to protect worksheets, parse data into columns, delete duplicate records, and much more.
https://www.sps.nyu.edu/professiona...990