Microsoft Excel: Managing Worksheets and Workbooks

Name: Microsoft Excel: Managing Worksheets and Workbooks
Author: Bob Akbar

Adding multiple layers to your workbook by using worksheets and securing your documents

Preview the first lesson free — get full access to all 3 lessons.

Course: On-Demand

Hello, my name is Bob Akbar and in these lessons, you will learn managing worksheets and workbooks, which consists of cell references using sheets, security and password protection, workbook properties and management. In this lesson, I will show you cell references using sheets. Now, you will notice that we have a note here that says the master information table is secret! So this is our public worksheet that we are going to use to send to our colleagues or that we're going to prepare presentations for, and obviously, it is noted that they do not want us to display which states our sales are in or which months or done by whom as our master table. So what we're going to do is we can right click and you can actually insert and you can rename it once you are done, and then we end up with our sheet. So what we can do is some of them, if you notice, this one, for example, the state of Texas is a B18 reference, which is here, which is a local reference. However, the other ones say the name with the sheet Private!B3, so they are referring to B3 here. And that's ultimately what we want to do. So let's fix our Texas reference here from the public sheet to the private. And simply on our formula bar, we're going to put an equals. Private, the name of the sheet, exclamation point, and let's see where Texas lies. Texas is B6. Now, you notice if we go back and forth between the sheets, it's gonna put the name of both sheets on there, so ideally, we're gonna look beforehand before we input it in there. That's one of the issues to avoid. Now, the second one to avoid, I'm going to show you and this is a very common one that a lot of people make this mistake on. Now, New York here, I'm going to use the actual clicking on the cells, and for New York, I'm going to put equals, click on Private. There's New York. This is where you want to press Enter and not go back to the public sheet because if you do, which instinctively most people want to do, it'll put the name of that and then you'll get (indistinct) cell reference. So this is where you just want to simply press Enter and your reference is made. Thanks for watching, stay tuned for the next lesson where I will show you security and password protection.

Intermediate Provider : Bob Akbar 3 Lessons · 13m in Arabic, German, English, Spanish, French, Portuguese, Chinese

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.