Breaking News

Introduction to Microsoft Excel.

What is Microsoft Excel used for?

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.

 Ribbon bar

Each Menu tab has many commands.

tab

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

ok.

Understanding workbooks and worksheets.

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

worksheets

1048576 Total Rows.

Columns

16384 Total Columns.

Rows

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

view

 switch windows

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…

Using shortcut menus and the Mini toolbar

Delete…

Delete

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

 filter

 help preview

 

 

 

About imran

Avatar
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

Microsoft Excel Data Analysis Tools

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