Breaking News

Microsoft Excel Tutorial.

What is Microsoft Excel used for?

Microsoft Excel Tutorial covers complete Excel Training.  Microsoft Excel is used especially for the business purpose and it is used for accounting. Where we work on rows, columns, sheets, formulas, charts, etc.

Microsoft Excel Tutorial

Microsoft Excel is a spreadsheet program. Excel is often is used to maintain a large list of data. This might be a customer list database.

Microsoft Excel is the product of Microsoft.

Using the menu system.

When you open Microsoft Excel you see at the top a series of the tab by the group of icons. The entire menu system is referred to as a ribbon.

The most common tab which is frequently is used is the Home tab.

Ribbon bar.

 Ribbon bar

Each Menu tab has many commands.


Back Stage View: –

 Back Stage View

Dialogue Box Launcher.

Ribbon Display option.

Using the Quick Access Toolbar.

Above the ribbon menu system, the upper left corner of your screen it is called quick access toolbars

It has initially some toolbars.

Quick access bar.

Using the Quick Access Toolbar

Using the Quick Access Toolbar 2

Using the Quick Access Toolbar 3

 Using the Quick Access Toolbar 4

Customizing Quick Access Toolbar.

Customizing Quick Access Toolbar.

Customizing Quick Access Toolbar more commands


Understanding workbooks and worksheets in Microsoft Excel Tutorial.

There is a certain excel term we use consistently.

In excel file is the workbook.

A workbook is a file newly always we can use those two terms interchangeably.

Sheets depend on available memory (default is 1 sheet).


1048576 Total Rows.


16384 Total Columns.


Cell pointer.

 Cell pointer

Cell Address.

 Cell Address

Using arrows keys move the cell pointer.

arrows keys

Using the Formula bar.

Formula bar

A screen just below the ribbon that is called formula bar.

Formula bar contains the information if the active cell contains the information.

Using the Status bar.

At the bottom below the sheets tab, there is the status bar.

Often there is word ready in which you see the left corner.

Status bar

Status bar more options

Using navigation tools.

Whether you use a mouse or track-pad.

Moving the mouse or fingers on track-pad moves it is called the cursor.

navigation tools

navigation tools 2


 switch windows

Using shortcut menus and the Mini toolbar.

Select row.


Insert (that row will be inserted).

Select column.


Insert (that column will be inserted).

If you want to delete row or column then right-click.

Delete. (Then row /column will be deleted).

I will check it for duplicating the below commands.


Using shortcut menus and the Mini toolbar



Using Help.

When you hover over any command it tells about the command.

Using Excel Help

Using Excel Help 2

help preview

help shortcut

Tell me what you want to do.

Tell me what you want to do


 help preview

Spread the love

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …