What is Microsoft
Excel?
Excel is an
integrated electronic spreadsheet or worksheet, is developed by Microsoft
Corporation.
What is Spreadsheet?
It is Electronic
worksheet package used for as software tools for data analysis. It allows users
to quickly create, manipulate and analyze data organized in columns and rows. A
spreadsheet is, therefore, actually a sheet of paper containing rows and columns
in which data can be entered, manipulated and analyzed. When a computer
prepares a spreadsheet, it is known as electronic spreadsheet.
What is Cell?
Cross-section of row
and column is called as Cell. Each cell has unique cell number in a
spreadsheet. It is standardized as column name with row number. For example A1
means the column is A and Row number is 1.
What is active cell?
The selected cell or
starting selection cell is called as active cell.
What is Label?
The content of cell
can be classified as Label. It is used for headings, titles and description.
What is Value?
A value is number or
data to be analyzed or manipulated.
What is formula?
Formula is a process
that helps to calculate the data. It always begins with ‘=’ sign.
What is Function?
Function is a set of
predefined instruction that helps to calculate a certain value.
What is Row?
The horizontal
section of a spreadsheet is called as Row.
How many rows are
available in excel?
In excel 2003 it is
65536 rows are available but in 2007, 2010 and 2013 it is 1,048,576.
What is Column?
The vertical section
of a spreadsheet is called as column.
What is many columns
are available in excel?
In excel 2003 it is
256 Rows are available but in 2007, 2010 and 2013 it is 16,384.
What is relative
reference?
On dragging the cell
reference and numbers are changed automatically on a spreadsheet. There is no
need to define the formula for each cells or columns or rows. It is called as
relative reference.
What is absolute
reference?
There is a condition
when the one cell reference must be changed automatically but other shouldn’t
change its reference. This is called as absolute reference.
Important
Shortcut Keys
1. Navigate Inside Worksheets
Arrow Keys Move
one cell up, down, left, or right in a
worksheet.
Page Down/Page Up Move
one screen down / one screen up in a
worksheet.
Alt+Page Down/Alt+Page Up Move
one screen to the right / to the left in a
worksheet.
Tab/Shift+Tab Move
one cell to the right / to the left in a
worksheet.
Ctrl+Arrow Keys Move
to the edge of next data region (cells that
contains
data)
Home Move
to the beginning of a row in a worksheet.
Ctrl+Home Move
to the beginning of a worksheet.
Ctrl+End Move
to the last cell with content on a worksheet.
Ctrl+f Display
the Find and Replace dialog box (with Find
selected).
Ctrl+h Display
the Find and Replace dialog box (with
Replace
selected).
Shift+F4 Repeat
last find.
Ctrl+g (or f5) Display
the 'Go To' dialog box.
Ctrl+Arrow Left/Ctrl+Arrow Right Inside
a cell: Move one word to the left / to the
right.
Home/End Inside
a cell: Move to the beginning / to the end of a
cell
entry.
Alt+Arrow Down Display
the AutoComplete list e.g. in cell with
dropdowns
or autofilter.
End Turn
'End' mode on. In End mode, press arrow keys
to
move to the next nonblank cell in the same
column
or row as the active cell. From here use
arrow
keys to move by blocks of data, home to
move
to last cell, or enter to move to the last cell to
the
right.
2. Work with Data Selections
Select Cells
Shift+Space Select
the entire row.
Ctrl+Space Select
the entire column.
Ctrl+Shift+* (asterisk) Select
the current region around the active cell.
Ctrl+a (or ctrl+Shift+spacebar) Select
the entire worksheet or the data-containing
area.
Pressing ctrl+a a second time then selects
entire
worksheet.
Ctrl+Shift+Page Up Select
the current and previous sheet in a workbook.
Ctrl+Shift+o Select
all cells with comments.
Shift+Arrow Keys Extend
the selection by one cell.
Ctrl+Shift+Arrow Key Extend
the selection to the last cell with content in
row
or column.
Shift+Page Down/Shift+Page Up Extend
the selection down one screen /up one
screen.
Shift+Home Extend
the selection to the beginning of the row.
Ctrl+Shift+Home Extend
the selection to the beginning of the
worksheet.
Ctrl+Shift+End Extend
the selection to the last used cell on the
worksheet
(lower-right corner).
Manage Active Selections
F8 Turn
on extension of selection with arrow keys
without
having to keep pressing shift.
Shift+F8 Add
another (adjacent or non-adjacent) range of
cells
to the selection. Use arrow keys and
shift+arrow
keys to add to selection.
Shift+Backspace Select
only the active cell when multiple cells are
selected.
Ctrl+Backspace Show
active cell within selection.
Ctrl+. (period) Move
clockwise to the next corner of the selection.
Enter/Shift+Enter Move
active cell down / up in a selection.
Tab/Shift+Tab Move
active cell right / left in a selection.
Ctrl+Alt+Arrow Right
/Ctrl+Alt+Arrow Left Move to the right / to the left between
non-
adjacent
selections (with multiple ranges selected).
Esc Cancel
Selection.
Select inside cells
Shift+Arrow Left
/Shift+Arrow Right Select
or unselect one character to the left / to the
right.
Ctrl+Shift+Arrow Left
/Ctrl+Shift+Arrow Right Select
or unselect one word to the left / to the right.
Shift+Home/Shift+End Select
from the insertion point to the beginning / to
the
end of the cell.
3. Insert and Edit Data
Undo / Redo Shortcuts
Ctrl+z Undo
last action (multiple levels).
Ctrl+y Redo
last action (multiple levels).
Work with Clipboard
Ctrl+c Copy
contents of selected cells.
Ctrl+x Cut
contents of selected cells.
Ctrl+v Paste
content from clipboard into selected cell.
Ctrl+Alt+v If
data exists in clipboard: Display the Paste Special dialog box.
Ctrl+Shift+[+] If
data exists in clipboard: Display the Insert dialog
box
to insert blank cells.
Edit Inside Cells
F2 Edit
the active cell with cursor at end of the line.
Alt+Enter Start
a new line in the same cell.
Enter Complete
a cell entry and move down in the
selection.
With multiple cells selected: fill cell
range
with current cell.
Shift+Enter Complete
a cell entry and move up in the selection.
Tab/Shift+Tab Complete
a cell entry and move to the right / to the left in the selection.
Esc Cancel
a cell entry.
Backspace Delete
the character to the left of the insertion point,
or
delete the selection.
Delete Delete
the character to the right of the insertion
point,
or delete the selection.
Ctrl+Delete Delete
text to the end of the line.
Ctrl+; (semicolon) Insert
current date.
Ctrl+Shift+: (colon) Insert
current time.
Edit Active or Selected Cells
Ctrl+d Fill
complete cell down (Copy above cell).
Ctrl+r Fill
complete cell to the right (Copy cell from the
left).
Ctrl+" Fill
cell values down and edit (Copy above cell
values).
Ctrl+' (apostrophe) Fill
cell formulas down and edit (Copy above cell
formulas).
Ctrl+l Insert
a table (display Create Table dialog box).
Ctrl+- Delete
Cell/Row/Column Menu
Ctrl+- with row
/column selected Delete
row / delete column.
Ctrl+Shift++ Insert
Cell/Row/Column Menu
Ctrl+Shift++ with row
/column selected Insert
row/ insert column.
Shift+F2 Insert
/ Edit a cell comment.
Shift+f10, then m Delete
comment.
Alt+F1 Create
and insert chart with data in current range as
embedded
Chart Object.
F11 Create
and insert chart with data in current range in
a
separate Chart sheet.
Ctrl+k Insert
a hyperlink.
enter (in a cell with a hyperlink) Activate
a hyperlink.
Hide and Show Elements
Ctrl+9 Hide
the selected rows.
Ctrl+Shift+9 Unhide
any hidden rows within the selection.
Ctrl+0 (zero) Hide
the selected columns.
Ctrl+Shift+0 (zero) Unhide
any hidden columns within the selection*.
Ctrl+` (grave accent) Alternate
between displaying cell values and
displaying
cell formulas. Accent grave /not a
quotation
mark.
Alt+Shift+Arrow Right Group
rows or columns.
Alt+Shift+Arrow Left Ungroup
rows or columns.
Ctrl+6 Alternate
between hiding and displaying objects.
Ctrl+8 Display
or hides the outline symbols.
Ctrl+6 Alternate
between hiding objects, displaying
objects,
and displaying placeholders for objects.
*Does not seem to work anymore in Excel 2010. Detailed explanation
here:
http://superuser.com/questions/183197/whats-the-keyboard-shortcut-to-unhide-a-column-in-excel-2010
why.
Adjust Column Width and Row Height
Note: there are no default shortcuts for this, but workaround
through access keys from previous versions
Alt+o, ca Adjust
Column width to fit content. Select complete
column
with Ctrl+Space first, otherwise column
adjusts
to content of current cell). Remember
Format,
Column Adjust.
Alt+o, cw Adjust
Columns width to specific value: Option,
Cow,
width
Alt+o, ra Adjust
Row height to fit content: Option, Row,
Adjust
Alt+o, re Adjust
Row height to specific value: Option, Row,
Height
4. Format Data
Format Cells
Ctrl+1 Format
cells dialog.
Ctrl+b (or ctrl+2) Apply
or remove bold formatting.
Ctrl+i (or ctrl+3) Apply
or remove italic formatting.
Ctrl+u (or ctrl+4) Apply
or remove an underline.
Ctrl+5 Apply
or remove strikethrough formatting.
Ctrl+Shift+f Display
the Format Cells with Fonts Tab active.
Press
tab 3x to get to font-size. Used to be
ctrl+shift+p,
but that seems just get to the Font Tab
in
2010.
Alt+' (apostrophe / single quote) Display
the Style dialog box.
Number Formats
Ctrl+Shift+$ Apply
the Currency format with two decimal
places.
Ctrl+Shift+~ Apply
the General number format.
Ctrl+Shift+% Apply
the Percentage format with no decimal
places.
Ctrl+Shift+# Apply
the Date format with the day, month, and
year.
Ctrl+Shift+@ Apply
the Time format with the hour and minute,
and
indicate A.M. or P.M.
Ctrl+Shift+! Apply
the Number format with two decimal places,
thousands
separator, and minus sign (-) for negative
values.
Ctrl+Shift+^ Apply
the Scientific number format with two
decimal
places.
F4 Repeat
last formatting action: Apply previously
applied
Cell Formatting to a different Cell
Apply Borders to Cells
Ctrl+Shift+& Apply
outline border from cell or selection
Ctrl+Shift+_ (underscore) Remove
outline borders from cell or selection
Ctrl+1, then Ctrl+Arrow Right
/Arrow Left Access
border menu in 'Format Cell' dialog. Once
border
was selected, it will show up directly on the
next
Ctrl+1
Alt+t* Set
top border
Alt+b* Set
bottom Border
Alt+l* Set
left Border
Alt+r* Set
right Border
Alt+d* Set
diagonal and down border
Alt+u* Set
diagonal and up border
*In Cell Format in 'Border' Dialog Window
Align Cells
Alt+h, ar Align
Right
Alt+h, ac Align
Center
Alt+h, al Align
Left
5. Formulas and Names
Formulas
= Start
a formula.
Alt+= Insert
the AutoSum formula.
Shift+F3 Display
the Insert Function dialog box.
Ctrl+a Display
Formula Window after typing formula
name.
Ctrl+Shift+a Insert
Arguments in formula after typing formula
name.
.
Shift+F3 Insert
a function into a formula .
Ctrl+Shift+Enter Enter
a formula as an array formula.
F4 After
typing cell reference (e.g. =E3) makes
reference
absolute (=$E$4)
F9 Calculate
all worksheets in all open workbooks.
Shift+F9 Calculate
the active worksheet.
Ctrl+Alt+F9 Calculate
all worksheets in all open workbooks,
regardless
of whether they have changed since the
last
calculation.
Ctrl+Alt+Shift+F9 Recheck
dependent formulas, and then calculates all
cells
in all open workbooks, including cells not
marked
as needing to be calculated.
Ctrl+Shift+u Toggle
expand or collapse formula bar.
Ctrl+` Toggle
Show formula in cell instead of values
Names
Ctrl+F3 Define
a name or dialog.
Ctrl+Shift+F3 Create
names from row and column labels.
F3 Paste
a defined name into a formula.
6. Manage Multipe Worksheets
Shortcuts to delete, rename, or move worksheets are based on the
old Excel 2003 menus which still work in Excel 2010.
Shift+F11/Alt+Shift+F1 Insert
a new worksheet in current workbook.
Ctrl+Page Down/Ctrl+Page Up Move
to the next / previous worksheet in current
workbook.
Shift+Ctrl+Page Down/Shift+Ctrl+Page Up Select the current and next sheet(s) / select
and
previous sheet(s).
Alt+o then h r Rename
current worksheet (format, sheet, rename)
Alt+e then l Delete
current worksheet (Edit, delete)
Alt+e then m Move
current worksheet (Edit, move)
7. Manage Multiple Workbooks
F6/Shift+F6 Move
to the next pane / previous pane in a workbook that has been
split.
Ctrl+F4 Close
the selected workbook window.
Ctrl+n Create
a new blank workbook (Excel File)
Ctrl+Tab/Ctrl+Shift+Tab Move
to next / previous workbook window.
Alt+Space Display
the Control menu for Main Excel window.
Ctrl+F9 Minimize
current workbook window to an icon. Also restores ('un-
maximizes')
all workbook windows.
Ctrl+F10 Maximize
or restores the selected workbook window.
Ctrl+F7 Move
Workbook Windows which are not maximized.
Ctrl+F8 Perform
size command for workbook windows which are not
maximzed.
Alt+F4 Close
Excel.
8. Various Excel Features
Ctrl+o Open
File.
Ctrl+s Save
the active file with its current file name, location, and file
format.
F12 Display
the Save As dialog box.
f10 (or alt) Turn
key tips on or off.
Ctrl+p Print
File (Opens print menu).
F1 Display
the Excel Help task pane.
F7 Display
the Spelling dialog box.
Shift+F7 Display
the Thesaurus dialog box.
Alt+F8 Display
the Macro dialog box.
Alt+F11 Open
the Visual Basic Editor to create Macros.
9. Work with the Excel Ribbon
Ctrl+F1 Minimize
or restore the Ribbon.s
Alt/F10 Select
the active tab of the Ribbon and activate the access keys. Press either of
these keys again to move back to the document and cancel the access keys. and
then arrow left or arrow right
Shift+F10 Display
the shortcut menu for the selected command.
Space/Enter Activate
the selected command or control in the Ribbon, Open the
selected
menu or gallery in the Ribbon..
Enter Finish
modifying a value in a control in the Ribbon, and move
focus
back to the document.
F1 Get
help on the selected command or control in the Ribbon. (If no Help topic is
associated with the selected command, the Help table of contents for that
program is shown instead.)
10. Data Forms
Tab/Shift+Tab Move
to the next / previous field which can be edited.
Enter/Shift+Enter Move
to the first field in the next / previous record.
Page Down/Page Up Move
to the same field 10 records forward / back.
Ctrl+Page Down Move
to a new record.
Ctrl+Page Up Move
to the first record.
Home/End Move
to the beginning / end of a field.
11. Pivot Tables
Arrow Keys Navigate
inside Pivot tables.
Home/End Select
the first / last visible item in the list.
Alt+c Move
the selected field into the Column area.
Alt+d Move
the selected field into the Data area.
Alt+l Display
the PivotTable Field dialog box.
Alt+p Move
the selected field into the Page area.
Alt+r Move
the selected field into the Row area.
Ctrl+Shift+* (asterisk) Select
the entire PivotTable report.
arrow keys to select the cell that contains the field, and then
alt+Arrow Down Display the list for
the current field in a PivotTable report.
arrow keys to select the page field in a PivotChart report, and
then alt+Arrow Down Display the
list for the current page field in a PivotChart report.
Enter Display
the selected item.
Space Select
or clear a check box in the list.
Ctrl+tab ctrl+Shift+Tab select
the PivotTable toolbar.
enter then arrow down /Arrow Up On
a field button: select the area you want to move the selected
field
to.
Alt+Shift+Arrow Right Group
selected PivotTable items.
Alt+Shift+Arrow Left Ungroup
selected PivotTable items.
12. The Rest
Dialog Boxes
Arrow Keys Move
between options in the active drop-down list box or between
some
options in a group of options.
Ctrl+Tab/Ctrl+Shift+Tab Switch
to the next/ previous tab in dialog box.
Space In
a dialog box: perform the action for the selected button, or
select/clear
a check box.
Tab/Shift+Tab Move
to the next / previous option.
a ... z Move
to an option in a drop-down list box starting with the letter
Alt+a ... alt+z Select
an option, or select or clear a check box.
Alt+Arrow Down Open
the selected drop-down list box.
Enter Perform
the action assigned to the default command button in the dialog box.
Esc Cancel
the command and close the dialog box.
Auto Filter
Alt+Arrow Down On
the field with column head, display the AutoFilter list for the
current
column .
Arrow Down/Arrow Up Select
the next item / previous item in the AutoFilter list.
Alt+Arrow Up Close
the AutoFilter list for the current column.
Home/End Select
the first item / last item in the AutoFilter list.
Enter Filter
the list by using the selected item in the AutoFilter list.
Ctrl + Shift + L Apply
filter on selected column headings.
Work with Smart Art Graphics
Arrow Keys Select
elements.
Esc Remove
Focus from Selection.
F2 Edit
Selection Text in if possible (in formula bar).
Microsoft Excel Practical 2003
File:
New: To Create A New Workbook/ File In
Excel.
XTÇöX Zõç+_ éTöÌ[ýÝ EõÌ[ýçÌ[ý LXî*
Steps: File→ New.
Open: To Open An Existing Excel File
%çãG åUãEõ åa\ö EõãÌ[ý Ì[ýçFç åEõçX Zõç+_ åFç_çÌ[ý LXî *
Steps: File – Open – Select The
File – Open.
Close: To Close The Current File (With
Shift Key You Can Have ‘Close All’.
Zõç+_×»OôãEõ [ýµù EõÌ[ýçÌ[ý LXî*
Steps: File – Close / Close All.
Save: To Save Or Modify A File.
åEõçX Zõç+_åEõ Eõ׶Y=»OôçãÌ[ý aeÌ[ý×lùTö EõÌ[ýçÌ[ý LXî *
Steps: File – Save – File Name –
Save.
Save As:
To Save Another Copy Of The File.
åEõçX Zõç+_ãEõ %ç_çVç Xçã] [ýç %ç_çVç LçÌ^GçÌ^ åa\ö
EõÌ[ýçÌ[ý LXî *
Steps: Steps: File – Save As –
New File Name – Save.
Save As Webpage: To Save The File As Html Page
For Publishing Into The Internet
åEõçX Zõç+_ãEõ +³OôçÌ[ýãXä»OôÌ[ý =Y^ÇNþ
åYL ×c÷açã[ý åa\ö EõÌ[ýçÌ[ý LXî*
Steps: File – Save As Webpage –
Add Inter Activity – Any File Name – Save.
Save Workspace: To Save Multiple Files Within
One File.
%ãXEõm×_ Zõç+_ãEõ AEõ×»Oô =+ã³QöçÌ[ý
]ãWýî ×XãÌ^ Aãa EõçL EõÌ[ýçÌ[ý LXî*
Steps: File – Open – Select Some
Excel Files – Open – File – Save Workspace – Any Name – Save. File – Close All
. File – Open - Select The Workspace
File – Open. Window – Arrange – Tiled – Ok.
Page Setup: To Set The Page To Make Some
Print Out.
EõçL EõÌ[ýçÌ[ý %çãG %U[ýç ×YÒ³Oô EõÌ[ýçÌ[ý %çãG
åYL×»OôãEõ aç×LãÌ^ åXCÌ^çÌ[ý LXî *
Steps: File – Page Setup – Page –
Portrait/Landscape – Margin – Top = Bottom = Left = Right = 1” – Ok.
Print Area: To Set / Discard The
Selected Printing Area.
ãaã_kô EõÌ[ýç %e`ãEõ ×YÒ³Oô EõÌ[ýçÌ[ý
[ýî[ýØšöç EõÌ[ýç*
Steps : Select The Cells – File –
Print Area – Set Print Area. File –
Print Preview – Close.
To Clear The Print Area : File –
Print Area – Clear Print Area.
Print Preview: To View The Page Before The
Print Out
EõçGãL »K÷çYçÌ[ý %çãG åVãF åXCÌ^ç å^
×YÒ³Oô×»Oô åEõ]X c÷ã[ý*
Steps: File - Print Preview.
Send To: To Send The Data To Another
Microsoft/Internet Application.
%Xî åEõçX %îç×YÀãEõ`ãX
QöEÇõã]³Oô×»OôãEõ YçPöçãXçÌ[ý LXî *
Steps: File – Send To – Microsoft
PowerPoint.
Properties: To Get The General Information
About The Files.
åEõçX Zõç+_ AÌ[ý açWýçÌ[ýX TöUî
YçCÌ^çÌ[ý LXî*
Steps: File – Properties –
General/Summery/Statistics/Content – Ok.
Print : To Make Some Printouts On The
Page.
EõçGãLÌ[ý =YÌ[ý ×YÒ³Oô%çC»Oô EõÌ[ýçÌ[ý LXî *
Steps: File - Print - Number Of Copies = 1 – Ok.
Exit: To Close The Microsoft Excel.
]ç+ãyÔçaZõ»Oô CÌ^çQïö [ýµù EõÌ[ýçÌ[ý LXî*
Steps: File – Exit.
Edit
Undo: One Step Backward.
AEõYV ×Y»K÷ãX ^çCÌ^çÌ[ý LXî*
Steps: Edit – Undo.
Repeat/ Redo : One Step Forward.
AEõYV aç]ãX ^çCÌ^çÌ[ý LXî*
Steps: Edit – Repeat/ Redo.
Cut: To Cut And Paste The Text / Object To The Desired Position. Once
You Cut An Object You Can Paste It Many Times If It Is Available On Clipboard.
åEõä»Oô ×XãÌ^ Y×Ì[ý[ý×TöÛTö LçÌ^GçÌ^ Ì[ýçFçÌ[ý LXî*
Steps: Select The Cells – Edit –
Cut – Select The Position – Edit – Paste.
Copy: To Create Another Copy Of The
Same Text. Once You Cut An Object You Can Paste It Many Times If It Is
Available On Clipboard.
YÒçÌ^ AEõ+ Ì[ýEõ] åVFãTö %çãÌ[ýç AEõ×»Oô æ»OôEËõºOô
éTöÌ[ýÝ EõÌ[ýçÌ[ý LXî*
Steps: Select The Cells – Edit –
Copy – Select The Position – Edit – Paste.
Paste: After Cut Or Copy You Can Get
The Result With The Paste.
Eõç»Oô %U[ýç Eõ×Y EõÌ[ýçÌ[ý YãÌ[ý ^UçØšöçãX Ì[ýçFçÌ[ý LXî*
Steps: Edit – Paste
Office Clipboard: To Copy Multiple Objects Within
A Clip Board.
AEõç×VEõ ×[ýbÌ^ C æ»Oôj»Oô åEõ
×zõYã[ýçãQïö TÇöã_ Ì[ýçFçÌ[ý LXî*
Steps: Edit – Office Clipboard –
Edit – Copy.
Paste Special: To Create A Link Between To Copy
& Pasted Area. If Any Chages Occurred In Mother Sheet (Copied) Then All
Changes Are Available In Child Sheet (Pasted) Also.
VÇ×»Oô Eõ×Y C åYºOô EõÌ[ýç aÝä»OôÌ[ý
]ãWýî å^çGçã^çG éTöÌ[ýÝ EõÌ[ýçÌ[ý LXî ^çãTö AEõ×»Oô Yç·Oôçã_ %çÌ[ýC AEõ×»Oô
aÌ^e×yÔÌ^\öçã[ý Yçä·Oô ^çã[ý Töã[ý Eõ×Y åUãEõ åYºOô å&`ç_ EõÌ[ýç aÝä»OôåTö
A»Oôç c÷Ì^* åYºOô å&`ç_ EõÌ[ýç aÝä»OôåTö åEõçX Y×Ì[ý[ýTöÛX c÷ã_ %ça_ aÝä»Oô
åEõçX Y×Ì[ý[ýTöÛX c÷ã[ý Xç*
Steps: Select The Cells – Edit –
Copy – Sheet 2 – Edit – Paste Special – Paste Link.
Fill: To Fill Some Cells With Same
Number (1,1,1,1) Or Value Or Series As
(1,2,3….)
AEõ+ X¶‘öÌ[ý [ýç yÔ] aeFîç ¥çÌ[ýç
åa_m×_ãEõ \öÌ[ýçÌ[ý LXî*
Steps: Write Any Number In Any
Cell – Select Some More Cell Downwards – Edit – Fill – Down.
Steps: Write Any Number In Any
Cell – Select Some More Cell Downwards – Edit – Fill – Series – Step Value =1 –
Ok.
Clear: To Clear Out The Colors, Values
Or Any Modification.
Eõãaã_Ì[ý TöUî m×_ãEõ XçXX \öçã[ý
å]ç»K÷çÌ[ý LXî*
Steps: Select The Area - Edit –
Clear – All. (Everything Will Be Wiped Out)
Select The Area - Edit – Clear –
Formats. (Formatting Will Be Wiped Out)
Select The Area - Edit – Clear –
Contents. (Values Will Be Wiped Out)
Select The Area - Edit – Clear –
Comments. (Comments Will Be Wiped Out)
Delete: To Erase A Selected Row Or
Column Or Cell.
AEõ×»Oô åÌ[ýç [ýç Eõ_ç] åEõ å]ç»K÷çÌ[ý
LXî*
Steps: Select The Row/Column/Cell
– Edit – Delete.
Delete Sheet: To Erase A Sheet.
YÇãÌ[ýç AEõ×»Oô aÝ»OôãEõ å]ç»K÷çÌ[ý
LXî*
Steps: Edit – Delete Sheet.
Move Or Copy Sheets: To Create Another Copy Of The
Sheet Or To Move To Another Workbook.
AEõ+ WýÌ[ýãXÌ[ý %çÌ[ýC AEõ×»Oô aÝ»Oô ^ç
A+ Zõç+ã_ [ýç %Xî åEõçX Zõç+ã_ ×XãÌ^ ^çCÌ^çÌ[ý LXî*
Steps: Edit – Move Or Copy Sheets
– Choose The Work Book – Check The Create Copy – Ok
Find : To Search Some Values.
åEõçX `ãŒåEõ FgÇãL [ýçÌ[ý EõÌ[ýçÌ[ý LXî *
Edit – Find – Write The Word To
Be Found – Find Next.
Replace:
To Change A Value With Another Value.
åEõçX `Œ ×VãÌ^ åEõçX `ŒãEõ Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ý LXî*
Steps: Edit – Replace – In Find
What ( The Word To Be Replaced) – In Replace With ( The Word With Which It Will
Be Replaced) – Replace.
Select All: To Select Whole Worksheet.
a]Ø™ö QöEÇõã]³Oô»OôçãEõ åaã_kô EõÌ[ýçÌ[ý LXî*
Steps: Edit – Select All.
Goto: To Select Some Cells.
×X×VÛrô _ç+X X¶‘öÌ[ý Y^ïÜ™ö ^çCÌ^çÌ[ý LXî*
Steps: Edit - Goto – Give The
Range – Ok.
View
Normal: After Watching Page Break
Preview You An Normalize The View .
åYL æ[ýÐEõ ×YÒ×\ö= åVFçÌ[ý YãÌ[ý
açWýçÌ[ýX\öçã[ý åVFçÌ[ý LXî*
Steps: View – Normal.
Page Break Preview: To Get The Print Area Page wise.
EõTö»Oôç AEõ»Oôç åa»Oô EõÌ[ýç åYãLÌ[ý
]ãWýî %çaä»K÷ åa»Oôç åVFçÌ[ý LXî*
Steps : View – Page Break Preview
– Ok.
Task Pane: To Activate Or Deactivate The
Task Pane Window.
AEõ YÒçãÜ™ö æ»K÷ç»Oô EõãÌ[ý åVFçÌ[ý
]TöX LçÌ^Gç ×XãÌ^ %çaç [ýç aÌ[ýçãXçÌ[ý LXî*
Steps: View – Task Pane.
Toolbars: To Activate Or Deactivate The
Tool Bars.
OÇô_[ýçÌ[ý m×_ãEõ ×XãÌ^ %çaç [ýç
aÌ[ýçãXçÌ[ý LXî *
Step: View – Toolbars.
Formula Bar: To Activate Or Deactivate The
Formula Bar.
ZõÌ[ý]Ç_ç åVFç[ýçÌ[ý LçÌ^Gç»Oôç ×XãÌ^
%çaç C aÌ[ýçãXçÌ[ý LXî*
Step: View – Formula bar.
Status Bar: To Activate Or Deactivate The
Status Bar.
ºOôîç»Oôça [ýçÌ[ý×»OôãEõ ×XãÌ^ %çaç [ýç
aÌ[ýçãXçÌ[ý LXî*
Step: View – Status bar.
Header & Footer:
To Write The Information At The Top Or Bottom Of The Page.
YÊœöçÌ[ý =YãÌ[ý [ýç ×Xä»Jô ]ç×LÛX
A_çEõçÌ^ ×Eõ»KÇ÷ å_FçÌ[ý LXî*
Steps: View – Header & Footer
– Custom Header/Footer – Write The Texts – Ok.
Comment: To Pass/View Some Texts For The Reference.
åEõçX åaã_Ì[ý =YãÌ[ý åEõçX ]Ü™ö[ýî
×VãÌ^ Ì[ýçFçÌ[ý LXî*
Select The Text – View – Comments
– New Comment – Write The Comment.
Custom View: To Name Some Selected Area With
Name.
Eõãaã_kô EõÌ[ýç A_çEõç m×_ãEõ Xç] ×VãÌ^
Ì[ýçFçÌ[ý LXî*
Select The Area – View – Custom
View – Add – Write Any Name - Ok.
Zoom: To Enlarge The View Up to 200%
VÊ`î×»OôãEõ [ýQÍö EõãÌ[ý åVFçÌ[ý LXî*
Steps: View – Zoom – Select The
View = 200% - Ok.
Full Screen: To View The Page With Full
Screen Preview.
YÇãÌ[ýç •˜õÝX LÇäQÍö åVFçÌ[ý LXî*
Steps: View – Full Screen Preview
– Close Full Screen View.
Insert
Cell: To Insert A New Cell On Desired
Position.
ÅAEõ×»Oô åa_ãEõ å_FçÌ[ý ]ãWýî ×XãÌ^
%çaçÌ[ý LXî*
Steps: Select The Cell – Insert –
Cell – Shift Cell Down/Right – Ok
Row: To Insert A New Row On Desired
Position.
AEõ×»Oô åÌ[ýç åEõ YÊœöçÌ[ý =YãÌ[ý ×XãÌ^
%çaçÌ[ý LXî*
Steps: Select The Row – Insert – Row.
Column: To Insert A New Column On
Desired Position.
ÅAEõ×»Oô Eõ_ç]ãEõ YÊœöçÌ[ý =YãÌ[ý ×XãÌ^
%çaçÌ[ý LXî*
Steps: Select The Column – Insert
– Column.
Worksheet: To Insert A New Worksheet On
Desired Position.
XTÇöX AEõ»Oôç CÌ^çEïõaÝ»Oô ×XãÌ^
%çaçÌ[ý LXî*
Steps: Select The Worksheet –
Insert – Worksheet.
Chart: Visual Representation Of The Value / Data.
GÐçZõ [ýç ×»Jôy ¥çÌ[ýç TöUîãEõ TÇöã_
WýÌ[ýç*
Steps: Select The Data – Insert –
Chart – Select The Type – Next – Add The Name
- As A New Sheet – Finish.
Function: To Calculate Easily With The Set
Of Commands
×Eõ»KÇ÷ YÉ[ýï×XãVÛÅ×`Tö %çãV` ¥çÌ[ýç
%eEõ a]çWýçX EõÌ[ýç*
Steps: Select The Cell – Insert –
Function – Select The Category – Select Function - Ok .
Name: To Name The Cells Instead Of
Cell Addresses.
åEõçX åa_åEõ Xç] EõÌ[ýãXÌ[ý ]ãWýî
×»Jô×X[ýçÌ[ý [ýî[ýØšöç EõÌ[ýçÌ[ý LXî*
Steps: Select The Area – Name –
Create – Ok – Insert – Name – Apply – Ok.
Steps: Select The Area – Name –
Define – Any Name – Add – Sheet 2 – Insert – Name- Paste – Ok.
Comment: To Pass A Comment On Any Cell.
åEõçX AEõ×»Oô åaã_Ì[ý ]ãWýî ]Ü™ö[ýî
åVCÌ^çÌ[ý LXî*
Steps: Select The Cell – Insert –
Comment – Write Some Text.
Picture: To Insert Any Picture From Any
Drive.
]ç+ãyÔçaZõ»Oô %×Zõãa YîçãEõãL UçEõç
»K÷×[ý ×XãÌ^ EõçL EõÌ[ýçÌ[ý LXî*
Steps: Insert – Picture – Select
The Drive – Select The Folder – Select The File – Insert.
Diagram: To Insert Any Diagram As Chart
To Represent The Data Visually.
×Eõ»KÇ÷ »K÷×[ý [ýç %çEÊõ×Tö ¥çÌ[ýç
TöUîm×_ãEõ =YØšöçYX EõÌ[ýç*
Steps: Insert – Diagram – Select
Any One - Ok
Objects: To Insert Any Object From
Any Other Application .
%Xî %îçY×_ãEõaçXåEõ CÌ^çãQïö ×XãÌ^ Aãa
åEõçX EõçL EõÌ[ýçÌ[ý LXî*
Steps: Insert – Objects – Select
The Application E.G Bitmap Image – Ok.
Hyperlink: To Create A Link Between Two The Files.
VÇ×»Oô Zõç+ã_Ì[ý ]ãWýî å^çGçã^çG
[ýî[ýØšöç GäQÍö åTöç_çÌ[ý LXî*
Steps: Select The Cell – Insert –
Hyperlink – Select The File – Ok.
Format
Cell: To Change The Color, Direction,
Currency Symbol, Pattern Etc.
åEõçX AEõ×»Oô åaã_Ì[ý ]ãWýî Ì[ýIø,
×VEõ, C å_FçÌ[ý é`_Ý Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ý LXî*
Select The Cells – Format – Cells
– Select The Options – Ok.
Row: To Modify The With Its Height,
Hide Or Unhide.
åEõçX åÌ[ýç AÌ[ý %çEõçÌ[ý Y×Ì[ý[ýTöÛX
[ýç _ÇEõçãXçÌ[ý LXî*
Steps: Select The Cell – Format –
Row – Height ( Increase The Height) / Auto fit (Automatically Adjustment) / Hide ( Concealing Row) / Unhide (Unveil).
Column: To Modify The With Its Height,
Hide Or Unhide.
åEõçX Eõ_çã]Ì[ý %çEõçÌ[ý Y×Ì[ý[ýTöÛX
EõÌ[ýçÌ[ [ýç _ÇEõçãXçÌ[ý LXî*
Steps: Select The Cell – Format –
Column– Height ( Increase The Height) / Auto fit (Automatically
Adjustment) / Hide ( Concealing Row) /
Unhide (Unveil).
Sheet: To Modify/Rename The Worksheet
Background / Hide / Unhide.
åEõçX aÝä»OôÌ[ý Xç] Y×Ì[ý[ýTöÛX [ýç
Ì[ýIø Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ [ýç _ÇEõçãXçÌ[ýý LXî*
Steps: Format – Worksheet –
Background – Choose The Picture File - Ok
Auto format: To Apply Selected Predefine
Style.
%çãG åUãEõ åa»Oô EõãÌ[ý Ì[ýçFç é`_Ý
Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ý LXî*
Steps: Select The Cells – Format
– Auto format – Select The Style – Ok.
Conditional Formatting: To Make Modification According
To The Maximum 3 Conditions.
`TöÛçXÇaçãÌ[ý åaã_Ì[ý é`_Ý Y×Ì[ý[ýTöÛX
EõÌ[ýçÌ[ý LXî*
Steps: Select The Cell –
Conditional Formatting – Select The Conditions Add – Next Condition – Add –
Next Condition –Ok.
Tools
Spelling : To Check The Spelling Of The Corresponding
Cell.
ã_FçÌ[ý
YãÌ[ý [ýîçEõçÌ[ýX C [ýçXçX åVãF åXCÌ^çÌ[ý LXî*õ
Steps: Select The Cell – Tools –
Spelling – Change – Ok.
Track Change: To Protect Your Sheet Without
Having Any Data Lose.
åEõçX
å_FçåTö åEõçX Y×Ì[ý[ýTöÛX c÷ã_ FÇ[ý ac÷ãL åVFãTö YçCÌ^çÌ[ý LXî *
Steps: Tools – Track Change –
Highlight The Changes - Select The Range – Ok.
Protection: You Van Protect Your Sheet With
Password.
åEõçX
QöEÇõã]ä³Oô YçaCÌ^çQïö ×VãÌ^ aÇÌ[ý×lùTö EõÌ[ýçÌ[ý LXî*
Steps: Tools – Protect Sheet –
Enter The Password – Reenter The Password – Ok.
Goal Seek: To make Any Adjustment Entry in
the Current Sheet.
åEõçX \öîç_ÇãEõ aç]³Laî EõãÌ[ý %Xî
åa_ãEõ Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ý LXî*
Steps: Select The Contains A
Formula – Input The To Value – Select A Cell Which Doesn’t Contain Any Formula
– Ok.
Scenarios: To Make Multiple Sheet Within
One Sheet.
AEõ×»Oô Eõ_çã]Ì[ý ]ãWýî %ãXEõm×_
åQö»Oôç Ì[ýçFçÌ[ý EõçL EõÌ[ýçÌ[ý LXî*
Steps: Select Less Than 32 Cells
– Tools – Scenario – Add – Change The Cell Values – Ok.
Formula Auditing: To View The Dependency Of Cell
On Each Other.
åEõçX åa_ EõçÌ[ý =YãÌ[ý ×X\öÛÌ[ý EõãÌ[ý
%çä»K÷ Töç ×XXïÌ^ EõÌ[ýçÌ[ý LXî*
Steps : Select The Cell – Tools –
Formula Auditing – Trace President / Trace Dependence .
Macro: To Record Some Steps.
Steps: Tools – Macro – Record New
Macro – Ok – Do Some Steps More – Stop Recording.
Now You Can Run It From : Tools –
Macro – Run Macro – Select The Macro No. –Run
Customize: To Add Or Remove Excel Features
Options.
Steps: Tools - Customize – Toolbars – Select The Tool Bar –
Reset – Ok.
Option : To Set The Excel Option According
To Your Need.
Data
Sort: To Arrange The Data In Ascending
Or Descending Order.
×Eõ»KÇ÷ åa_åEõ %lùÌ[ý [ýç [ýQÍö åUãEõ æ»K÷ç»Oô
%U[ýç æ»K÷ç»Oô åUãEõ [ýQÍö EõÌ[ýçÌ[ý LXî*
Steps: Select The Data – Sort –
Select The Column – Ok
Filter: To Filter The Value According To
Your Need.
TöUî m×_ãEõ å[ýä»K÷ å[ýä»K÷ åVFçÌ[ý
LXî*
Steps: Select The Data – Data –
Filter –Auto filter - Select The Column – Custom – Set The Condition – Ok.
Form: To Make Automatic Entry To The Corresponding
Cells.
aÌ^e×yÔÌ^ \öçã[ý ×XãL ×XãL
Eõîç_EÇõã_açX EõÌ[ýçÌ[ý LXî*
Steps: Select The Data – Tools –
Form – New – Enter The Data – Ok.
Subtotal: To Add And Arrange The Data Within
Groups.
GÐÓY \öçã[ý aç×LãÌ^ å^çG EõÌ[ýçÌ[ý LXî*
Steps: Select The Data – Tools –
Sort On A Field – Tools – Subtotal – Select The Same Field – Select The Field
To Be Added – Ok.
Validation: To Set The Acceptance Criteria
For The Cells.
Y»K÷³V ]TöX åQö»OôçÌ[ý [ýç+ãÌ[ý åEõçX
åQö»OôçãEõ +XYÇ»Oô åUãEõ ×[ýÌ[ýTö LXî*
Select The Cells – Data –
Validation – Select Whole Number – Set The Maximum And Minimum Number – Input
Message – Title – Write The Massage – Error Alert – Write The Title – Write
Error Alert – Ok.
Table: To Make A Table For Any Number.
åEõçX Xç]Töç éTöÌ[ýÝ EõÌ[ýçÌ[ý LXî*
Steps: Make A Series – Data - Table – Set Row Input Cell – Set Column
Input Cell – Ok.
Text To Column: To Arrange Or Shift The Criteria
To The Corresponding Column
åEõçX Eõ_çã] AEõaçãU a[ý ×_ãF %ç_çVç
%ç_çVç åaã_ ×XãÌ^ ^çCÌ^çÌ[ý LXî*
Steps: Write Some Values With
Using Comma – Data – Text To Column- Now Select Comma – Next – Finish.
Group And Out Line: To Create The Group Of Rows Or
Column
×Eõ»KÇ÷ Eõ_ç] [ýç åÌ[ýç åEõ GÐÓY
%çEõçãÌ[ý açLçãXçÌ[ý LXî*
Steps: Select The Column – Data –
Group – Select The Row Or Column –Ok.
Window
Arrange : To Arrange The Files In Any
Order .
=+ã³Qöçm×_ãEõ aç×LãÌ^ EõçL EõÌ[ýçÌ[ý
LXî*
Steps: Window – Arrange – Tiled –
Ok.
Hide: To Hide Or Unhide The Window.
åEõçX =+ã³Qöç åEõ _Ç×EõãÌ^ Ì[ýçFçÌ[ýý
LXî*
Steps: Window – Hide/Unhide – Ok.
Split: To Divide The Window.
åEõçX =+ã³QöçãEõ VÇ\öçãG \öçG EõÌ[ýçÌ[ý
LXî*
Steps: Window – Split .
Freeze Pane: To Make A Fixed Column Or Row.
åEõçX +=ã³Qöç AÌ[ý ]ãWýî åÌ[ýç [ýç
Eõ_ç] m×_åEõ ×ZõjQö EõãÌ[ý Ì[ýçFçÌ[ý LXî*
Steps: Select The Row/Column –
Window – Freeze Pane.
Microsoft Excel Practical 2007, 2010, 2013
File:
New: To Create A New Workbook/ File In
Excel.
XTÇöX Zõç+_ éTöÌ[ýÝ EõÌ[ýçÌ[ý LXî*
Steps: Office Button / File→ New
- Create.
Open: To Open An Existing Excel File
%çãG åUãEõ åa\ö EõãÌ[ý Ì[ýçFç åEõçX Zõç+_ åFç_çÌ[ý LXî *
Steps: Office Button / File –
Open – Select The File – Open.
Close: To Close The Current File (With
Shift Key You Can Have ‘Close All’.
Zõç+_×»OôãEõ [ýµù EõÌ[ýçÌ[ý LXî*
Steps: Office Button / File –
Close.
Save: To Save Or Modify A File.
åEõçX Zõç+_åEõ Eõ׶Y=»OôçãÌ[ý aeÌ[ý×lùTö EõÌ[ýçÌ[ý LXî *
Steps: Office Button / File –
Save – File Name – Save.
Save As:
To Save Another Copy Of The File.
åEõçX Zõç+_ãEõ %ç_çVç Xçã] [ýç %ç_çVç LçÌ^GçÌ^ åa\ö
EõÌ[ýçÌ[ý LXî *
Steps: Office Button / File –
Save As – New File Name – Save.
Save As Webpage: To Save The File As Html Page
For Publishing Into The Internet
åEõçX Zõç+_ãEõ +³OôçÌ[ýãXä»OôÌ[ý =Y^ÇNþ
åYL ×c÷açã[ý åa\ö EõÌ[ýçÌ[ý LXî*
Steps: Office Button / File –
Save As Webpage – Add Inter Activity – Any File Name – Save.
Save Workspace: To Save Multiple Files Within
One File.
%ãXEõm×_ Zõç+_ãEõ AEõ×»Oô =+ã³QöçÌ[ý
]ãWýî ×XãÌ^ Aãa EõçL EõÌ[ýçÌ[ý LXî*
Steps: Office Button / File –
Open – Select Some Excel Files – Open – View – Save Workspace – Any Name –
Save. File – Close All . Office Button / File – Open - Select The Workspace File – Open. Window –
Arrange – Tiled – Ok.
Page Setup: To Set The Page To Make Some
Print Out.
EõçL EõÌ[ýçÌ[ý %çãG %U[ýç ×YÒ³Oô EõÌ[ýçÌ[ý %çãG
åYL×»OôãEõ aç×LãÌ^ åXCÌ^çÌ[ý LXî *
Steps: Page Layout – Page Setup –
Page – Portrait/Landscape – Margin – Top = Bottom = Left = Right = 1” – Ok.
Print Area: To Set / Discard The
Selected Printing Area.
ãaã_kô EõÌ[ýç %e`ãEõ ×YÒ³Oô EõÌ[ýçÌ[ý
[ýî[ýØšöç EõÌ[ýç*
Steps : Select The Cells – Page
Layout – Print Area – Set Print Area. Office
Button / File – Print - Print Preview – Close.
To Clear The Print Area : Page
Layout – Print Area – Clear Print Area.
Print Preview: To View The Page Before The
Print Out
EõçGãL »K÷çYçÌ[ý %çãG åVãF åXCÌ^ç å^
×YÒ³Oô×»Oô åEõ]X c÷ã[ý*
Steps: Office Button / File –
Print - Print Preview.
Send : To Send The Data To Another
Microsoft/Internet Application.
%Xî åEõçX %îç×YÀãEõ`ãX
QöEÇõã]³Oô×»OôãEõ YçPöçãXçÌ[ý LXî *
Steps: Office Button / File –
Send – Email.
Properties: To Get The General Information
About The Files.
åEõçX Zõç+_ AÌ[ý açWýçÌ[ýX TöUî
YçCÌ^çÌ[ý LXî*
Steps: Office Button / File –
Prepare - Properties –
General/Summery/Statistics/Content – Ok.
Print : To Make Some Printouts On The
Page.
EõçGãLÌ[ý =YÌ[ý ×YÒ³Oô%çC»Oô EõÌ[ýçÌ[ý LXî *
Steps: Office Button / File -
Print - Number Of Copies = 1 – Ok.
Exit: To Close The Microsoft Excel.
]ç+ãyÔçaZõ»Oô Aãj_ [ýµù EõÌ[ýçÌ[ý LXî*
Steps: Office Button / File –
Exit.
Undo: One Step Backward.
AEõYV ×Y»K÷ãX ^çCÌ^çÌ[ý LXî*
Steps: Quick Tool Bar – Undo.
Repeat/ Redo : One Step Forward.
AEõYV aç]ãX ^çCÌ^çÌ[ý LXî*
Steps: Quick Tool Bar – Repeat/
Redo.
Cut: To Cut And Paste The Text / Object To The Desired Position. Once
You Cut An Object You Can Paste It Many Times If It Is Available On Clipboard.
åEõä»Oô ×XãÌ^ Y×Ì[ý[ý×TöÛTö LçÌ^GçÌ^ Ì[ýçFçÌ[ý LXî*
Steps: Select The Cells – Home –
Cut – Select The Position – Edit – Paste.
Copy: To Create Another Copy Of The
Same Text. Once You Cut An Object You Can Paste It Many Times If It Is
Available On Clipboard.
YÒçÌ^ AEõ+ Ì[ýEõ] åVFãTö %çãÌ[ýç AEõ×»Oô æ»OôEËõºOô
éTöÌ[ýÝ EõÌ[ýçÌ[ý LXî*
Steps: Select The Cells – Home –
Copy – Select The Position – Edit – Paste.
Paste: After Cut Or Copy You Can Get
The Result With The Paste.
Eõç»Oô %U[ýç Eõ×Y EõÌ[ýçÌ[ý YãÌ[ý ^UçØšöçãX Ì[ýçFçÌ[ý LXî*
Steps: Home – Paste
Office Clipboard: To Copy Multiple Objects Within
A Clip Board.
AEõç×VEõ ×[ýbÌ^ C æ»Oôj»Oô åEõ
×zõYã[ýçãQïö TÇöã_ Ì[ýçFçÌ[ý LXî*
Steps: Home – Office Clipboard –
Edit – Copy.
Paste Special: To Create A Link Between To Copy
& Pasted Area. If Any Chages Occurred In Mother Sheet (Copied) Then All
Changes Are Available In Child Sheet (Pasted) Also.
VÇ×»Oô Eõ×Y C åYºOô EõÌ[ýç aÝä»OôÌ[ý
]ãWýî å^çGçã^çG éTöÌ[ýÝ EõÌ[ýçÌ[ý LXî ^çãTö AEõ×»Oô Yç·Oôçã_ %çÌ[ýC AEõ×»Oô
aÌ^e×yÔÌ^\öçã[ý Yçä·Oô ^çã[ý Töã[ý Eõ×Y åUãEõ åYºOô å&`ç_ EõÌ[ýç aÝä»OôåTö
A»Oôç c÷Ì^* åYºOô å&`ç_ EõÌ[ýç aÝä»OôåTö åEõçX Y×Ì[ý[ýTöÛX c÷ã_ %ça_ aÝä»Oô
åEõçX Y×Ì[ý[ýTöÛX c÷ã[ý Xç*
Steps: Select The Cells – Home –
Copy – Sheet 2 – Home – Paste Special – Paste Link.
Fill: To Fill Some Cells With Same
Number (1,1,1,1) Or Value Or Series As
(1,2,3….)
AEõ+ X¶‘öÌ[ý [ýç yÔ] aeFîç ¥çÌ[ýç
åa_m×_ãEõ \öÌ[ýçÌ[ý LXî*
Steps: Write Any Number In Any
Cell – Select Some More Cell Downwards – Home – Fill – Down.
Steps: Write Any Number In Any
Cell – Select Some More Cell Downwards – Home – Fill – Series – Step Value =1 –
Ok.
Clear: To Clear Out The Colors, Values
Or Any Modification.
Eõãaã_Ì[ý TöUî m×_ãEõ XçXX \öçã[ý
å]ç»K÷çÌ[ý LXî*
Steps: Select The Area - Home–
Clear – All. (Everything Will Be Wiped Out)
Select The Area - Home – Clear –
Formats. (Formatting Will Be Wiped Out)
Select The Area - Home – Clear –
Contents. (Values Will Be Wiped Out)
Select The Area - Home– Clear –
Comments. (Comments Will Be Wiped Out)
Delete: To Erase A Selected Row Or Column
Or Cell.
AEõ×»Oô åÌ[ýç [ýç Eõ_ç] åEõ å]ç»K÷çÌ[ý
LXî*
Steps: Select The Row/Column/Cell
– Home – Delete.
Delete Sheet: To Erase A Sheet.
YÇãÌ[ýç AEõ×»Oô aÝ»OôãEõ å]ç»K÷çÌ[ý
LXî*
Steps: Home – Delete Sheet.
Move Or Copy Sheets: To Create Another Copy Of The
Sheet Or To Move To Another Workbook.
AEõ+ WýÌ[ýãXÌ[ý %çÌ[ýC AEõ×»Oô aÝ»Oô ^ç
A+ Zõç+ã_ [ýç %Xî åEõçX Zõç+ã_ ×XãÌ^ ^çCÌ^çÌ[ý LXî*
Steps: Home – Format – Move Or
Copy Sheets – Choose The Work Book – Check The Create Copy – Ok
Find : To Search Some Values.
åEõçX `ãŒåEõ FgÇãL [ýçÌ[ý EõÌ[ýçÌ[ý LXî *
Steps: Home – Find – Write The
Word To Be Found – Find Next.
Replace:
To Change A Value With Another Value.
åEõçX `Œ ×VãÌ^ åEõçX `ŒãEõ Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ý LXî*
Steps: Home – Replace – In Find
What ( The Word To Be Replaced) – In Replace With ( The Word With Which It Will
Be Replaced) – Replace.
Select All: To Select Whole Worksheet.
a]Ø™ö QöEÇõã]³Oô»OôçãEõ åaã_kô EõÌ[ýçÌ[ý LXî*
Steps: Ctrl + A
Goto: To Select Some Cells.
×X×VÛrô _ç+X X¶‘öÌ[ý Y^ïÜ™ö ^çCÌ^çÌ[ý LXî*
Steps: Ctrl + G – Give The Range
– Ok.
Normal: After Watching Page Break
Preview You An Normalize The View .
åYL æ[ýÐEõ ×YÒ×\ö= åVFçÌ[ý YãÌ[ý
açWýçÌ[ýX\öçã[ý åVFçÌ[ý LXî*
Steps: View – Normal.
Page Break Preview: To Get The Print Area Page wise.
EõTö»Oôç AEõ»Oôç åa»Oô EõÌ[ýç åYãLÌ[ý
]ãWýî %çaä»K÷ åa»Oôç åVFçÌ[ý LXî*
Steps : View – Page Break Preview
– Ok.
Formula Bar: To Activate Or Deactivate The
Formula Bar.
ZõÌ[ý]Ç_ç åVFç[ýçÌ[ý LçÌ^Gç»Oôç ×XãÌ^
%çaç C aÌ[ýçãXçÌ[ý LXî*
Step: View – Formula bar.
Header & Footer:
To Write The Information At The Top Or Bottom Of The Page.
YÊœöçÌ[ý =YãÌ[ý [ýç ×Xä»Jô ]ç×LÛX
A_çEõçÌ^ ×Eõ»KÇ÷ å_FçÌ[ý LXî*
Steps: Insert – Header &
Footer – Custom Header/Footer – Write The Texts – Ok.
Comment: To Pass/View Some Texts For The Reference.
åEõçX åaã_Ì[ý =YãÌ[ý åEõçX ]Ü™ö[ýî
×VãÌ^ Ì[ýçFçÌ[ý LXî*
Steps: Select The Cell – Review –
Comments – New Comment – Write The Comment.
Custom View: To Name Some Selected Area With
Name.
Eõãaã_kô EõÌ[ýç A_çEõç m×_ãEõ Xç] ×VãÌ^
Ì[ýçFçÌ[ý LXî*
Steps: Select The Area – View –
Custom View – Add – Write Any Name -
Ok.
Zoom: To Enlarge The View Up to 200%
VÊ`î×»OôãEõ [ýQÍö EõãÌ[ý åVFçÌ[ý LXî*
Steps: View – Zoom – Select The
View = 200% - Ok.
Cell: To Insert A New Cell On Desired
Position.
ÅAEõ×»Oô åa_ãEõ å_FçÌ[ý ]ãWýî ×XãÌ^
%çaçÌ[ý LXî*
Steps: Select The Cell - Home–
Insert – Cell – Shift Cell Down/Right – Ok
Row: To Insert A New Row On Desired
Position.
AEõ×»Oô åÌ[ýç åEõ YÊœöçÌ[ý =YãÌ[ý ×XãÌ^
%çaçÌ[ý LXî*
Steps: Select The Row – Home -
Insert – Row.
Column: To Insert A New Column On
Desired Position.
ÅAEõ×»Oô Eõ_ç]ãEõ YÊœöçÌ[ý =YãÌ[ý ×XãÌ^
%çaçÌ[ý LXî*
Steps: Select The Column - Home –
Insert – Column.
Worksheet: To Insert A New Worksheet On
Desired Position.
XTÇöX AEõ»Oôç CÌ^çEïõaÝ»Oô ×XãÌ^
%çaçÌ[ý LXî*
Steps: Right Click on The Worksheet Tab – Insert – Worksheet - OK.
Chart: Visual Representation Of The Value / Data.
GÐçZõ [ýç ×»Jôy ¥çÌ[ýç TöUîãEõ TÇöã_ WýÌ[ýç*
Steps: Select The Data – Insert –
Chart – Select The Type – Next – Add The Name
- As A New Sheet – Finish.
Function: To Calculate Easily With The Set
Of Commands
×Eõ»KÇ÷ YÉ[ýï×XãVÛÅ×`Tö %çãV` ¥çÌ[ýç
%eEõ a]çWýçX EõÌ[ýç*
Steps: Select The Cell – Formula
– Function – Select The Category – Select Function - Ok .
Name: To Name The Cells Instead Of
Cell Addresses.
åEõçX åa_åEõ Xç] EõÌ[ýãXÌ[ý ]ãWýî
×»Jô×X[ýçÌ[ý [ýî[ýØšöç EõÌ[ýçÌ[ý LXî*
Steps: Select The Area – Formula –
Create – Ok – Insert – Name – Apply – Ok.
Steps: Select The Area – Formula
- Name – Define – Any Name – Add – Sheet 2 – Insert – Name- Paste – Ok.
Comment: To Pass A Comment On Any Cell.
åEõçX AEõ×»Oô åaã_Ì[ý ]ãWýî ]Ü™ö[ýî
åVCÌ^çÌ[ý LXî*
Steps: Select The Cell – Review–
Comment – Write Some Text.
Picture: To Insert Any Picture From Any
Drive.
]ç+ãyÔçaZõ»Oô %×Zõãa YîçãEõãL UçEõç
»K÷×[ý ×XãÌ^ EõçL EõÌ[ýçÌ[ý LXî*
Steps: Insert – Picture – Select
The Drive – Select The Folder – Select The File – Insert.
Diagram: To Insert Any Diagram As Chart
To Represent The Data Visually.
×Eõ»KÇ÷ »K÷×[ý [ýç %çEÊõ×Tö ¥çÌ[ýç
TöUîm×_ãEõ =YØšöçYX EõÌ[ýç*
Steps: Insert – Diagram – Select
Any One - Ok
Objects: To Insert Any Object From
Any Other Application .
%Xî %îçY×_ãEõaçXåEõ CÌ^çãQïö ×XãÌ^ Aãa
åEõçX EõçL EõÌ[ýçÌ[ý LXî*
Steps: Insert – Objects – Select
The Application E.G Bitmap Image – Ok.
Hyperlink: To Create A Link Between Two The Files.
VÇ×»Oô Zõç+ã_Ì[ý ]ãWýî å^çGçã^çG
[ýî[ýØšöç GäQÍö åTöç_çÌ[ý LXî*
Steps: Select The Cell – Insert –
Hyperlink – Select The File – Ok.
Cell: To Change The Color, Direction,
Currency Symbol, Pattern Etc.
åEõçX AEõ×»Oô åaã_Ì[ý ]ãWýî Ì[ýIø,
×VEõ, C å_FçÌ[ý é`_Ý Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ý LXî*
Steps: Select The Cells – Insert
- Format – Cells – Select The Options – Ok.
Row: To Modify The With Its Height,
Hide Or Unhide.
åEõçX åÌ[ýç AÌ[ý %çEõçÌ[ý Y×Ì[ý[ýTöÛX
[ýç _ÇEõçãXçÌ[ý LXî*
Steps: Select The Cell – Insert -
Format – Row – Height ( Increase The
Height) / Auto fit (Automatically Adjustment)
/ Hide ( Concealing Row) / Unhide (Unveil).
Column: To Modify The With Its Height,
Hide Or Unhide.
åEõçX Eõ_çã]Ì[ý %çEõçÌ[ý Y×Ì[ý[ýTöÛX
EõÌ[ýçÌ[ [ýç _ÇEõçãXçÌ[ý LXî*
Steps: Select The Cell – Insert -
Format – Column– Height ( Increase The
Height) / Auto fit (Automatically Adjustment)
/ Hide ( Concealing Row) / Unhide (Unveil).
Sheet: To Modify/Rename The Worksheet
Background / Hide / Unhide.
åEõçX aÝä»OôÌ[ý Xç] Y×Ì[ý[ýTöÛX [ýç
Ì[ýIø Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ [ýç _ÇEõçãXçÌ[ýý LXî*
Steps: Insert - Format –
Worksheet – Background – Choose The Picture File - Ok
Table format as: To Apply Selected Predefine
Style.
%çãG åUãEõ åa»Oô EõãÌ[ý Ì[ýçFç é`_Ý
Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ý LXî*
Steps: Select The Cells – Insert
– Table Format As – Select The Style – Ok.
Conditional Formatting: To Make Modification According
To The Conditions.
`TöÛçXÇaçãÌ[ý åaã_Ì[ý é`_Ý Y×Ì[ý[ýTöÛX
EõÌ[ýçÌ[ý LXî*
Steps: Select The Cell – Insert -
Conditional Formatting – Select The style –
Spelling : To Check The Spelling Of The
Corresponding Cell.
ã_FçÌ[ý
YãÌ[ý [ýîçEõçÌ[ýX C [ýçXçX åVãF åXCÌ^çÌ[ý LXî*õ
Steps: Select The Cell – Review –
Spelling and Grammar – Change – Ok.
Track Change: To Protect Your Sheet Without
Having Any Data Lose.
åEõçX
å_FçåTö åEõçX Y×Ì[ý[ýTöÛX c÷ã_ FÇ[ý ac÷ãL åVFãTö YçCÌ^çÌ[ý LXî *
Steps: Review – Track Change –
Highlight The Changes - Select The Range – Ok.
Protection: You Van Protect Your Sheet With
Password.
åEõçX
QöEÇõã]ä³Oô YçaCÌ^çQïö ×VãÌ^ aÇÌ[ý×lùTö EõÌ[ýçÌ[ý LXî*
Steps: Review – Protect Sheet –
Enter The Password – Reenter The Password – Ok.
Goal Seek: To make Any Adjustment Entry in
the Current Sheet.
åEõçX \öîç_ÇãEõ aç]³Laî EõãÌ[ý %Xî
åa_ãEõ Y×Ì[ý[ýTöÛX EõÌ[ýçÌ[ý LXî*
Steps: Select The Contains A
Formula – Data – What if analysis – Goal Seek -Input The To Value – Select A
Cell Which Doesn’t Contain Any Formula – Ok.
Scenarios: To Make Multiple Sheet Within
One Sheet.
AEõ×»Oô Eõ_çã]Ì[ý ]ãWýî %ãXEõm×_
åQö»Oôç Ì[ýçFçÌ[ý EõçL EõÌ[ýçÌ[ý LXî*
Steps: Select Less Than 32 Cells
– Data – What if analysis - Scenario – Add – Change The Cell Values – Ok.
Formula Auditing: To View The Dependency Of Cell
On Each Other.
åEõçX åa_ EõçÌ[ý =YãÌ[ý ×X\öÛÌ[ý EõãÌ[ý
%çä»K÷ Töç ×XXïÌ^ EõÌ[ýçÌ[ý LXî*
Steps : Select The Cell – Formulas
– Formula Auditing – Trace President / Trace Dependence .
Macro: To Record Some Steps.
Steps: View – Macro – Record New
Macro – Ok – Do Some Steps More – Stop Recording.
Now You Can Run It From : View –
Macro – Run Macro – Select The Macro No. –Run
Sort: To Arrange The Data In Ascending
Or Descending Order.
×Eõ»KÇ÷ åa_åEõ %lùÌ[ý [ýç [ýQÍö åUãEõ
æ»K÷ç»Oô %U[ýç æ»K÷ç»Oô åUãEõ [ýQÍö EõÌ[ýçÌ[ý LXî*
Steps: Select The Data – Data - Sort – Select The Column – Ok
Filter: To Filter The Value According To
Your Need.
TöUî m×_ãEõ å[ýä»K÷ å[ýä»K÷ åVFçÌ[ý
LXî*
Steps: Select The Data – Data –
Filter –Auto filter - Select The Column – Custom – Set The Condition – Ok.
Form: To Make Automatic Entry To The
Corresponding Cells.
aÌ^e×yÔÌ^ \öçã[ý ×XãL ×XãL
Eõîç_EÇõã_açX EõÌ[ýçÌ[ý LXî*
At first you need to add this
from excel option as : Office button – excel option – customize – All commands
– form – add – ok.
Steps: Select The Data – Quick
Launch Toolbar – Form – New – Enter The Data – Ok.
Subtotal: To Add And Arrange The Data
Within Groups.
GÐÓY \öçã[ý aç×LãÌ^ å^çG EõÌ[ýçÌ[ý LXî*
Steps: Select The Data – Data –
Sort On A Field – Data – Subtotal – Select The Same Field – Select The Field To
Be Added – Ok.
Validation: To Set The Acceptance Criteria
For The Cells.
Y»K÷³V ]TöX åQö»OôçÌ[ý [ýç+ãÌ[ý åEõçX
åQö»OôçãEõ +XYÇ»Oô åUãEõ ×[ýÌ[ýTö LXî*
Select The Cells – Data –
Validation – Select Whole Number – Set The Maximum And Minimum Number – Input
Message – Title – Write The Massage – Error Alert – Write The Title – Write
Error Alert – Ok.
Table: To Make A Table For Any Number.
åEõçX Xç]Töç éTöÌ[ýÝ EõÌ[ýçÌ[ý LXî*
Steps: Make A Series – Data - What if analysis - Table – Set Row Input Cell – Set Column Input
Cell – Ok.
Text To Column: To Arrange Or Shift The Criteria
To The Corresponding Column
åEõçX Eõ_çã] AEõaçãU a[ý ×_ãF %ç_çVç
%ç_çVç åaã_ ×XãÌ^ ^çCÌ^çÌ[ý LXî*
Steps: Write Some Values With
Using Comma – Data – Text To Column- Now Select Comma – Next – Finish.
Group And Out Line: To Create The Group Of Rows Or
Column
×Eõ»KÇ÷ Eõ_ç] [ýç åÌ[ýç åEõ GÐÓY
%çEõçãÌ[ý açLçãXçÌ[ý LXî*
Steps: Select The Column – Data –
Group – Select The Row Or Column –Ok.
Arrange : To Arrange The Files In Any
Order .
=+ã³Qöçm×_ãEõ aç×LãÌ^ EõçL EõÌ[ýçÌ[ý
LXî*
Steps: View – Arrange – Tiled –
Ok.
Hide: To Hide Or Unhide The Window.
åEõçX =+ã³Qöç åEõ _Ç×EõãÌ^ Ì[ýçFçÌ[ýý
LXî*
Steps: View – Hide/Unhide – Ok.
Split: To Divide The Window.
åEõçX =+ã³QöçãEõ VÇ\öçãG \öçG EõÌ[ýçÌ[ý
LXî*
Steps: View– Split .
Freeze Pane: To Make A Fixed Column Or Row.
åEõçX +=ã³Qöç AÌ[ý ]ãWýî åÌ[ýç [ýç
Eõ_ç] m×_åEõ ×ZõjQö EõãÌ[ý Ì[ýçFçÌ[ý LXî*
Steps: Select The Row/Column – View
– Freeze Pane.
No comments:
Post a Comment