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 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.

Each Menu tab has many commands.

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.

Customizing Quick Access Toolbar.

ok.

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 Address.

Using arrows keys move the cell pointer.

Using the 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.

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.

view

Using shortcut menus and the Mini toolbar.

Select row.

Right-click.

Insert (that row will be inserted).

Select column.

Right-click.

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.

Insert…

Delete…

Using Help.

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

Tell me what you want to do.