Some of the most useful and time-saving features in Excel are the choices to link and share worksheet data. In this course, find out how to easily reference and summarize data from other worksheets, learn how to use Excel data in other programs, look at options to share workbooks and protect data, and how to manage user comments and changes. IT3272
Areas Covered in the Session :
- Linking within a workbook
- Linking and updating across workbooks
- Using the Consolidate command
- Sharing Excel data with other programs (Word, PowerPoint)
- Applying protection and sharing properties
- Handling comments and revisions
- Creating hyperlinks to other files and resources