Excel 204 - Worksheet Functionality Part 1
Product Description
8-page bi-fold.
This quick reference guide is one of two guides dedicated to Worksheet Functionality. In Part 1, we will explore how worksheet and workbook linking works, how to create links in the same workbook or between workbooks, the various techniques used in creating links such as Paste Special or using formulas, how to manage links and how to troubleshoot links when you encounter errors. Additional topics include: adding hyperlinks to worksheets, file and data recovery options and using worksheet auditing to locate formula sources and analyze formulas. Finally, we will discuss how to protect your worksheets and your data using various methods such as adding passwords, adding read-only settings, locking down portions or your worksheet and to track changes in a shared worksheet environment.
The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files.
This quick reference guide is one of two guides dedicated to Worksheet Functionality. In Part 1, we will explore how worksheet and workbook linking works, how to create links in the same workbook or between workbooks, the various techniques used in creating links such as Paste Special or using formulas, how to manage links and how to troubleshoot links when you encounter errors. Additional topics include: adding hyperlinks to worksheets, file and data recovery options and using worksheet auditing to locate formula sources and analyze formulas. Finally, we will discuss how to protect your worksheets and your data using various methods such as adding passwords, adding read-only settings, locking down portions or your worksheet and to track changes in a shared worksheet environment.
The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files.