• MS Excel Tutorial
• Excel Tutorial
• Workbook Window
• Office Button
• Ribbon and Tabs
• Quick Access Toolbar
• Mini Toolbar
• Title, Help, Zoom, View
• Excel Worksheet
• Worksheet, Row, Column
• Enter Data
• Select Data
• Delete Data
• Copy Paste Data
• Spell Check
• Insert Symbols
• Excel Calculations
• Addition
• Sigma Addition
• Subtraction
• Calculate Average
• Excel Fill Handle
• Fill Handle
• Fill Handle with Text
• Text with Numbers
• Fill Handle with Dates
• Excel Formula
• Create Formula
• Fill Handle in Formula
• Quick Excel Functions
• Excel IF
• If Function

Ribbons and Tabs

Each tab has its own specific groups of related commands. These groups have several additional commands that can be viewed by clicking the arrow at the right bottom corner of any group.
Ribbon is on the top of worksheet, below the title bar or name of the excel file. It contains seven tabs: Home, Insert, Page Layout, Formulas, Data, Review and View.

Home Tab

The tabs that can be seen on the Home tab are Clipboard, Font, Alignment, Number, Cells and Editing

Insert Tab

The tabs visible are Tables, Illustrations, Charts, Sparklines, Filter, Links, Text, Symbols

Page Layout Tab

We can see Themes, Page Setup, Scale to Fit, Sheet Options and Arrange on the Page Layout Tab

Formula Tab

Function Library, Defined Names, Formula Auditing, Calculation are functions on the Formula tab.

Data Tab

Get External Data, Connections, Sort & Filter, Data Tools and Outline

Review Tab

Proofing, Comments and Changes

View Tab

Workbook Views, Show/Hide, Zoom, Window and Macros

MORE TUTORIALS ON LATEST TECHNLOGIES