Everything You Need To Know On Excel Ribbon Part 1

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=L2J86zJjOkA

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

#############################

New on site