ms excel new ppt upload

8/17/2019 Ms Excel New Ppt Upload

1/15

MS-Excel

Click icon to add picture


2/15

What is spreadsheet?A spreadsheet is a sheet of paper that shows accounting orother data in rows and columns.

Visicalc was the rst desktop computer spreadsheet,published in !"# to run on Apple $$.


3/15

Around 15 spreadsheetsare there in market.

Some of Popular Spreadsheets in market.

Free spreadsheet applications which are available in market.

Paid spread sheet applications which are available in market.


4/15

WHAT IS MS!"C!#?

Microsoft Excel is a “spreadsheet”application developed by Microsoftfor Windows, Mac O !, "ndroid and

iO.

#t feat$res calc$lation, %raphin% tools, pivot tables, and a macro pro%rammin% lan%$a%e called &is$al'asic for "pplications.


5/15

Histor$ of MS!%cel

M i c r o s o f t r e l e a s e d f i r s t v e r s i o n o fM S - E x c e l o n 3 0 t h S e p t e m b e r 1 9 8 5 .


6/15

&ses of MS!%celMicrosoft Excel isperhaps the most

importantcomputer softwareapplication used in

the workplacetoday.

Microsoft Excel is useful because its extremel! versatile"and can be molded into #hatever scenario #or$s best for !ou.

Here are the 5 reasons why learning Microsoft Excel willhelp boost your skills, increase your rate and make you more employable.

1. ou!ll be faster.". ou!ll get more things done.#. ou!ll ama$e your Manager and %lient.

&. ou!ll reduce errors.5. ou!ll create new ideas'%hallenging(.


7/15

'i(erent )et*een*ork)ook and *orksheet.) workbook is the M* Excel file in which you

enter and store related data.

) worksheet 'also known as a spreadsheet( is acollection of cells on a single +sheet.

-here are 1,#/& %olumns 0 1,&/,52 3ows ina single sheet.


8/15

New Excel workbook

4y default, Excel will open a blank workbook that contains #worksheets.

'we can open "5 worksheets in a workbook(.


9/15

WorksheetSample

To change the column widthPut the cursor online between twocolumns and clickleft button of themouse and drag

slowly to desiredwidth.


10/15

What is Ribbon in MSoffice.-he 3ibbon replaces the menus and toolbars found inearlier ersions of Excel.(ibbon is the strip of b$ttons and icons locatedabove the work area that was )rst introd$ced with

Excel *++.

-hree parts of 3ibbon are 6

1.-)4*".7roup#.%ommands


11/15

What is +C!##, in MS

!"C!#.8n spreadsheet applications, a cell is a box in which you

can enter a single piece of data.-he data is usually text, a numeric alue, or a formula.

-he entire spreadsheet is composed of rows and columns of cells.8ndiidual cells are usually identified by a column letter and a

row number.

'9or example,:1"specifies the cell in column : and row 1"(


12/15

What is +-ormula, in MS

!%cel.•

;ne of the important parts of learning formulas isunderstanding the concepts.

• ) formula is statement written by the user to becalculated. 9ormulas can be as simple or ascomplex as the user wants.

• ) formula contains 1?"?#,>


13/15

What is +-unction, in MS

!%cel.The Pre-defined formula’s are called as “unction!.Some of Widely used Function in MS-Excel are.

Sum function "dds all the numbers in a range of cells.

Sumif function"dds the cells s#ecified by a gi$en condition.

% function&hecks whether a condition is met' and returns one $alue if “True! or “alse!.

(looku# function

#//0&P lets $ou search for speci2c information in $our spreadsheet.

Su)total function3eturns a su)total in a list or data)ase.


14/15

!%cel related We)sites-or 4asic !%celhttp66***.e%celeas$.com6http66!%celTip.comhttp66chalkstreet.com6 7ideo a8aila)le9.

-or ad8ance !%celhttp66chandoo.or:6http66***.e%celhero.com6http66***.atlaspm.com6http66dail$doseofe%cel.com6

http66ra;e%cel.)lo:spot.in6


15/15

Thank $ou

ms excel new ppt upload

Documents