Excel is used because it is one of the most powerful and easy-to-use spreadsheet software for working with data. People use Excel in almost every field—business, education, research, and personal finance.
Data Organization
Calculations & Formulas
Data Analysis
Visualization
Decision Making
Automation
Universally Accepted
Basic Information of Excel
Microsoft Excel is a spreadsheet software developed by Microsoft.
It is mainly used to store, organize, calculate, analyze, and visualize data in rows and columns.
Max Row : - 1048576
Max Column : - 16384
Last Column name : - XFD
Max Sheet : - The limit is determined by your computer's available memory and system resources
Key
Use Of Key
Key
Use Of Key
Cirl + A
Cirl + B
Cirl + C
Cirl + D
Cirl + E
Cirl + F
Cirl + G
Cirl + H
Cirl + I
Cirl + J
Cirl + K
Cirl + L
Cirl + M
Select all text
Bold the selected text.
Copy selected text
Fill Down
Flash Fill
Open Find dialog box
Go to a page, line, or section
Replace Text
Italicize the selected text
- -
Insert hyperlink
Create Table
- -
Cirl + N
Cirl + O
Cirl + P
Cirl + Q
Cirl + R
Cirl + S
Cirl + T
Cirl + U
Cirl + V
Cirl + W
Cirl + X
Cirl + Y
Cirl + Z
New Workbook
Open Workbook
Open Print dialog
Quick Analysis Tool open kare
Fill Right
Save the current document.
Create Table
Underline the selected text.
Paste copied content
Close Workbook
Cut the selected content.
Redo last action
Undo last action
Salary Sheet
D.A = Dearness Allowance
HRA = House Rent Allowance