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 231
Get notifications when this page is updated

Intro

In lesson 231, you will learn about error handling in Microsoft Excel, including how to deal with error messages, use logical functions like AND, OR, TRUE, and FALSE, and work with the auditing toolbar. We will also cover circular references, ways to avoid them, and when they might be useful, along with some helpful tips and tricks throughout the lesson.

Transcript

Welcome to Microsoft Excel 231, brought to you by ExcelLearningZone.com. I am your instructor, Richard Rost.

In today's class, we are going to cover error handling. There are lots of different ways you can deal with the different errors that Excel spits out at you from time to time.

We are going to talk about some logical functions like AND, OR, TRUE, and FALSE and all those things. We are going to learn about auditing and the auditing toolbar. We talked about it briefly back in Excel 220 and 221. We are going to go into detail on it today.

We are going to learn about circular references, how you can avoid them, and why you might sometimes want them. I have a whole bunch of little tips and tricks to show you too.

This class follows Excel 230, but you do not really need to have taken 230 to get the material in this class. The lessons in this class kind of stand on their own.

I am using Excel XP 2002 in this class. However, whatever version of Excel you have should work okay for this course. Anything from Excel 95 up to 2003 should be okay. I have not tested this lesson with 2007 yet, but from what I have seen in the 2007 books that I have here, it looks like most of this material should be okay.

Of course, while you are taking this class you can ask questions in the interactive website. If you have the Amichron Video Player open, you will see the interactive web page for this class open up in the small browser window to the right of the video if you are online.

If not, you can go to the web page on the screen, ExcelLearningZone.com?GOXL231, and that will take you right to the web page for this class. Scroll all the way down to the bottom and you will see the discussion down there.

If you do need help while you are taking this class, feel free to contact me at ExcelLearningZone.com/contact.

Quiz

Q1. What is the main topic covered in Microsoft Excel 231?
A. Basic Excel formatting
B. Error handling in Excel
C. Creating charts in Excel
D. Macros and automation

Q2. Which logical functions are mentioned as topics in this class?
A. NOT and IF ONLY
B. SUM and AVERAGE
C. AND, OR, TRUE, and FALSE
D. MIN and MAX

Q3. What tool related to auditing is discussed in this class?
A. Mail Merge Toolbar
B. Drawing Toolbar
C. Auditing Toolbar
D. Data Analysis Toolpak

Q4. What will you learn about circular references in this class?
A. What they are and how to format them
B. How to create them only
C. How to avoid them and why you might want them
D. How to share them between workbooks

Q5. Is it necessary to have completed Excel 230 before taking Excel 231?
A. Yes, it is required
B. Yes, but only for advanced students
C. No, both classes are unrelated
D. No, this class can stand on its own

Q6. Which versions of Excel does the instructor mention as compatible with this course?
A. Only Excel 2007 and later
B. Excel 95 up to 2003
C. Only Excel XP 2002
D. Only Excel 2016 and newer

Q7. Where can students go to ask questions during the class?
A. The discussion board in AccessLearningZone.com
B. The interactive website associated with the video
C. Any Excel online forum
D. By sending a letter to the instructor

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

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 focuses on handling errors in Microsoft Excel. I will walk you through the different ways Excel can generate errors and explain how you can manage them effectively.

We will look at logical functions such as AND, OR, TRUE, and FALSE. These tools are very helpful for setting up conditions and handling potential mistakes in your formulas. I will also spend some time showing you Excel's auditing features, including the auditing toolbar. If you remember, we already touched on this topic briefly in Excel 220 and 221, but in this lesson we will go much deeper.

Circular references are another important topic on the agenda. I will show you what they are, reasons you might want to avoid them, and situations where you might actually find them useful. Throughout the class, I will be sharing a variety of tips and tricks to help you handle all kinds of error situations in Excel.

While this class follows after Excel 230, the material here stands alone and you do not have to take 230 beforehand in order to understand any of the topics I am covering. The examples and explanations are designed to be useful for anyone, no matter which version of Excel you are using. I am demonstrating on Excel XP 2002, but any version from Excel 95 through 2003 should work just fine. While I have not specifically tested this course with Excel 2007, based on what I have seen in the reference materials, almost everything we will cover should work in later versions as well.

If you have questions while taking this course, you can use the interactive features of our website. The Amichron Video Player allows you to access a class web page where you can participate in discussions. If you are not online, just head over to ExcelLearningZone.com and go to the class page for XL231. Scroll down to the bottom and you will find the discussion area.

And of course, if you ever need any assistance, you can always reach me through the contact form on ExcelLearningZone.com.

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

This is an introductory overview and course information, not a tutorial or tech help content. It introduces the topics that will be covered in Excel 231 but does not thoroughly explain or walk through any of them in this transcript.