From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Modify built-in workbook properties - Microsoft Excel Tutorial
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Modify built-in workbook properties
- [Instructor] The date the document is created is just one of the system properties that is created and tracked by Excel. After watching this you will understand all the workbook properties that can be shown on the info page and how to insert and separate multiple property entries, such as tags. Which will help you find your document if it's stored out on a shared network and you can't quite remember where you put it. Let's jump right into our document and get started. This is our 02_10 Properties workbook. And let's go ahead and go to file, info, and take a look at our properties. You can see that workbook properties is an entry that I have made so that I could insert a title for this particular workbook. Things that are tracked automatically though are the last modified date, the date created, the author of the document, and who last modified the document. If we go to the properties dropdown menu and go to advanced…
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 data into a new or existing workbook4m 35s
-
(Locked)
Import data from online sources4m 45s
-
(Locked)
Search for data within a workbook4m 56s
-
(Locked)
Navigate to named cells, ranges, or workbook elements6m 14s
-
(Locked)
Insert and remove hyperlinks3m 26s
-
(Locked)
Format worksheets and workbooks4m 26s
-
(Locked)
Customize headers and footers4m 3s
-
(Locked)
Manage the Quick Access Toolbar4m 17s
-
(Locked)
Display and modify worksheets in different views6m 1s
-
(Locked)
Modify built-in workbook properties2m 33s
-
(Locked)
Inspect and export workbooks5m 54s
-
(Locked)
Configure print settings5m 54s
-
(Locked)
Manage comments and notes4m 52s
-
(Locked)
Challenge: Manage worksheets and workbooks2m 30s
-
(Locked)
Solution: Manage worksheets and workbooks9m 41s
-
-
-
-
-
-