Microsoft Excel 2013 Quick Reference Guide – Worksheet Functionality: Introduction to Data Linking, Version Control, Data Protection, Auditing & Tracking Changes (206)

This 8-page bifold quick reference guide (cheat sheet) is dedicated to Worksheet Functionality. In this guide, 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

This
8-page bifold quick reference guide (cheat sheet) is dedicated to Worksheet Functionality. In this guide, 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 how to track changes in a shared worksheet environment.

All of our quick guides are developed, designed and published in the US. They are printed on a high-quality sustainable stock that features UV coating which resists fading and spills. Unlike the competition, our guides offer in-depth details, step-by-step exercises, structured content that is based on adult learning concepts and are written by expert instructors who are every day users of the software application. Yes, our guides are priced higher; however, the quality and value found in these guides are far superior to the competition. With our quick reference guides, you can achieve more today, and make a great investment for tomorrow.

Note for Corporate Training Departments: Save time and save money. Do not eliminate software training, improve it! With our unique and affordable quick reference guides, you will empower your employees to do more with less, to be more productive and learn what they need when they need it. Preserve the investment you have made in your employees, by offering them this quick reference guide, either as a self-learning tool or as part of your corporate training strategy.

Product Features

  • Part of a series of several quick reference guides for Excel 2013, each focusing on a set of specific and important topics such as Excel 2013-201, Excel 2013-202, Excel 2013-203, Excel 2013-204, Excel 2013-205, Excel 2013-206, Excel 2013-301, Excel 2013-302, Excel 2013-303, Excel 2013-304, Excel 2013-401, Excel 2013-402 and much more.
  • Understand and manage links between worksheets and workbooks in various storage locations.
  • Use worksheet auditing tools to locate formulas and trace errors.
  • Protect worksheet data using various techniques. Learn about tracking changes and worksheet comments. Manage file versions for local, networked and SharePoint-based files.
  • Unlike the competition, our quick reference guides are designed with clear step by step instructions based on exercises that you perform.