Office 2013 Digital Classroom

Excel Lesson 2: Creating a Worksheet in Excel 2013

In this lesson, you will learn how to create a worksheet in Excel. You will enter data, including text, numbers, dates and times and then edit that data. Additionally, you’ll learn to rearrange data with Copy and Paste. You’ll add worksheets, insert columns and rows, and learn how to scroll through a large worksheet. Finally, you’ll learn how to save files, open existing worksheets, and print your worksheet.

What you’ll learn in this lesson:

• • Creating a new worksheet
• • Entering and editing data in a cell
• • Saving a workbook file
• • Selecting a range of cells
• • Inserting rows and columns
• • Printing a worksheet

Starting up

You will work with files from the Excel02lessons folder. Make sure that you have loaded the OfficeLessons folder onto your hard drive from www.digitalclassroombooks.com/Office2013. If you need further instructions, see “Loading lesson files” in the Starting up section of this book.

Creating a worksheet

In this first lesson, we will create a new blank workbook to practice some basic data entry skills.

Creating a new workbook

1 Launch Microsoft Excel.

2 Choose Blank workbook from the New Backstage.

Excel 2013 offers thousands of predesigned templates to choose from. Choose Blank Workbook to start from scratch. ...