Everything You Need To Know On Excel Ribbon: Part 1

In this Excel basic tutorial i'll explain excel ribbon. Things i explained in this video are given below.
A. File
B. Home
a. Clipboard
i. Cut
ii. Copy
1. Copy
2. Copy as picture
iii. Format painter
iv. Paste
1. Paste
2. Paste values
3. Other paste options
4. Paste special
b. Font
i. Font name
ii. Font size
iii. Increase font size
iv. Decrease font size
v. Bold
vi. Italic
vii. Underline
1. Double underline
viii. Fill color
ix. Font color
c. Alignment
i. Top Align
ii. Middle Align
iii. Bottom Align
iv. Orientation
1. Angle counterclockwise
2. Angle clockwise
3. Vertical text
4. Rotate text up
5. Rotate text down
6. Format cell alignment
v. Align left
vi. Align center
vii. Align right
viii. Decrease indent
ix. Increase indent
x. Wrap text
xi. Merge & Center
1. Merge & Center
2. Merge Across
3. Merge Cells
4. Unmerge Cells
d. Number
i. Number format dropdown
1. General
2. Number
3. Currency
4. Accounting
5. Short date
6. Long date
7. Time
8. Percentage
9. Fraction
10. Scientific
11. Text
12. More number formats
ii. Accounting number format
iii. Percent style
iv. Comma style
v. Increase decimal
vi. Decrease decimal
e. Styles
i. Conditional formatting
ii. Format as table
1. Light
2. Dark
3. New table style
4. New pivot table style
iii. Cell style
1. Good, bad & neutral
2. Data & models
3. Titles & headings
4. Number format
5. Merge style
f. Cells
i. Insert
1. Insert cells
2. Insert sheet rows
3. Insert sheet columns
4. Insert sheet
ii. Delete
1. Delete cells
2. Delete sheet rows
3. Delete sheet columns
4. Delete sheet
iii. Format
1. Row Height
2. Auto fit Row Height
3. Column width
4. Autofit column width
5. Default width
6. Hide & Unhide
7. Rename Sheet
8. Move or copy Sheet
9. Tab Color
10. Protect Sheet
11. Lock cell
12. Format Cell
g. Editing
i. AutoSum
1. Sum
2. Average
3. Count Numbers
4. Max
5. Min
6. More Functions
ii. Fill
1. Down
2. Right
3. Up
4. Left
5. Across Worksheets
6. Series
7. Justify
8. Flash fill
iii. Clear
1. Clear All
2. Clear Format
3. Clear Content
4. Clear Comment
5. Clear Hyperlink
6. Remove Hyperlink
iv. Sort & filter
1. Sort A-Z
2. Sort Z-A
3. Custom Sort
4. Filter
5. Clear
6. Re-apply
v. Find & Select
1. Find
2. Replace
3. Go TO
4. Go to Special
5. Formulas
6. Comments
7. Conditional formatting
8. Constants
9. Data validation
10. Select object
11. Selection pane
C. Insert
a. Tables
i. Pivot Table
ii. Recommended Pivot Tables
iii. Table
b. Illustrations
i. Picture
ii. Shape
iii. Icon
iv. 3D Model
v. Smart Art
vi. Screenshot
c. Add-ins
i. Get Add-ins
ii. My Add-ins
d. Charts
i. Recommended Charts
ii. Column or Bar Chart
iii. Line or Area Chart
iv. Pie or Doughnut Chart
v. Insert Hierarchy Chart
vi. Insert Statistic Chart
vii. Insert Scatter or Bubble Chart
viii. Insert Waterfall, Funnel, Stock, Surface or Radar Chart
ix. Insert Combo Chart
x. Maps
xi. Pivot Chart
1. Pivot Chart
2. Pivot Chart and pivot Table
e. Tours
i. 3D Map
1. Open 3D Map
f. Sparklines
i. Line Sparkline
ii. Column Sparkline
iii. Win/Loss Sparkline
g. Filters
i. Slicer
ii. Timeline
h. Links
i. Text
i. Text Box
ii. Header & Footer
iii. Word Art
iv. Signature Line
v. Object
j. Symbols
i. Equation
ii. Symbol
D. Page layout
a. Themes
i. Themes
1. Ready Themes
2. Browse for Themes
3. Save Current Themes
ii. Colors
1. Pre-defined colors
2. Customize Colors
iii. Fonts
1. Pre-defined Font
2. Customize Fonts
iv. Effects
b. Page Setup
i. Margins
1. Normal
2. Wide
3. Narrow
4. Custom Margins
ii. Orientation
1. Portrait
2. Landscape
iii. Size
1. Letter
2. A4
3. More Paper Size
iv. Print Area
1. Set Print Area
2. Clear Print Area
v. Breaks
1. Insert Page Break
2. Remove Page Break
3. Reset All Page Breaks
vi. Background
vii. Print Titles
c. Scale to Fit
i. Width
ii. Height
iii. Scale
d. Sheet Options
i. Gridlines
1. View
2. Print
ii. Headings
1. View
2. Print
e. Arrange
i. Bring Forward
1. Bring Forward
2. Bring to Front
ii. Send Backward
1. Send Backward
2. Send to Back
iii. Selection Pane
iv. Align
1. Align Left
2. Align Center
3. Align Right
4. Align Top
5. Align Middle
6. Align Bottom
7.Distribute Horizontally
8. Distribute Vertically
9. Snap to Grid
10. Snap to Shape
11. View Gridlines
v. Group
1. Group
2. Re-Group
3. Un-Group
vi. Rotate
1. Rotate Right 90 °
2. Rotate Left 90 °
3. Flip Vertical
4. Flip Horizontal
5. More Rotation Options

Thanks for watching.

Support the channel with as low as $5
  / excel10tutorial  

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG