Introduction

Welcome! Cut, Copy, Paste, Fill, Sort, Find, Replace

S M L XL FS | Slo Reg Fast 2x | Bookmark | Autoplay: ON

Welcome to Excel Beginner Level 2. In this course we will cover using cut, copy, and paste commands and the clipboard, working with AutoFill, cell formatting, managing rows and columns, working with sheets, sorting data, conditional formatting, and using Find and Replace. This course builds on topics from Level 1 and is aimed at novice users ready to expand their skills. We will discuss which Excel versions are best for following along, detail the content for each lesson, and offer tips for getting the most out of your learning experience, including using the interactive student forums.

Navigation

Prev: B02
Next: Lesson 01

Keywords

TechHelp Excel, Excel 2010, cut copy paste, AutoFill, cell formatting, sort data, conditional formatting, find and replace, rows and columns, insert delete rows, insert delete columns, worksheets, rename worksheet, move worksheet, copy worksheet, Excel fo

Subscribe to Introduction
Get notifications when this page is updated

More Information

Transcript

Welcome to Excel 2010 Beginner Level 2 brought to you by ExcelLearningZone.com. I am your instructor, Richard Rost. Today's class will cover using cut, copy, and paste and the clipboard, working with AutoFill, cell formatting, using rows and columns, working with sheets, sorting data, conditional formatting, and using the Find and Replace feature.

Before taking this course, I strongly recommend that you take my Excel 2010 Beginner Level 1 course. That course covers using the Excel interface, entering and editing data, basic cell formatting, basic math, and how to save, load, and print your documents.

If you are using Excel 2007, you should have little difficulty following along, as most of the topics covered in this course are the same. If you are using Excel 2003 or earlier, you really should either upgrade to Excel 2010, or purchase a tutorial for your version of Excel, which again you can find on my website. All of these concepts are essential for understanding the topics in today's class.

If any of these things sound unfamiliar to you, visit my website at ExcelLearningZone.com and look for Excel 2010 Beginner Level 1. This class is designed to be used with Microsoft Excel 2010, a part of Microsoft Office 2010. If you are using an older version of Excel, you should visit my website at ExcelLearningZone.com and look for my older tutorials covering Excel 2000 through 2007.

My courses are broken up into four groups: beginner, expert, advanced, and developer.

My beginner courses are for novice users who have little or no experience with Microsoft Excel. They are designed to give you an overview of the basic features of Excel and cover just what you need to know to be productive. This is the beginner level 2 course for Microsoft Excel 2010. This class is designed for the novice user who has little or no experience with Excel, aside from my beginner level 1 course.

Our goal for today is to expand on some of the concepts from level 1 and to teach you some new Excel features.

When you finish the basics, it is time to move up to the expert series, which is designed for users who are already comfortable with Excel. Expert classes are designed to teach you more about all the standard features of Excel that people use from day to day, and will go into more depth about each topic than the beginner classes. You will learn all about the options, alternatives, shortcuts, tips and tricks, and extra features that we might have skipped over in the beginner lessons.

When you've mastered the expert classes, the advanced lessons are for Excel power users. You will learn how to record macros, build user forms, create your own templates, and many more advanced features that not everyone will use, but they really add enhanced functionality and professionalism to your spreadsheets.

Finally, my developer level courses are designed to teach you how to program in Visual Basic for Applications with Microsoft Excel. This will allow you to create Excel-based programs for your users, automate your spreadsheets, and to integrate Excel tightly with other Microsoft Office applications.

Each of my series is broken down into different levels. For example, the beginner series started with level 1, which you should have taken previously, and is followed by level 2, which is this class, through level 5. Each level teaches you new and different topics in Excel, building on the lessons learned in the previous levels.

When you've finished all the beginner classes, move up to the expert series, then advanced, and finally developer.

Now, let's take a more detailed look at what is covered in today's class.

In lesson 1, we are going to learn how to use the clipboard, including the cut, copy, and paste commands.

In lesson 2, we are going to learn how to use Auto Fill to quickly copy information across multiple rows or columns.

In lesson 3, we are going to begin learning about cell formats, including text, number, currency, accounting, long, and short dates.

In lesson 4, we are continuing our work with cell formats. You will learn about fractions, percentages, increase and decrease decimal points, comma, and scientific notation.

In lesson 5, we will learn about rows and columns, specifically how to insert and delete rows and columns, and how that is different from just clearing their contents.

Lesson 6 is all about working with your worksheets. You will learn how to insert, delete, rename, move, copy, and change the color of your worksheets.

In lesson 7, we will learn how to properly sort data in our spreadsheets.

In lesson 8, we are going to learn about conditional formatting, which is changing the format of your cell based on the data in the cell, for example, making higher numbers look red and lower numbers green.

In lesson 9, we are going to learn how to find and replace data in our spreadsheets.

If you need help with the topics covered in today's lessons, please feel free to post your questions in the Excel Interactive Student forums.

If you are watching this course using my custom video player software or online in my web theater, you should see the student forum for each lesson appear in a small window next to the class videos, if you have an active internet connection. Here you will see all of the questions that other students have asked, as well as my responses to them, and any other comments that other students have made. I encourage you to read through these questions and answers as you start each lesson and feel free to post your own questions and comments as well.

If you are not watching your lessons online, you can still visit the student forums later by visiting excellearningzone.com/forums.

To get the most out of this course, I recommend you sit back, relax, and watch each lesson completely through once without trying to do anything on your computer. Then replay the lesson from the beginning and follow along with my examples. Actually create the same spreadsheet that I make in the video. Build a spreadsheet with me step by step. Do not try to apply what you are learning right now to other projects until you have mastered the sample spreadsheet.

If you get stuck or do not understand something, watch the video again from the beginning or tell me what is wrong in the student forums.

Most importantly, keep an open mind. Excel might seem intimidating at first, but once you get the hang of it, you will see that it is really easy to use.

Intro

Quiz

Q1. Which feature allows you to quickly copy information across multiple rows or columns in Excel?
A. Auto Fill
B. Conditional Formatting
C. Find and Replace
D. Merge Cells

Q2. What do the cut, copy, and paste commands primarily work with in Excel?
A. The Clipboard
B. The Formula Bar
C. The Status Bar
D. The Ribbon

Q3. Which of the following is NOT a cell format discussed in the class?
A. Hyperlink
B. Number
C. Currency
D. Accounting

Q4. What feature allows you to automatically change the appearance of a cell based on its value?
A. Conditional Formatting
B. Auto Fill
C. Sorting
D. Data Validation

Q5. What is the difference between deleting a row and clearing its contents?
A. Deleting removes the row entirely; clearing only removes the data inside.
B. Clearing causes the row to move to the top; deleting does not.
C. Deleting saves the data; clearing does not.
D. There is no difference between the two.

Q6. Which action is NOT included when working with worksheets in this class?
A. Printing the worksheet
B. Renaming the worksheet
C. Moving and copying the worksheet
D. Changing the color of the worksheet tab

Q7. Which lesson covers finding and replacing data in your spreadsheets?
A. Lesson 9
B. Lesson 5
C. Lesson 7
D. Lesson 2

Q8. What is recommended before taking this class?
A. Completing the beginner level 1 course
B. Mastering developer courses
C. Having experience building macros
D. Attending an advanced class

Q9. For what purpose should you visit the student forums mentioned in the course?
A. To ask questions and read other students' questions and answers
B. To download illegal software
C. To buy additional licenses for Excel
D. To rate the video lessons

Q10. What is the correct process suggested for learning from each lesson?
A. Watch each lesson once, then replay and follow along step by step
B. Only read the transcript and skip the videos
C. Jump ahead to advanced projects immediately
D. Only focus on practicing old spreadsheets

Answers: 1-A; 2-A; 3-A; 4-A; 5-A; 6-A; 7-A; 8-A; 9-A; 10-A

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 the Excel Learning Zone covers my Excel 2010 Beginner Level 2 course. I'm Richard Rost, and in this class, I will guide you through some essential skills to help you work more effectively with Excel 2010.

Before you begin with this course, I recommend you take my Excel 2010 Beginner Level 1 class first. That introductory course explains the Excel interface, how to enter and edit your data, simple cell formatting, basic math tasks, and the fundamentals of saving, loading, and printing your documents.

Most of what is taught in this class will also apply to Excel 2007, so if you're using that version, you'll be able to follow along easily. If you use Excel 2003 or an earlier version, a lot of what we cover is different and I strongly suggest either upgrading to Excel 2010 or checking my website for a tutorial specific to your version.

My training courses are grouped into four main levels: beginner, expert, advanced, and developer. Beginner courses are designed for people with little or no experience with Excel, giving you a solid grasp of the basic features you need to start working productively. Expert classes assume you already have some experience and focus on more in-depth features, tips, options, and shortcuts that help you become more efficient. Advanced lessons are for those of you who want to push Excel further, covering tasks like creating macros, building user forms, making your own templates, and much more. Finally, my developer courses teach you how to program using Visual Basic for Applications (VBA) to automate your spreadsheets and build custom solutions that connect with other Office applications.

Each series is divided into multiple levels. For example, the beginner series starts at level 1, which you should have taken already, and continues all the way up to level 5, each level building upon what was covered previously.

The goal for this particular class is to review some concepts from beginner level 1 and introduce several new features in Excel.

Here's a breakdown of what we'll cover in this class:

Lesson 1 focuses on using the clipboard in Excel, especially the cut, copy, and paste commands.

Lesson 2 shows you how to use AutoFill so you can quickly copy information across multiple rows or columns.

Lesson 3 introduces you to cell formatting, including the different kinds of data you can have in a cell like text, numbers, currency, accounting, and both long and short date formats.

In lesson 4, we'll continue learning about formatting cells. This time, you'll see how to handle fractions, percentages, adjust decimal places, use the comma separator, and apply scientific notation.

Lesson 5 will teach you about managing rows and columns, including inserting and deleting them, and the difference between that and merely clearing the contents.

Lesson 6 is about working with worksheets. You'll learn how to add, delete, rename, move, copy, and change worksheet tab colors.

In lesson 7, you'll learn proper techniques to sort your data in Excel.

Lesson 8 moves on to conditional formatting, which lets you automatically change how cells look depending on their data. For example, you might color high values in red and low values in green.

Finally, lesson 9 shows you how to use the Find and Replace feature to quickly locate and change data within your spreadsheets.

If you need any help with the topics from today's lessons, please feel free to post your questions in the Excel Interactive Student forums. If you're watching the course in my custom video player or via the online web theater, you will find the forums appear next to the lesson videos as long as you have an internet connection. There you can read through questions and answers from other students and contribute your own. If you're not online, you can still access the forums later at ExcelLearningZone.com/forums.

For the best learning experience, I suggest you first watch each lesson all the way through without trying to work along on your own. Then, replay the lesson and follow along with my examples in Excel. Try recreating the same spreadsheets I build as you watch. Don't rush to apply these concepts to your own projects until you feel comfortable with the examples shown.

If you feel lost or if something is confusing, rewatch the video or leave a question in the student forums so I can help you.

Remember to keep an open mind. Excel might seem overwhelming at first, but once you get familiar with these tools, you'll find that it's much easier to work with than it appears.

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 cut, copy, and paste commands
Using the clipboard
Using AutoFill to copy data
Formatting cells as text, number, currency, accounting
Formatting cells with long and short dates
Working with cell formats for fractions
Formatting cells as percentages
Increasing and decreasing decimal points
Applying comma and scientific notation formats
Inserting and deleting rows and columns
Clearing row and column contents
Inserting, deleting, renaming, and moving worksheets
Copying and changing worksheet color
Sorting data in spreadsheets
Applying conditional formatting
Finding and replacing data in spreadsheets

Article

Welcome to this beginner-level Excel tutorial. In this lesson, we will focus on some of the essential spreadsheet skills you will need to become productive and comfortable with Excel. You will learn how to use cut, copy, and paste commands, manage the clipboard, work with AutoFill, format cells, manipulate rows and columns, handle worksheets, sort data, apply conditional formatting, and use the Find and Replace feature.

To start, it is important that you are familiar with the basics of the Excel interface, how to enter and edit data, basic cell formatting, simple math, saving, loading, and printing your documents. If any of these areas are still new to you, I recommend reviewing beginner materials before diving into this lesson.

Whether you are using a recent version of Excel or an older one, most of the topics we discuss here are widely applicable. However, if you are using a much older version, it may help to find resources specific to that version, as certain features may look different or be located elsewhere in the program.

My approach is to break Excel learning into several levels: beginner, expert, advanced, and developer. As a beginner, your main goal is to become comfortable with the interface and basic features, allowing you to create, edit, and manage basic spreadsheets.

Now, let's explore the key topics covered in this tutorial.

First, understanding how to use the clipboard in Excel is essential. The clipboard is a special area of memory where Excel stores information you cut or copy. When you use the 'cut' command, which you can access from the toolbar or by right-clicking and choosing 'Cut,' Excel removes the selected data from its current location and puts it on the clipboard. The 'copy' command does the same but leaves the original data in place. Once you have used either cut or copy, you can use the 'paste' command to place the data into a new location in your worksheet.

For example, suppose you have a list of names in column A and want to duplicate the list in column B. Select the range of cells in column A that contain the names, right-click and choose 'Copy,' then right-click the first cell in column B and choose 'Paste.' The names will appear in both columns. If instead you want to move the names, use 'Cut' rather than 'Copy.'

Next, AutoFill is a powerful tool that lets you quickly fill in data or patterns across multiple cells. For example, type 'Monday' in a cell, and then click and drag the fill handle (the small square at the corner of the cell) down or across. Excel will automatically fill in the subsequent days of the week. AutoFill also works for numbers, dates, and even custom patterns. You can try entering '1' in one cell and '2' in the cell below it. Select both cells, and then drag the fill handle. Excel will continue the sequence, creating a list of numbers.

Formatting cells is another essential skill. By default, Excel treats cell values as 'General,' but you can format them as text, numbers, dates, currency, accounting, and more. To change the format, select a cell or range of cells, right-click and choose 'Format Cells.' Here, you can choose from different categories, such as Number, Currency, Date, and Time. For example, if you are entering prices, you may want to use the Currency format so numbers display with the appropriate symbol.

You can format numbers as fractions, percentages, or even scientific notation. For instance, if you enter '.25' and format the cell as a percentage, Excel will display '25%.' Similarly, you can format a number like '12345' as scientific notation, which will display as '1.23E+04.' If you need fewer or more decimal points, use the increase or decrease decimal buttons on the ribbon.

Working with rows and columns gives you flexibility in organizing your data. To insert a new row, right-click a row number in the worksheet and select 'Insert.' Excel will add a new row above the selected location. Deleting a row requires right-clicking the row number and selecting 'Delete.' Note that inserting or deleting rows will move existing data accordingly, which is different from just clearing the contents of a row or column, which only removes the values without opening up space for more data.

Manipulating worksheets within your workbook helps you stay organized. You can add a new worksheet by clicking the plus sign next to the sheet tabs at the bottom. To rename a worksheet, double-click the sheet name and type a new one. You can also move worksheets by dragging their tabs or by right-clicking and selecting 'Move or Copy.' Changing the color of a worksheet tab can make your workbook easier to navigate, especially if you are working with many sheets. Just right-click the sheet tab, choose 'Tab Color,' and pick a color you prefer.

Sorting data is crucial when working with lists. To sort your data, select the range you want to sort, go to the 'Data' tab, and choose 'Sort.' You can choose to sort in ascending or descending order based on any column. For example, if you have a list of employee names and salaries, you can sort by salary from highest to lowest.

Conditional formatting allows you to apply formatting rules based on the values in your cells. For example, you might want cells with high values to be highlighted in red and low values in green. To use conditional formatting, select the cells you want to format, go to the 'Home' tab, click 'Conditional Formatting,' and choose a rule such as 'Greater Than,' 'Less Than,' or a color scale. Set your threshold or range, and Excel will automatically apply the format based on your criteria.

Finally, the Find and Replace feature can save you a lot of time when working with large spreadsheets. To find specific data, press Ctrl+F and enter your search term. Excel will highlight all matching cells. If you want to replace values, go to 'Replace' (Ctrl+H), enter both the value to find and the value to replace it with, and choose 'Replace All' or 'Replace' to update your data.

By learning these skills, you are building a strong foundation in Excel. Remember to experiment and repeat tasks to reinforce your understanding. If you make a mistake, use the Undo button or press Ctrl+Z. Excel may seem overwhelming at first, but with practice, you will become more confident and efficient in managing your data and creating effective spreadsheets. If you encounter challenges, revisiting these principles and practicing their application will help you master Excel step by step.

Primary Topics

clipboard operations, cut copy paste, autofill, cell formatting, working with rows and columns, worksheet management, sorting data, conditional formatting, find and replace

Secondary Topics

student forums, study techniques, course progression