, ,

9. Basics: Copying a Worksheet

First of all, let us create some sample text before we proceed. Open a new excel sheet and type any data. We've shown a sample data in the screenshot.OrderDate Region Rep Item Units Unit Cost Total1/6/2010 East Jones Pencil 95 1.99 189.051/23/2010 Central Kivell Binder 50 19.99 999.52/9/2010 Central Jardine Pencil 36 4.99 179.642/26/2010 Central Gill Pen 27 19.99 539.733/15/2010 West Sorvino Pencil 56 2.99 167.444/1/2010 East Jones Binder 60 4.99 299.44/18/2010 Central Andrews Pencil 75 1.99 149.255/5/2010 Central Jardine Pencil 90 4.99 449.15/22/2010 West Thompson Pencil 32 1.99 63.686/8/2010 East Jones Binder 60 8.99 539.46/25/2010 Central Morgan Pencil 90 4.99 449.17/12/2010 East Howard Binder 29 1.99 57.717/29/2010 East Parent Binder 81 19.99 1,619.198/15/2010 East Jones Pencil 35 4.99 174.65Here…
, ,

8. Basics: Saving a Workbook

Saving New Sheet Once you are done with typing in your new excel sheet, it is time to save your sheet/workbook to avoid losing work you have done on an Excel sheet. Following are the steps to save an edited excel sheet −Step 1 − Click…
, ,

7. Basics: Creating New Worksheet

Creating New Worksheet Three new blank sheets always open when you start Microsoft Excel. Below steps explain you how to create a new worksheet if you want to start another new worksheet while you are working on a worksheet, or you closed an…
, ,

6. Basics: Moving around in Excel

Excel provides a number of ways to move around a sheet using the mouse and the keyboard.First of all, let us create some sample text before we proceed. Open a new excel sheet and type any data. We've shown a sample data in the screenshot.OrderDate Region Rep Item Units Unit…
, ,

5. Basics: Entering Values in Cell

Entering values in excel sheet is a child’s play and this chapter shows how to enter values in an excel sheet. A new sheet is displayed by default when you open an excel sheet as shown in the below screen shot.Sheet area is the place…
, ,

4. Basics: Exploring Backstage View in Excel

The Backstage view has been introduced in Excel 2010 and acts as the central place for managing your sheets. The backstage view helps in creating new sheets, saving and opening sheets, printing and sharing sheets, and so on.Getting to…
, ,

3. Basics: Exploring Excel

The following basic window appears when you start the excel application. Let us now understand the various important parts of this window.File Tab The File tab replaces the Office button from Excel 2007. You can click it to check the Backstage…
, ,

2. Basics: Getting Started with Excel

This chapter teaches you how to start an excel 2010 application in simple steps. Assuming you have Microsoft Office 2010 installed in your PC, start the excel application following the below mentioned steps in your PC.Step 1 − Click on…
, ,

1. Introduction to Microsoft Office Excel

Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac…