ms excel

Category: Education

Presentation Description

ms excel


Presentation Transcript

Slide 1:

MS EXCEL Submitted by:- Nimisha Gaur Submitted to:- Dr. Sourabh Sharma


EXCEL Excel is the world’s most widely used spreadsheet program, and is part of the Microsoft Office suite. Much of the appeal of Excel is due to the fact that it’s so versatile. Number crunching: Create budgets, analyze survey results, and perform just about any type of financial analysis we can think of. Creating charts: Create a wide variety of highly customizable charts. Organizing lists: Use the row-and-column layout to store lists efficiently. Accessing other data: Import data from a wide variety of sources.

Setting Up our Excel Environment:

Setting Up our Excel Environment

Starting a Workbook:

Starting a Workbook To Create a New, Blank Workbook: Left-click the Microsoft Office Button . Select New . The New Workbook dialog box opens and Blank Workbook is highlighted by default.

Starting a Workbook:

Starting a Workbook To Insert Text: Left-click a cell to select it. Each rectangle in the worksheet is called a cell . As we select a cell, the cell address appears in the Name Box . Enter text into the cell using our keyboard. The text appears in the cell and in the formula bar . Each cell has a name, or a cell address based on the column and row it is in. For example, this cell is C3 since it is where column C and row 3 intersect.

Modifying Columns, Rows, & Cells:

Modifying Columns, Rows, & Cells Columns, Rows, and Cells To Modify Column Width: Position the cursor over the column line in the column heading and a double arrow will appear. Left-click the mouse and drag the cursor to the right to increase the column width or to the left to decrease the column width. Release the mouse button.

Formatting Text:

Formatting Text Once we have entered information into a spreadsheet, we will need to be able to format it. In this ppt , we will learn how to use the bold, italic, and underline commands; modify the font style, size, and color; and apply borders and fill colors.

Working with Cells:

Working with Cells To Copy and Paste Cell Contents: Select the cell or cells you wish to copy . Click the Copy command in the Clipboard group on the Home tab. The border of the selected cells will change appearance. Select the cell or cells where you want to paste the information. Click the Paste command. The copied information will now appear in the new cells.

Slide 9:

Creating Complex Formulas Excel is a spreadsheet application and is intended to be used to calculate and analyze numerical information such as household budgets, company finances, inventory, and more. To do this, we need to understand formulas . In this ppt , we’ll discuss complex formulas that use multiple mathematical operators, and that use absolute and relative references .

Slide 10:

Sorting, Grouping, and Filtering A Microsoft Excel spreadsheet can contain a great deal of information. With more rows and columns than previous versions, Excel 2007 gives you the ability to analyze and work with an enormous amount of data . To most effectively use this data, you may need to manipulate this data in different ways. In this ppt , we will learn how to sort , group , and filter data in various ways that will enable you to most effectively and efficiently use spreadsheets to locate and analyze information.

Slide 11:

Filtering Cells Filtering, or temporarily hiding, data in a spreadsheet very easy. This allows you to focus on specific spreadsheet entries. To Filter Data: Click the Filter command on the Data tab. Drop-down arrows will appear beside each column heading. Click the drop-down arrow next to the heading you would like to filter. For example, if you would like to only view data regarding Flavors , click the drop-down arrow next to Category .

Slide 12:

Conditional Formatting Imagine we have a spreadsheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of these tools is called conditional formatting . With conditional formatting, we can apply formatting to one or more cells based on the value of the cell. we can highlight interesting or unusual cell values, and visualize the data using formatting such as data bars. In this ppt , we will learn how to apply, modify, and delete conditional formatting rules.

Insert :

Insert Options of insert menu bar Pivot Table It is used to arrange and summerise the complicated data. TableInsert or draw a table into the document. ShapesInsert ready made shapes such as rectangles and circles,arrows , lines,flowcharts symbols and callouts. Pictures Insert any picture

Slide 14:

ClipartInsert clip art into document including drawing, movies, sounds or photography to illustrate a specific concept. Other charts Insert a stock surface doughnut, bubble or radar chart. LineLine charts are used to display trends over time. ColumnColumn charts are used to compare values across categories. PiePie chart display the contribution of each value to a total. COND…

Slide 15:

Area Area charts emphasize differences between several sets of data over a period of time. Bar Bar charts are the best chart type for comparing multiple values. ScatterInsert a scatter chart also known as an XY Chart. This type of chart compares pairs of values.Use it when the values being charted are not in X-axis order or when they represent separate measurement. Word artInsert decorative text in your document. COND...

Slide 16:

Signature Line Insert signature line that specifies the individual who must sign. Inserted a digital signature requires that you obtains a digital ID,such as one from a certified microsoft partner. HyperlinkLinking or connecting the web page from one to another with the help of HTML(Hypertext markup language). COND. .

What is in Page Layout?:

What is in Page Layout? The options of the page layout exist to improve the presentation of your document on paper. We can change the margins of sheets, add the headers, the footers and several other options that will be discussed below. From the File menu, select the Page setup option. Page layout include the thems ,page setup,scale to fit,sheet option,arrange .

Slide 18:

Click the Page Layout tab in the Ribbon. Go to the Page Setup group, and then we will find that some common used setups, such as margins, backgrounds and size are listed in this group. For further setup, we should click the little square with an arrow in the right bottom of the group. Then a “Page Setup” box appears, and we can choose the settings based on your need. Click OK to finish it. Page setup

Slide 19:

Page tab , in the section Orientation, Excel asks we for the orientation of the pages to print.  Margins tab , we can determine the margins, the width between the border of the page and our text, for the file as well as those for the header and the footer of the page.    Header/Footer tab, we can determine what will be in the header and the footer of each of the pages of the printout. Sheet tab, in the print area section we can determine what range of cells will be printed in the printing area box. COND…


USING THE REVIEW TAB IN EXCEL PROOFING   Spelling  - Check the spelling of text. The keyboard shortcut to check spelling is F7 .   Research  - Open the Research Task Pane to search through reference materials such as dictionaries, encyclopedias , and translation services. The keyboard shortcut for Research is Alt + Click .   Thesaurus  - Suggests other words with a similar meaning to the word you have selected.   Translate  - Translate the selected text into a different language.

Slide 22:

COMMENTS   Edit Comment  - Edit the selected comment. The keyboard shortcut to edit a selected comment is Shift + F2 . Note: This button will not be displayed unless a cell containing a comment has been selected.   New Comment  - Add a comment about the selected cell. The keyboard shortcut to add a comment is Shift + F2 . Note: This button is the default view in the Comments section rather than the Edit Comment button displayed at the top of this explanation.   Delete (comment)  - Delete the selected comment.   Previous (comment)  - Select the previous comment in the worksheet.   Next (comment)  - Navigate to the next comment in the document.   Show/Hide Comment  - Show or hide the comment attached to the selected sheet.   Show All Comments  - Display all comments in the sheet.   Show Ink  - Show or hide any ink annotations on the sheet.

Slide 23:

CHANGES   Protect Sheet  - Prevent unwanted changes to the data in a sheet by specifying what information can be changed. For example, you can prevent people from editing locked cells or changing the formatting of the document. You can specify a password that can be entered to unprotect the sheet and allow these changes.   Protect Workbook  - Prevent unwanted changes to the structure of the workbook, such as moving, deleting, or adding sheets. You can specify a password that can be entered to unprotect the workbook and allow these changes. Share Workbook  - Allow multiple people to work in a workbook at the same time. The workbook should be saved to a network location where multiple people can open it. Workbooks containing tables cannot be shared.  Protect and Share Workbook  - Share the workbook and protect it with a password at the same time. The password will prevent others from turning off change tracking.   Allow Users to Edit Ranges  - Allows specific people to edit ranges of cells in a protected workbook or sheet. Before using this feature, first set security on the sheet by using the Protect Sheet command. To use this feature, your computer must be joined to a Microsoft Windows domain.  Track Changes - Track all changes made to the document, including insertions, deletions, and formatting changes.


USING THE VIEW TAB IN EXCEL Workbook Views  Normal  - View the document in Normal view.   Page Layout  - View the document as it will appear on the printed page. Use this view to see where pages begin and end, and to view any headers or footers on the page.   Page Break Preview  - View a preview of where pages will break when this document is printed.   Custom Views  - Save a set of display and print settings as a custom view. Once you have saved the current view, you can apply it to the document by selecting it from the list of available custom views.   Full Screen  - View the document in full screen mode.

Slide 25:

Show/Hide Ruler  - View the rulers used to measure and line up objects in the document.   Grid lines  - Show, or hide, the lines between rows and columns in the sheet. Showing makes numbers in columns or rows easier to read or edit. Hiding Grid lines is useful if you are making a graphic organizer in Excel. These lines will not print unless the Print box is checked.  Message Bar  - Open the Message Bar to complete any required actions on the document.  Formula Bar  - View the formula bar in which you can enter text and formulas into cells.   Headings  - Show row and column headings. Row headings are the row numbers on the side of the sheet that range from 1 to 1,048,576. Column headings are the letters that appear above the columns on a sheet that range from A to XFD. This is also found on the Page Layout tab of an Excel Workbook.

Slide 26:

Window   New Window  - Open a new window containing a view of the current document.   View Side by Side  - View two worksheets side-by-side so that you can compare their contents. Arrange All  - Tile all open program windows side-by-side on the screen. Synchronous Scrolling  - Synchronize the scrolling of two documents so that they scroll together. To enable this feature, turn on View Side by Side. Freeze Panes  - Keep a portion of the sheet visible while the rest of the sheet scrolls.  Reset Window Position  - Reset the window position of the documents being compared side-by-side so that they share the screen equally. To enable this feature, turn on View Side by Side.  Split  - Split the window into multiple resizable panes containing views of your worksheet. You can use this feature to view multiple distant parts of your worksheet at once.   Save Workspace  - Save the current layout of all windows as a workspace so that it can be restored later.  Hide  - Hide the current window so that it cannot be seen. To bring the window back, click the Unhide button.   Switch Windows  - Switch to a different currently open window.  Unhide  - Unhide and windows hidden by the Hide Windows feature.  

Slide 27:

MACROS   Macros  - View the list of macros, from which you can run, create, or delete a macro. The keyboard shortcut for viewing macros is Alt + F8 

authorStream Live Help