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