About This Chapter
Data Entry in Excel: Chapter Summary
Watch the brief videos in these lessons and learn to create workbooks and templates in Excel. The lessons in this chapter explore techniques for entering and editing data, including numbers, words, dates and times, as well as show you how to use AutoFill and add comments to your spreadsheets. The videos also help you discover one of the best features of any software program - undo.
Our Excel experts will teach you tips and tricks for managing data as you master Excel. Complete the lessons at your own pace, and review any of the topics using the handy timeline feature. The lesson quizzes and chapter exam are great ways to see just how much you have learned. After completing this chapter, you should be able to:
- Create workbooks
- Enter and edit data
- Use AutoFill
- Work with dates and times
- Undo and redo actions
- Add and remove comments
- Use find and replace
(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools or displays may be different in other versions.)
Excel is a registered trademark of the Microsoft Corporation, which is not affiliated with Study.com.
1. Creating Workbooks in Excel: Blank Workbooks and Templates
With a program as powerful and useful as Excel, it is sometimes difficult to know where to start. In this lesson, we take a look at how to get to work with Excel, using both blank workbooks and templates.
2. Using the AutoFill Tool in Excel
If you want to make some of your common Excel tasks a bit easier and perform them with more efficiency, AutoFill is definitely a tool you should learn how to use. This lesson will guide you through the tool and how to take advantage of its features.
3. How to Use Undo & Redo in Excel
Everyone makes mistakes. Excel makes it easy to fix those mistakes with the undo and redo buttons. In this lesson, we learn how to not only make simple use of these buttons, but also go back further with a complex redo or undo.
4. How to Find and Replace Data in Excel
If you need to find a specific piece of information in a spreadsheet full of data, the search feature is mighty powerful. This lesson will guide you through how to use the Find and Find & Replace commands.
Earning College Credit
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.