February 2013
Beginner to intermediate
576 pages
21h 30m
English
Excel automatically documents workbook properties while you work, such as file size, save dates, and various statistics, and allows you to document other properties, such as title, author, subject, keywords, category, and status. You can view or edit standard document properties or create advanced custom properties by using the Document Information Panel, which is actually an XML-based Microsoft InfoPath 2013 form hosted in Excel. You can use document properties—also known as metadata—to help you manage and track files; search tools can use the metadata to find a workbook based-on your search criteria. If you associate a document property to an item in the document, the document property updates when you change ...