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…