Lessons

Resources

Full Course Outline
Skills Test Quiz - Under Construction
Certificate of Completion
Post-Class Survey

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Subscribe to Excel 2003 Expert 201
Get notifications when this page is updated

Intro

In lesson 201, you will learn how to use the IF function to make decisions based on data in Microsoft Excel, understand the difference between relative and absolute cell references, share data across different sheets in a workbook, and see the differences between paste linking and embedding with Microsoft Word. We will also cover some useful tips and tricks to help you work more efficiently in Excel.

Transcript

Welcome to Microsoft Excel 201 Intermediate Excel for Opti by 599CD.com. I am your instructor, Richard Rost.

Let's talk about the objectives for today's class. First, we are going to learn about the IF function, the brand new function that is going to allow Excel to make a decision about what to do with the data based on other values in your sheet. It is a very powerful function.

Then we are going to learn about relative versus absolute cell references, sharing data between different sheets in your workbook, paste linking versus embedding with Microsoft Word, and we have some tips and tricks to share with you at the end of class.

Prerequisites: if you are taking this course, we are assuming that you know the material from our Excel 101, 102, 103, and 104 classes. Those are all basic beginner Excel classes, and we are going to be building on the topics learned in those classes for today's class.

In class today, we are going to be using Microsoft Excel XP and Windows XP. However, the lessons that we are teaching today are valid for just about every version of Excel, and the version of Windows that you are using does not matter.

We recommend you sit back, relax, and watch the lessons once through completely, then watch them each a second time following along on your computer. Do not try to apply what you learn immediately; let it sink in, and then go ahead and do some stuff on your own that pertains to what you are using Excel for.

The class website for this class is at 599CD.com/excel/201.

Most important note: make sure you have fun. Do something in Excel that you enjoy, not necessarily work related. You will find that you learn Excel more, and it will sink in better if you are doing something that you like doing.

Quiz

Q1. What is the main new function introduced in this class?
A. SUM function
B. IF function
C. VLOOKUP function
D. CONCATENATE function

Q2. The IF function in Excel is primarily used to:
A. Create charts from your data
B. Automatically format cells
C. Make decisions based on the values in your sheet
D. Sort data alphabetically

Q3. Which topic will be covered regarding cell references?
A. Cell formatting options
B. Relative versus absolute cell references
C. Creating pivot tables
D. Importing CSV files

Q4. What does the course suggest about sharing data between sheets?
A. Use only absolute references
B. It will not be covered
C. It is not possible in Excel
D. It will be discussed in the class

Q5. What is the difference between paste linking and embedding with Microsoft Word, as implied in the objectives?
A. Embedding is only available in Excel 104
B. Paste linking and embedding are the same thing
C. They are two different ways to connect Excel data with Word
D. You can only use paste linking in Windows 11

Q6. What prerequisite is expected for students taking this class?
A. Knowledge from Excel 101, 102, 103, and 104
B. Advanced programming in Excel VBA
C. Experience with PowerPoint
D. Prior use of Mac OS X

Q7. The class is being demonstrated on Microsoft Excel XP and Windows XP, but the lessons are:
A. Only useful for XP users
B. Not applicable to newer versions of Excel
C. Valid for almost every version of Excel and Windows
D. Exclusive to Microsoft 365

Q8. What is the recommended way to use the lessons in this class?
A. Follow along live and pause frequently
B. Watch the lessons twice, once to observe and once to follow along
C. Only read the manual
D. Skip directly to the exercises

Q9. According to the instructor, what is the most important thing to keep in mind while learning Excel?
A. Memorize shortcuts
B. Practice only work-related tasks
C. Have fun and work with data you enjoy
D. Install additional plugins

Answers: 1-B; 2-C; 3-B; 4-D; 5-C; 6-A; 7-C; 8-B; 9-C

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Excel Learning Zone covers the key objectives for the Microsoft Excel 201 Intermediate Excel for Opti course. I'm Richard Rost, your instructor.

To start, I want to introduce the IF function, which is an incredibly useful tool in Excel. With the IF function, you can set up your spreadsheet so that Excel makes decisions based on values in your sheet. Essentially, it allows your workbook to follow logical rules that you specify. This adds a whole new level of power to the way you handle your data.

Next, we'll discuss the difference between relative and absolute cell references. Knowing when to use one or the other is critical for setting up your spreadsheets to behave the way you want them to, especially as you start copying formulas to different places.

We will also cover how to share data between different sheets in the same workbook. This means you'll learn the proper way to reference and work with information that is stored on other sheets, making your workbooks much more dynamic.

In addition, we're going to take a look at how to link your Excel data with Microsoft Word, specifically looking at the difference between paste linking and embedding. These techniques help you to integrate your Excel data into Word documents effectively, depending on whether you want updates to sync automatically or stay fixed.

To wrap up, I have some useful tips and tricks that will help make your experience in Excel smoother and more efficient.

Before you begin, make sure you are comfortable with the material from my Excel 101, 102, 103, and 104 courses, since we will be building on these foundational topics. If you have taken those beginner-level classes, you'll be right at home with today's material.

Although we're using Microsoft Excel XP and Windows XP for this tutorial, the lessons are relevant for almost every version of Excel, and it does not matter which version of Windows you use.

For the best learning experience, I recommend that you watch each lesson all the way through once before trying to follow along. Let the information settle in your mind, then go back and practice with your own Excel files. Try to apply what you learn in a context that matters to you, whether it's related to work or a personal project. It's much easier to remember and master Excel when you're using it for something you enjoy.

For more information and resources related to this class, check the course website at 599CD.com excel 201.

And above all else, remember to have fun with Excel. Explore projects that interest you, not just those that are work related. You'll find that the knowledge sticks with you much better when you are working on something that you actually enjoy.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Using the IF function to make decisions in Excel
Understanding relative vs absolute cell references
Sharing data between different sheets in a workbook
Paste linking between Excel and Microsoft Word
Embedding Excel data into Microsoft Word