Microsoft Excel

 MS Excel
    Microsoft excel is a spread sheet application. Developed by Microsoft for Microsoft windows and Mac OS. It is used to prepare any types of report, mathematical data, logical data etc. In the MS Excel if you modify your data value the formulated value will be modified automatically. The extension of MS Excel fil is ".xlsx".

Spread sheet 
    A sheet is organization in row and column is called spread sheet. It is also called electronic spread sheet. 

Row 
    A row is a grouping of cell that runs from left to right of a page. The maximum row in per sheet is 1048576.

Column
    A column is a grouping of cell that run from up to down of a page. the maximum column in per sheet is 16384.

Cell
    Cell is combination of row and column. The total number of cell in per sheet is 17179869184.

Row header
    It indicates the row header. It starts with "1" and ends with "1048576". You can go to last row press Ctrl + Down arrow and go to the first row press Ctrl + up arrow.

Column header
    It indicates the column header. It starts with "A" and ends with "XFD". You can go to the last column press Ctrl + Right arrow and go to the first column press Ctrl + Left arrow.

Name box
    It is used to display the address of selected cell. From it you may jump choice of cell. 

Formula bar
    It is used to display the contents of selected cell and also display the formula in resulted cell.

Worksheet
    Worksheet is a working area of MS excel. This is divided in from of rows and column. By default there are three worksheet available in MS Excel. But user can insert more worksheet according to needs. The shortcut of insert worksheet is "Shift+F11".

Workbook
    A Microsoft office Excel workbook is file. The contents one to more worksheet that you can used to organization varies kinds of related information. 

Ms Excel provide two window
    1. Application window-An outer window through which user communicates which MS Excel is called an application window. 
    2. Spreadsheet window- An inner window in which user enters the data in row and column is called spread sheet window/workbook window.

Home tab 

Cut- It is used to cut of selected cell. 

Copy- It is used to copy of selected cell.

Paste- It is used to paste the contents of the clip board.

Paste special- Excel allows you to paste only specific aspects of cell data by using the paste special feature. A variety of data can be pasted using the paste special command. 

Format painter- It is used to copy formatting from one place and apply it to another place. 

Font- It is used to change the font face of range of cell.

Increase font size- It is used to increase the font size of selected cell.

Decrease font size- It is used to decrease the font size of selected cell. 

Bold- It is used to make bold the text of selected cell.

Italic- It is used to make italic the text of selected cell. 

Underline- It is used to make underline the text of selected cell.

Border- It is used to infliction verity types of border of selected cell. 

Fill color- It is used to color the back ground of selected cell. 

Font color- It is used to change the text color of selected cell.

Align- It is the position on a cell that value appears. Such as- left, center, right, etc. value can also be made to appear closer to the top or bottom of a large cell. 

There are six types of Align in MS Excel
1.TopAlign- It is used to align text to top of the selected cell.
2.Middle Align- It is used to align text so that it is centered between the top and bottom of the selected cell.
3.Bottom Align- It is used to align text to bottom of the selected cell. 
4. Left Align- It is used to align text to the left of selected cell. 
5. Center Align- It is used to align text to the center of selected cell. 
6. Right Align- It is used to align text to the right of selected cell. 

Orientation - It is used to rotate text to a diagonal, angle or vertical orientation. 

Wrap Text - It is used to make or all contents visible within a cell by displaying it on multiple lines.

Merge Cell - It is used to merge the cell. There are four choice of merge cell. 
1. Merge & Center - It is used to combine the cell and create the contents as center.
2. Merge Across - It is used to combine the cells a cross column withought centering data.
3. Merge cell - It is used combine the cell in the range withought centering.
4. Unmerge cell - It is used to split the cell that have been merged.

Number - It allows to display different number types of dismal place.

Conditional Formatting  - It is an analysis MS Excel which is used to display the conditional formatting of selected cell.

Format as table - It is used quickly format a range of cells and convert it to a table by choosing pre-defined table style.

Cell Style - It is used to quickly format a cell by choosing from pre-defined style. You can also define your own cell style.

Insert - It is used to insert row, column, cell and sheet in your workbook.

Delete - It is used to delete row, column, cell and sheet in your workbook.

Format - It is used to set the row width, column height, rename the sheet, move or copy sheet, tab color etc.

Auto Sum - It is used to display the sum of the selected cell directly after used of auto sum. The short cut of auto sum is "Alt + =".

Fill - It is used to fill the cell in any direction, series and auto fill.

Clear - It is used to delete everything from the cell. Such as - formats, contents, comments etc.

Sort & Filter - It is the most using command in MS Excel which is used to filter the data as per requirement. Such as - ascending or descending order.

Find & Select - It is used to find and select specific text, formatting or types of information within the workbook.

Insert Tab

Pivot table - Pivot table makes it easy to arrange, summarize, complicated data and drill down on details for grand.

Table - Table makers it easy to sort, filter and format data wither a sheet.

Picture - It is used to insert the picture from a file in your document. 

Clipart - It is used to insert the clip art picture in to the document. 

Shapes - It is used to insert to readymade shapes in your document. Such as - circle, rectangular, arrow etc.

Smart art - It is used to insert a smart art graphic to visually communicate information in your document.

Chart - It is a graphical representation of numeric data. There are many types of chart like column chart, line chart, pie chart, bar chart etc.

Hyper link - It is used to create link between two deferent files.

Text box - It is used to insert a text box that can be positions any ware on the page.

Header & Footer - It is used to edit the header and footer of the document.

Word art - It is used to insert the decorative text in your document.

Signature line - It is used to insert signature line in your document. 

Object - It is used to insert an embedded object in your document.

Symbol - It is used to insert character there are not on you keyboard such as arrow symbol, tread mark symbols, Unicode characters etc.



Page Layout

Themes - It is used to change the overall design if the entire document. Such as - color, font and effect.

Margin - It is used to select the margin size for the entire document, or current section. There are six types of margin in MS Excel.


Page Orientation - It is used to switch the pages between portrait and landscape.

Paper Size - It is used to choose the paper size for the current section. By default paper size is letter but user can choose other size according to needs

Print area - It is used to define a specific area of the sheet for printing.

Page Breaks - It is used to specify where a new page will be in the printed copy. Page break are insert above and to the left of the section.

Back Ground - It is used to choose an image to display as the background of the sheet.

Print Title - It is used to specify rows and column to repeat on each printed page.

Bring to front - It is used to bring the selected object back one level or to the front of all object.

Send to back - It is used to send the selected object back one level or to the back of all object.

Selection pens - It is used to show the selection pen to help select individual objects and to change their order and visibility. 

Rotate - It is used to rotate or flip the selected object 

Data Tab:-
Data  Validation- MS Excel provides the feature or validation which is used to specify as user needs. Condition on selected cell and also given message a file specially the condition when the users enter as your data and the entered data do not specify message.

Sort - It is used to sort data based on several create area at once. There are two types of sorting.
(i) Ascending Order        (ii) Descending Order

Scenario Manager - It is an analysis of MS Excel which is used to modify the value of depending cell and before find change to president cell display summary about data.

Goal Seek - It is an analysis of MS Excel which is used to modify the value of precedent cell that increase or decrease value with current row single cell.

Subtotal - MS Excel provides the feature of subtotal which is used to calculate subtotal of numeric fill the required most be inserted in ascending order0 or descending order.


Review Tab (ALT+R):-
Comment - It is used to add a comment about the selection. It display with red triangular mark right upper corner in the cell. The short cut of insert comment is shift+F2. It displays when you move the pointer in it.

Protect Sheet - It is a part of protection which is used to protect active sheet only. After using this feature your sheet will be make red only.

Protect Work Book - It is a part of protection also which provides facility to not delete, move any sheet or rename etc...

Track Change - It is used to track all changes made to the document including insertion, delectations, and formatting changes.


View Tab (ALT+W):-

Normal View - It is used to view the document in normal view.
Page Layout - It is used to view the document as it will appear on the printed page.
Page Break Preview - It is used to view a preview of where page will break when this document is printed.
Full Screen - It is used to view the document in full screen mode.
New Window - It is used to open a new window containing a view of the current document.
Arrange All - It is used to tile all open program windows side by side on the screen.
Freeze Panes - It is used to freeze the row and column. 

Comments

Post a Comment

Popular posts from this blog

MS Word

Microsoft Word:            Microsoft Word  is a word processor application program which is used to create any types of letters, notes and more types of official document & user can format the contents simply and complex. In the MS Word there are available all possible option which helps user can create a good document.  Like spelling and grammar check, hyphenation, mail merge, change case etc. The Title Bar:           It is displayed at the top of the every application which displays the title of the document. When you open MS word the first new document opens with document 1and when you save your document it displays the name of your file which you have given. The MS Office Button (Alt+F):          It displays at left side of the title bar. Where user can create a new file, open an existing file, save a file and perform many other tasks. The Ribbon:         ...
Read more

Microsoft Power Point

 Power Point MS Power Point is powerful software of MS Office. Which provides a number of tools to create a good presentation, convinces, motivate and educate to audience about organization. A presentation is a collection of slides. A slide contains text, graphics and object. The extension of power point is .pptx. Presentation  Those all methods and process which is used to explain about specific topic and thing to audience is called presentation. Slide It is the heart of presentation because we add all aliments of presentation on the slide. There are following aliments of slide. Such as - text, Number, other symbol, audio, video, sound. Place holder  Place Holder holds the object in your slide. you can use place holder to hold, text, clip art, and more. Mine tool bar       It is types of toolbar. Which is used to format your selected text, such as - Bold, Italic, Font Size, etc. Slide View  It is the working view of MS power point. There are six views...
Read more