Skip to Main Content
Office 2013 Digital Classroom
book

Office 2013 Digital Classroom

by Walter Holland, AGI Creative Team
August 2013
Beginner content levelBeginner
672 pages
14h 31m
English
Wiley
Content preview from Office 2013 Digital Classroom

Excel Lesson 2: Creating a Worksheet in Excel 2013

ex02.psd

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.

101041.jpg

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Word 2007 Step by Step

Microsoft® Office Word 2007 Step by Step

Joyce Cox and Joan Lambert
Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg

Publisher Resources

ISBN: 9781118571613Purchase bookOther