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.

Comments for Excel 2003 Beginner 101

Age	Subject	From
3 years	Downloads	John Suderman

Subscribe to Excel 2003 Beginner 101
Get notifications when this page is updated

Intro

In this lesson, you will learn the basics of getting started with Microsoft Excel, including navigating the interface, entering and editing data, formatting cells, and performing basic math calculations. We will also cover using functions, cut, copy, and paste, working with autofill, saving and loading workbooks, and printing your spreadsheets. This beginner course is designed to help you become comfortable creating and working with spreadsheets quickly in Microsoft Excel. This is lesson 101.

Transcript

Welcome to Microsoft Excel 101, an introduction to Excel brought to you by MyOnlineLearningPartner.com and 599CD.com. I am your instructor, Richard Rost, and I can be reached at [email protected].

What are the objectives for today's class? We are going to learn about Microsoft Excel, the parts of the screen, entering and editing data, and formatting cells. We are going to work with some basic math calculations. We are going to teach you functions - what are functions? You will find out in a few minutes. Cut, copy, and paste. We are going to teach you autofill. We are going to learn how to save and load our workbooks, and we will show you how to print your spreadsheets.

Our goal with Excel 101 is to get you up and running quickly. All of our 101 classes are designed to get you using the software in a minimal amount of time. We will cover a lot more of the details in our future classes. For today, our focus is to get you working with Excel, creating a spreadsheet, and being productive in about an hour.

Prerequisites for this course are Windows 101, Introduction to Computers, and either Windows 102, Introduction to Windows 98, or Windows 110, Introduction to Windows XP. We will assume you are familiar with Windows, how to move around, and how to use the keyboard and mouse.

It is also recommended, though not required, that you take our Word 101 class first as well. A lot of the topics we will cover today, like saving and loading documents, cut, copy, and paste, and printing, are the same between Word and Excel. We cover them in more detail in our Word course because we recommend people watch the Word course first and then move on to Excel. Again, Word is not required, but it will be helpful if you watch that before this class.

Versions used: We will use Microsoft Excel XP, the 2002 edition, and Windows XP in this course. Most of the material covered in today's course will be the same regardless of what version of Excel or Windows you use. If you have Excel 2000, Excel 97, or even Excel 95, pretty much all the information covered will be the same for you. Likewise, if you have Windows 98, Windows 95, or Windows 2000, most of the information covered in today's class will be the same for you as well.

Quiz

Q1. What is the primary goal of Excel 101?
A. To cover advanced Excel programming
B. To get you up and running with Excel quickly
C. To focus only on printing spreadsheets
D. To teach graphic design in Excel

Q2. Which of the following topics will NOT be covered in Excel 101?
A. Parts of the Excel screen
B. Entering and editing data
C. Programming in Visual Basic
D. Formatting cells

Q3. What are functions in the context of Excel 101?
A. Charts and graphs
B. Built-in operations that perform calculations
C. File management techniques
D. Internet browsing features

Q4. Which prerequisite is NOT mentioned as required for Excel 101?
A. Introduction to Computers
B. Familiarity with Windows
C. Word 101
D. Basic keyboard and mouse usage

Q5. Which version of Excel is specifically used for demonstration in this class?
A. Excel 2019
B. Excel XP (2002 Edition)
C. Excel Online
D. Excel 2016

Q6. If someone has Excel 95 or Excel 97, what does the instructor say about the course content?
A. It will not be applicable
B. Most of the information will still be relevant
C. They should upgrade first
D. None of the material will work

Q7. Why does the instructor suggest taking the Word 101 class before Excel 101?
A. Word and Excel are unrelated
B. Word covers saving, loading, and printing in more detail
C. Word 101 is more advanced
D. Excel does not require document management

Q8. What should students be familiar with before taking Excel 101?
A. Only internet browsing
B. How to use the keyboard and mouse
C. Programming in C++
D. How to build web pages

Answers: 1-B; 2-C; 3-B; 4-C; 5-B; 6-B; 7-B; 8-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 introduces Microsoft Excel and is designed to help beginners become familiar with the basics of this powerful spreadsheet application. In this session, I will guide you through the essential building blocks you need to get started with Excel, including an overview of the main parts of the screen, how to enter and edit data, and methods for formatting cells.

We'll practice basic math calculations, which are a key part of using Excel to its full potential. I will also introduce the concept of functions and explain what they are and how to use them. In addition, you'll learn fundamental tasks such as cutting, copying, and pasting data, which will help you work more efficiently. I will show you how to use autofill, a feature that can save you time when entering repetitive data.

It's also important to know how to save your work and later open it, so we will cover saving and loading workbooks. To wrap up, I'll explain how to print your spreadsheets so that you have a physical copy of your work when needed.

Our primary aim with Excel 101 is to help you become productive with Excel as quickly as possible. All of our introductory courses are structured to get you comfortable using the software in around an hour, leaving the more advanced and detailed features for future lessons.

To join this class, you should have already taken Windows 101 and Introduction to Computers. In addition, it is assumed that you know how to navigate in Windows, and are comfortable using the keyboard and mouse. Courses like Windows 102 or Windows 110 are also recommended, depending on which version of Windows you have. While not required, some prior experience with Word 101 will be helpful as well, since many of the skills such as saving documents, cut, copy, paste, and printing are similar in both Word and Excel. These are actually covered in greater detail in the Word course.

For this course, I will be demonstrating with Microsoft Excel XP (also known as the 2002 edition) and Windows XP. However, almost everything you learn here will be applicable to older versions like Excel 2000, 97, or even 95. Similarly, if you are working with an earlier version of Windows such as Windows 98, 95, or 2000, the basics we cover will still be relevant.

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 introduction and course overview message for a Microsoft Excel 101 video tutorial, describing what will be covered in the lesson.