Course Description
Can you imagine turning your television on, and every program from every channel is visible at the same time? Data is similar to programs, and it is better organized on worksheets inside your workbook. Each sheet should contain data organized into source sections, such as data gathered, groups, references, and so forth. Proper cell references are crucial to linking worksheets together in a workbook. In this module, we show examples of how to easily create references to other worksheets. These references can be used for simple linking as well as formulas and functions.
In the age of data security, how can you ensure that only the proper people have access to your sensitive data? By securing and encrypting your workbook. By exploring the properties related to your workbook protection, we show you how to properly manage your workbook. By combining the lessons in this module, you will be able to set password protection.
What You'll Learn
- Create cell references that link data across worksheets within a workbook
- Build formulas and functions that pull values from other sheets
- Organize data into source sections such as gathered data, groups, and references on separate worksheets
- Secure and encrypt a workbook to control access to sensitive data
- Set password protection for your workbook
- Manage workbook properties to properly protect your workbook
Key Takeaways
- Data is better organized when split across worksheets inside a workbook, with each sheet holding a source section such as gathered data, groups, or references.
- Proper cell references are crucial to linking worksheets together within a workbook.
- References to other worksheets can be used for simple linking as well as in formulas and functions.
- Securing and encrypting a workbook helps ensure that only the proper people have access to sensitive data.
- Exploring workbook protection properties lets you manage a workbook and set password protection.
Frequently Asked Questions
What does this Excel module cover?
It covers creating cell references between worksheets for linking, formulas, and functions, plus securing and encrypting your workbook and managing workbook properties to set password protection.
What skills will I gain from this course?
The course builds skills in Microsoft Excel, Spreadsheets, Data Management, Excel Macros, Excel Services, and Workbooks CRM.
What lessons are included?
The module includes three lessons: Cell References Using Sheets; Security and Password Protection; and Workbook Properties and Management.
How does this course help protect sensitive data?
It shows how to secure and encrypt your workbook and explores workbook protection properties so you can set password protection and ensure only the proper people have access.
Why should data be organized across multiple worksheets?
Because data is better organized when each sheet contains data grouped into source sections, such as data gathered, groups, and references, rather than all shown at once.
