MS EXCEL-2010
Introduction
This section is for users with no knowledge of Excel.
Microsoft Excel is one of the most used software applications of all time. Hundreds of millions
of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and
perform financial, mathematical or statistical calculations.
Starting Excel 2010
Start All Programs Microsoft Office Microsoft Office Excel 2010
Or
Double Click the icon
Excel Interface
Tabs
Columns
Row
Cell
NOTE : All rights reserved. Prohibited all are given below.parts of this publication reproduced,edit,convert to file Page 1
format,resold,share (in Social media,app,mobile application,web site any other electronic media),make copy,publish in
books,recording.
, MS EXCEL-2010
Spreadsheets
A spreadsheet is an electronic document that stores various types of data. There are vertical columns
(16,384 {A – XFD}) and horizontal rows (1,048,576). A cell is where the column and row intersect. A
cell can contain data and can be used in calculations of data within the spreadsheet. An Excel spreadsheet
can contain workbooks and worksheets. The workbook is the holder for related worksheets.
Workbook
A Microsoft Excel workbook is a file that contains one or more worksheets (worksheet: The
primary document that you use in Excel to store and work with data. Also called a spreadsheet.
A worksheet consists of cells that are organized into columns and rows; a worksheet is always
stored in a workbook.)That you can use to organize various kinds of related information.
Ribbon
The ribbon is the panel at the top portion of the document It has seven tabs: Home, Insert,
Page Layouts, Formulas, Data, Review, and View. Each tab is divided into groups. The
groups are logical collections of features designed to perform function that you will utilize in
developing or editing your Excel spreadsheets.
Tabs
The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. The Home
tab contains the most frequently used commands in Excel.
Home: Clipboard, Fonts, Alignment, Number, Styles, Cells, Editing
Insert: Tables, Illustrations, Charts, Links, Text
Page Layouts: Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
Formulas: Function Library, Defined Names, Formula Auditing, Calculation
Data: Get External Data, Connections, Sort & Filter, Data Tools, Outline
Review: Proofing, Comments, Changes
View: Workbook Views, Show/Hide, Zoom, Window, Macros
NOTE : All rights reserved. Prohibited all are given below.parts of this publication reproduced,edit,convert to file Page 2
format,resold,share (in Social media,app,mobile application,web site any other electronic media),make copy,publish in
books,recording.
, MS EXCEL-2010
Quick Access Toolbar
The Quick Access Toolbar is a customizable toolbar
that contains a set of commands that are independent
of the tab that is currently displayed.
The Quick Access Toolbar can be located in one of two places:
Upper-left corner next to the icon for a Microsoft Office program, for example, next to the Word
icon. (default location)
Mini Toolbar
A new feature in office 2007 is the Mini
Toolbar. This is a floating toolbar that is
displayed when you select text or right-clicktext.
It displays common formatting tools, such as
bold, Italics, Fonts, Font size and Font color.
Workbook
1. Open an Existing Workbook
To open a workbook you've created in the past, execute the following steps.
1. Click on the green File tab.
What you see next is called the backstage view and it contains all the workbook related
commands.
2. Recent shows you a list of your recently used workbooks. You can quickly open a workbook
from here.
3. Click Open to open a workbook that is not on the list.
NOTE : All rights reserved. Prohibited all are given below.parts of this publication reproduced,edit,convert to file Page 3
format,resold,share (in Social media,app,mobile application,web site any other electronic media),make copy,publish in
books,recording.
, MS EXCEL-2010
2. Save a Workbook
When you save a workbook, you have 2 choices: Save or Save as.
To save a document:
By default, the Microsoft Office programs save a file in a default working folder. If you want,
you can specify a different location.
1.Click the File tab, and then click Save, or press CTRL+S.
Tip Click the Save icon on the Quick Access Toolbar.
2.You must enter a name for the file if you are saving it for the first time.
Save as
1. Click the File tab.
2. Click Save As.
3. In the File Name box, enter a name for the file, if you haven't already.
4. In the Save as type list, click PDF (*.pdf) or XPS Document (*.xps).
If you want the file to open in the selected format after saving, select the
Open file after publishing check box.
If the document requires high print quality, click Standard (publishing online
and printing).
If file size is more important than print quality, click Minimum size
(publishing online).
5. Click Options to set the page to be printed, to choose whether markup should be
printed, and to select output options. Click OK when finished.
6. Click Save.
3. Close a Workbook
If you are new to Excel, it's good to know the difference between closing a workbook and
closing Excel. This can be confusing in the beginning.
1. To close an Excel workbook, click the lower X.
NOTE : All rights reserved. Prohibited all are given below.parts of this publication reproduced,edit,convert to file Page 4
format,resold,share (in Social media,app,mobile application,web site any other electronic media),make copy,publish in
books,recording.
Introduction
This section is for users with no knowledge of Excel.
Microsoft Excel is one of the most used software applications of all time. Hundreds of millions
of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and
perform financial, mathematical or statistical calculations.
Starting Excel 2010
Start All Programs Microsoft Office Microsoft Office Excel 2010
Or
Double Click the icon
Excel Interface
Tabs
Columns
Row
Cell
NOTE : All rights reserved. Prohibited all are given below.parts of this publication reproduced,edit,convert to file Page 1
format,resold,share (in Social media,app,mobile application,web site any other electronic media),make copy,publish in
books,recording.
, MS EXCEL-2010
Spreadsheets
A spreadsheet is an electronic document that stores various types of data. There are vertical columns
(16,384 {A – XFD}) and horizontal rows (1,048,576). A cell is where the column and row intersect. A
cell can contain data and can be used in calculations of data within the spreadsheet. An Excel spreadsheet
can contain workbooks and worksheets. The workbook is the holder for related worksheets.
Workbook
A Microsoft Excel workbook is a file that contains one or more worksheets (worksheet: The
primary document that you use in Excel to store and work with data. Also called a spreadsheet.
A worksheet consists of cells that are organized into columns and rows; a worksheet is always
stored in a workbook.)That you can use to organize various kinds of related information.
Ribbon
The ribbon is the panel at the top portion of the document It has seven tabs: Home, Insert,
Page Layouts, Formulas, Data, Review, and View. Each tab is divided into groups. The
groups are logical collections of features designed to perform function that you will utilize in
developing or editing your Excel spreadsheets.
Tabs
The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. The Home
tab contains the most frequently used commands in Excel.
Home: Clipboard, Fonts, Alignment, Number, Styles, Cells, Editing
Insert: Tables, Illustrations, Charts, Links, Text
Page Layouts: Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
Formulas: Function Library, Defined Names, Formula Auditing, Calculation
Data: Get External Data, Connections, Sort & Filter, Data Tools, Outline
Review: Proofing, Comments, Changes
View: Workbook Views, Show/Hide, Zoom, Window, Macros
NOTE : All rights reserved. Prohibited all are given below.parts of this publication reproduced,edit,convert to file Page 2
format,resold,share (in Social media,app,mobile application,web site any other electronic media),make copy,publish in
books,recording.
, MS EXCEL-2010
Quick Access Toolbar
The Quick Access Toolbar is a customizable toolbar
that contains a set of commands that are independent
of the tab that is currently displayed.
The Quick Access Toolbar can be located in one of two places:
Upper-left corner next to the icon for a Microsoft Office program, for example, next to the Word
icon. (default location)
Mini Toolbar
A new feature in office 2007 is the Mini
Toolbar. This is a floating toolbar that is
displayed when you select text or right-clicktext.
It displays common formatting tools, such as
bold, Italics, Fonts, Font size and Font color.
Workbook
1. Open an Existing Workbook
To open a workbook you've created in the past, execute the following steps.
1. Click on the green File tab.
What you see next is called the backstage view and it contains all the workbook related
commands.
2. Recent shows you a list of your recently used workbooks. You can quickly open a workbook
from here.
3. Click Open to open a workbook that is not on the list.
NOTE : All rights reserved. Prohibited all are given below.parts of this publication reproduced,edit,convert to file Page 3
format,resold,share (in Social media,app,mobile application,web site any other electronic media),make copy,publish in
books,recording.
, MS EXCEL-2010
2. Save a Workbook
When you save a workbook, you have 2 choices: Save or Save as.
To save a document:
By default, the Microsoft Office programs save a file in a default working folder. If you want,
you can specify a different location.
1.Click the File tab, and then click Save, or press CTRL+S.
Tip Click the Save icon on the Quick Access Toolbar.
2.You must enter a name for the file if you are saving it for the first time.
Save as
1. Click the File tab.
2. Click Save As.
3. In the File Name box, enter a name for the file, if you haven't already.
4. In the Save as type list, click PDF (*.pdf) or XPS Document (*.xps).
If you want the file to open in the selected format after saving, select the
Open file after publishing check box.
If the document requires high print quality, click Standard (publishing online
and printing).
If file size is more important than print quality, click Minimum size
(publishing online).
5. Click Options to set the page to be printed, to choose whether markup should be
printed, and to select output options. Click OK when finished.
6. Click Save.
3. Close a Workbook
If you are new to Excel, it's good to know the difference between closing a workbook and
closing Excel. This can be confusing in the beginning.
1. To close an Excel workbook, click the lower X.
NOTE : All rights reserved. Prohibited all are given below.parts of this publication reproduced,edit,convert to file Page 4
format,resold,share (in Social media,app,mobile application,web site any other electronic media),make copy,publish in
books,recording.
