Microsoft Excel

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

PowerPoint Presentation:

WELCOME TO ALL

PowerPoint Presentation:

MICROSOFT EXCEL TOPIC :

PowerPoint Presentation:

MICROSOFT EXCEL

PowerPoint Presentation:

MICROSOFT EXCEL Microsoft EXCEL is a powerful spreadsheet application. The Micro Soft Excel or MS Excel is a windows based program that is used for calculating data and examining them. This is the spread sheet program widely used in PCs also. The MS Excel is a very useful software that is used for the economical examination, preparation of budget…etc. Accounting work can be done very easily without any mistake, with the help of MS Excel. EXCEL worksheet data, charts and graphs can be easily transferred to MS PowerPoint and MS Word.

PowerPoint Presentation:

WORK BOOK Workbook is the file that stores data in Microsoft EXCEL. A workbook itself may contain many worksheets. So we can arrange different types of data in a same file. The specialty of the worksheet is the easy preparation of economic reports and comparison…etc. The data which are stored in different worksheets can be compared at the same time and its effect can also be seen. Each sheet in the EXCEL actually contains more than 256 columns and 1048576 rows. In the beginning 20 columns and 25 rows are only seen in the screen. A maximum of 32 sheets can be added to a workbook and can be deleted up to one.

PowerPoint Presentation:

Cell address : It is the address to identify a particular cell. A cell address is given with the name of the column followed by the no. of rows it happen. e.g.: A1,E2,B3…etc Excel is possible to filter the given data based on the given criteria. For e.g. We have to filter the results of a student in a college or school on the basis of the ranks obtained by them using data option. Also we can format the cells based on a special condition.

PowerPoint Presentation:

Cell Pointer: The cell which is presently active is seen highlighted in a square. This is called CELL POINTER Cell Pointer is used to show the placement of data in the worksheet. You can move the cells pointer by using mouse, arrow keys, Tab, enter, shift ,tab keys …etc

PowerPoint Presentation:

TOOLBARS In Microsoft Excel 2007for a PC the toolbars are automatically placed as tabs at the top of the screen. When these tabs you will find all of your options to change text, data , page layout and more . THREE COMMONLY USED TABS The HOME Tab The INSERT Tab The PAGE LAYOUT Tab

PowerPoint Presentation:

The HOME Tab This is one of the most common used tabs in Excel. You are able to format the text in your document, cut, copy and paste information. Change the alignment of your data, insert delete and format cells. The HOME Tab also allows you to change the number of your data.

PowerPoint Presentation:

The INSERT Tab This tab is mainly used inserting visuals and graphics into your document. There are various different things that can be inserted from this tab such as pictures, clip arts, charts, links, headers, and footers and word art.

PowerPoint Presentation:

The PAGE LAYOUT Tab Here you are able to add margins, themes to your documents, change the orientation, page breaks and titles. The scale fit of your document is also included as a feature within this tab, if needed.

PowerPoint Presentation:

Format Pointer: We can copy the format of a particular cell and make applicable to another cells We can make use of copy  paste special option to make a given format applicable to all the cells selected.

PowerPoint Presentation:

We can make use of the fill series options to type the consecutive numbers in a given area. The function option in Excel is widely used in banking sector to calculate the loan %, loan period, installment of the payment…etc We can increase and decrease the column width and row height