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

Intro

In lesson 220, you will learn how to get started with data analysis in Microsoft Excel, focusing on creating and formatting data lists, using data entry forms, and applying tips for sorting your lists more effectively. I will also show you how to customize toolbars to simplify your data analysis tasks. This lesson is designed for users running Excel XP (2002) or Excel 2003, and builds on concepts from previous Excel courses.

Transcript

Welcome to Microsoft Excel 220 Data Analysis 1 brought to you by ExcelLearningZone.com. I am your instructor Richard Rost.

In today's class, we are going to begin our journey through data analysis. We are going to start by creating data lists. Formatting those data lists, we will learn how to use data entry forms to enter and edit our data. We will see some list sorting tricks and tips. I am going to show you how to customize toolbars to make our data analysis much, much easier.

Before taking this class, you should have taken Excel 101 through 202. All of those courses are going to have information that is going to be very useful before you take this class. I am going to build upon a lot of the techniques that we have developed through those classes.

In this class, we are going to be using Microsoft Excel XP, the 2002 version. However, all the things that we are going to show you are valid for just about every version of Excel. You may notice some minor cosmetic differences here and there, but the functions and features should all work pretty much the same.

Even if you are using Excel 2003, you will notice that most of the features are pretty much the same. Excel 2003 actually adds some features that make working with data lists a little bit easier. But if you learn the techniques that I am showing you here, you should have no problem switching over to 2003.

I recommend you sit back and watch the first time through. Then watch the lesson the second time following along with the examples. Do not try to apply what you learn here immediately. Go ahead and play with the examples. Do the sample lessons that I have got for you. Then try applying it to your own spreadsheets.

If you do not like typing, you can download the sample spreadsheets and other data from the class webpage at excellearningzone.com/excel/220. I do recommend you type in your own data lists. If you are really lazy and do not like typing, you can grab the spreadsheets off the website, but you will get much more out of it if you type in the stuff yourself.

Also, I do recommend you use sample spreadsheets. Do not try applying this immediately to the spreadsheets that you use for your real office work, for example. Try using the sample data. You will sometimes see things a different way if it is not work that you are used to working on.

Most importantly, though, try to have fun learning Excel. Try to apply Excel for something other than work. If you are using this just for work and you have some hobby at home like collecting baseball cards or something like that, try doing that in Excel. Try playing with some sample data other than just work. You will find that sometimes you learn things a lot better if you do not always see it the same way.

I know that when I was learning Excel and Microsoft Access, I used to put my baseball card collection in it, and that helped me to play with it and learn how to do certain things and experiment with some of the features. Set the work aside and try playing with something that you enjoy while you are working with Excel. You will find that you learn it a lot faster.

Quiz

Q1. What is the primary focus of this Excel 220 Data Analysis 1 course?
A. Creating and analyzing data lists
B. Designing advanced charts
C. Writing macros in VBA
D. Building financial models

Q2. Which versions of Excel are the techniques from this class applicable to?
A. Only Excel XP (2002)
B. Only Excel 2003 and newer
C. Almost every version of Excel
D. Only Excel 2016 and above

Q3. Before starting this course, which prerequisite courses are recommended?
A. Only Excel 220
B. Excel 101 through 202
C. Advanced programming classes
D. No prerequisites are needed

Q4. What is one tool mentioned for making data analysis easier in Excel?
A. Conditional formatting
B. Data validation
C. Customizing toolbars
D. Pivot tables

Q5. What advice is given on how to approach the lesson for the first time?
A. Immediately apply concepts to your real work spreadsheets
B. Memorize all the formulas first
C. Watch once, then follow along with examples the second time
D. Skip the examples and go straight to advanced topics

Q6. Why does the instructor recommend using sample or hobby data in Excel, such as a baseball card collection?
A. It makes the data harder to understand
B. It distracts from learning
C. It helps you learn Excel features in a more enjoyable way
D. It prevents you from making mistakes at work

Q7. What is suggested if you do not like typing out data lists?
A. You must type everything by hand
B. Copy and paste from other spreadsheets
C. Download the sample spreadsheets, but typing your own is better
D. Skip data entry altogether

Q8. What is NOT recommended when learning the new techniques from this course?
A. Practicing with sample spreadsheets
B. Applying immediately to your important work files
C. Playing with data you enjoy
D. Typing out data lists for practice

Answers: 1-A; 2-C; 3-B; 4-C; 5-C; 6-C; 7-C; 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 kicks off Microsoft Excel 220, Data Analysis 1. I am your instructor, Richard Rost.

In this class, we're beginning our exploration of data analysis using Excel. We'll start by creating data lists and learning how to format them effectively. I'll show you how to use data entry forms, which can simplify the process of adding and editing your information. You'll also pick up some helpful tips for sorting your lists. To make your workflow more efficient, I'll cover ways to customize your toolbars for easier data analysis.

It's important that you complete Excel 101 through 202 before taking this course. The material from those classes will give you the foundation you'll need, since we'll be building on the skills and techniques introduced there.

We'll be using Microsoft Excel XP, also known as Excel 2002, throughout this course. However, nearly everything I show you will apply to other versions of Excel as well. You might notice a few minor visual differences, but by and large, the functionality and the way you perform tasks remains consistent across these versions. Even if you're using Excel 2003, you'll see most features work the same way, and in fact, Excel 2003 adds a few tools that make working with data lists even easier. Once you learn the methods in this class, transitioning between versions should be no problem.

My advice is to watch the lesson through once before trying to follow along. On your second viewing, try working through the examples with me. Don't put pressure on yourself to master everything immediately. Take some time to experiment with the sample lessons I provide, and get comfortable before you apply these concepts to your own spreadsheets.

If you'd rather not do a lot of typing, you can download the sample spreadsheets and data sets for this class from the course page at ExcelLearningZone.com, Excel 220 section. Although these downloadable resources are available, I actually recommend typing your own data lists if you can. You'll absorb much more by doing the work yourself, but the files are there for those who prefer to download them.

For best results, use the sample data instead of your real work documents as you learn these new skills. By practicing on unfamiliar data, you'll be less likely to fall into your usual patterns, and you might notice things you would otherwise miss.

Most of all, remember to have fun as you learn Excel. Try applying your skills to something outside of work. If you have a hobby, such as collecting baseball cards, consider using Excel to track your collection. Exploring the software with something you personally enjoy can make learning much more engaging. I found that working on my own baseball card collection in Excel and Access helped me discover new features and experiment more comfortably than if I only used it for work tasks.

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

Creating data lists in Excel
Formatting data lists
Using data entry forms for data input
Editing data with data entry forms
Sorting data lists
Customizing toolbars for data analysis