From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Modify basic workbook properties
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Modify basic workbook properties
- [Instructor] Workbook properties contain information that is both inserted by the system and also inserted by us the user. After watching this video you'll know how to view the system properties and how to use custom properties to add more information about your document for your users. Let's jump right in to our Properties document and take a look at what is currently in there. We'll go to File, and on the right-hand side we see all of our properties. Now the ones that you see for size that's a system property. Our computer system keeps track of the current size of a document. Other system properties are the last modified date and time, the created date and time, and also the date and time of when the document was last printed will be visible. Whoever creates the workbook is inserted as the author and also the person who modified the document last is also inserted by the system. Let's go and look at all of the properties for this document. We'll go to advanced properties, and on…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Import TXT or CSV data into a new workbook3m 22s
-
(Locked)
Import TXT or CSV data into an existing workbook3m 7s
-
(Locked)
Search for data within a workbook2m 36s
-
(Locked)
Navigate data with named ranges and hyperlinks5m 27s
-
(Locked)
Format worksheets and workbooks5m 1s
-
(Locked)
Customize headers and footers4m 37s
-
(Locked)
Display and modify content in different views5m
-
(Locked)
Modify basic workbook properties2m 33s
-
(Locked)
Customize the Quick Access Toolbar3m 55s
-
(Locked)
Inspect and export workbooks6m 33s
-
(Locked)
Configure print settings4m 15s
-
(Locked)
Challenge: Manage worksheets and workbooks1m 10s
-
(Locked)
Solution: Manage worksheets and workbooks9m 10s
-
-
-
-
-
-
-