Ch 2: Data Entry in Excel

About This Chapter

Take your basic Excel skills to the next level as you learn to enter and manipulate data. The engaging videos in this chapter provide guidance as you master this spreadsheet software.

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

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

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? 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.

Other Chapters

Other chapters within the Microsoft Excel Certification: Practice & Study Guide course