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

Intro

In lesson 102, you will learn how to use AutoFill in Microsoft Excel, create a calendar, organize your data with sorting, and get started with basic charting. This lesson builds on the topics covered in Excel 101 and is designed for beginners looking to expand their Excel skills.

Transcript

Welcome to Microsoft Excel 102 using Microsoft Excel, brought to you by my online learning partner and 599cd.com. I am your instructor Richard Rost.

In today's class, we are going to learn AutoFill, creating a calendar, sorting, and charting.

This class has a prerequisite of Excel 101 Introduction to Microsoft Excel. This class picks up where Excel 101 left off. We assume you have taken Excel 101 first.

In this class, we will use Microsoft Excel XP and Windows XP. However, most of this lesson is valid for every version of Microsoft Excel, and it does not matter which version of Windows you are using.

Quiz

Q1. What is one of the main topics covered in Microsoft Excel 102?
A. AutoFill
B. VBA programming
C. Macro recording
D. Data encryption

Q2. Which version of Microsoft Excel is used in this class?
A. Excel XP
B. Excel 2016
C. Excel 97
D. Excel for Mac

Q3. Do the lessons in this class apply only to Windows XP?
A. No, they apply to most versions of Windows and Excel
B. Yes, only Windows XP is supported
C. Only Windows 10 is supported
D. Only Mac OS is supported

Q4. Which class is recommended before taking Microsoft Excel 102?
A. Excel 101 Introduction to Microsoft Excel
B. PowerPoint Basics
C. Access 101
D. Word Processing 101

Q5. What is NOT listed as a topic for this class?
A. Charting
B. Calendar creation
C. Database design
D. Sorting

Answers: 1-A; 2-A; 3-A; 4-A; 5-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 some important intermediate topics in Microsoft Excel. This lesson is aimed at students who have already completed the introductory Excel 101 course, so make sure you are comfortable with those basics before continuing here.

In this session, I will walk you through the use of AutoFill, which can help you quickly populate cells with data based on patterns. I will also show you how to create a basic calendar in Excel, which is a practical application of what you have learned so far. Next, we will cover how to sort your data to make it easier to find and analyze information. Finally, I will introduce you to charting, which allows you to turn your numerical data into visual graphs for easier interpretation.

Although I will be demonstrating these concepts using Microsoft Excel XP and Windows XP, you will find that everything in this lesson can easily be applied to almost any recent version of Excel, no matter which version of Windows you have. The steps and processes remain consistent across versions.

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

AutoFill basics and usage
Creating a calendar in Excel
Sorting data in Excel
Creating charts in Excel