excel

 Ms Excel

Ribbon

Home Ribbon

Groups :- 

1. Clipboard ( cut , copy, format painter, paste)
2. Font (font, size, highlighter, border, .)
3. Alignment
1. alignment
2. Wrap text
3. Merge & Center
4. Number ( format)
5. Styles 
1. Conditional formatting
2. format as table
3. cell styles
6. Cell
1. Insert 
2. Delete
3. format
7. Editing
1. Auto sum
2. Fill
3. Clear
4. sort & Filter
5. Find & Select

Insert Ribbon

Group 

1. Table
1. Pivot table
2. table   
2. Illustrations
1. picture
2. Clip Art
3. Shape
4. Smart art
3. Chart
1. Column
2. Line
3. Pie
4. bar
5. Area
6. Scatter  
4. Links
1. Hyperlink
5. Text
1. Text Box
2. Header and Footer
3. Word Art
4. Signature
5. Object
6. Symbol 

Page Layout

1. Themes
2. Page Setup
3. Page Setup
1. Margin
2. orientation
3. Size
4. Area Print
5. Break
6. Background
7. Print Titles
4. Scale to Fit
1. Width
2. Height
3. Scale
5. Sheet Option
1. gridlines
2. Headings
6. Arrange
1. bring front , send back
2. Group, Rotate

formula

1. Formula Library
1. Text
2. Logical
3. Data & Time
4. Financial
5. Look Up 
6. math
2. Define Names
1. Name Manager
3. formula Auditing
1. error Checking 
2. trace Precedents
3. Watch Window
4. calculation
1. Calculate 
2. Calculate Sheet
5.     

data

Data gropu

1. Get External Data
1. From Access
2. From Web
3. From Text
4. From other source
5. Existing Connection
2. Connection
1. Connection
3. Sort & Filter
4. Data tools
1. Text to column
2. Remove Duplicate
3. data validation
4. Consolidate
5. What if analysis
5. Outline
1. Group 
2. ungroup
3. Subtotal

review

Group

1. Proofing
1. Spelling
2. Research
3. Thesaurus
4. Translate
2. Comment
3. Changes
1. Protect Sheet/Workbook
2. Track changes

view

1. Work Book View
1. normal
2. page layout
3. Page Break
4. Custom view
5. Full Screen
2. Show/Hide
1. Ruler
2. Formula
3. Heading
4. gridlines
5. message bar
3. Zoom
4. Windows
1. Arrange all
2. Freeze Pane
3. Switch Window
4. Macro

Detail Explanation

Formula

IS FUNCTIONS

ISBLANK

ISERR

ISERROR

ISEVEN

ISODD

ISFORMULA

ISLOGICAL

ISNA

ISNUMBER

ISREF

ISTEXT

ISNONTEXT

MS Excel (Fact)

MS excel  Row & Column.

1. 1,048,576 rows by 16,384 columns

2.Column width - 255

Character.

3.Row height : 409 point 

4. Zoom range : 10 % to 400%

5.Example Comment

=A1 -----Complete relative reference

=$A1 -----The column is absolute; the row is relative

=A$1 -----The column is relative; the row is absolute

=$A$1------- Complete absolute reference

* Column Size 0 - Min   & 255 - Maximum   & Default 8.43

* Row Size 0 - Min   & 409 - Maximum   & Default 15

6. Error

#DIV/0!------- Trying to divide by 0. जब हम लोग किसी संख्या को 0 से Divide करते हैं तब इस तरह का इरादा है)

#N/A! -------A formula or a function inside a formula cannot find the referenced data(जब कोई वैल्यू वहां पर एग्जिट ही नहीं करती तब ऐसी आती है)

#NAME? ---------Text in the formula is not recognized गलत Furmula use करने पर. (= Sum ( A1:A4) in place = Sums(A1:A4)

#NULL! ---------A space was used in formulas that reference multiple ranges; a

comma separates range references

अगर आप दो नंबर को जोड़ना चाहते हैं कुछ जगह पर आपने "+" का साइन ना लगा कर "  "(Intersect operator) uSe किया .

(=A1+A2 )की जगह आपने( =A1  A2)

#NUM! --------A formula has invalid numeric data for the type of operation. जब गलत नंबर enter किया जाएगा तब ex = Sqrt(5) but we use =sqrt(-5)  का square root नहीं होता

#REF! --------A reference is invalid ( 

Like VLookup formula total column is 4 and you will try to find tha value of 8 Column which is not exist.)

#VALUE! -----The wrong type of operand or function argument is use

Ex  = 4 * 6 इसकी जगह आपने 4 * A

6.Types of Chart

1. Column Chart - vertical bars is useused for comparing the information.

2.Line chart :-  the ups and downs in your data over time. In this chart, data points are connected with lines.

3.horizontal bars that work like column charts.but opposite.

4.Unlike the line charts, gaps are filled with color in area charts. Area charts are easy to analyze the growth in business as its shows ups and downs through line.

5.pie chart is a rounded shape graph that is divided into slices of pie.campare portion

Note:- Pie chart is also known as Doughnut chart. 

7.Surface chart is actually a 3D chart that helps to represent the data into a 3D landscape