MICROSOFT EXCEL


MICROSOFT EXCEL

FILE:
PRINT AREA
SET PRINT AREA

Defines the selected range as the print area, which is the only portion of the worksheet that will be printed.

CLEAR/RESET PRINT AREA

Deletes the print area in the active sheet.

EDIT
DOWN/RIGHT/UP/LEFT

Copies the contents and formats of the various sides.

SERIES

Fills the selected range of cells with one or more series of numbers or dates. The contents of the first cell or cells in each row or column of the selection are used as the starting values for the series.

JUSTIFY

Redistributes the text contents of cells to fill the selected range. Numbers or formulas cannot be filled and justified. Except for the left column, cells in the range should be blank.

CLEAR ALL/CONTENTS

Removes all cell contents and formatting, including comments and hyperlinks, from selected cells.

FORMATS

Removes only the cell formats from selected cells; cell contents and comments are unchanged.

COMMENTS
Removes only the comments attached to selected cells; cell contents and formats are unchanged.

DELETE

Removes the selected object. In Outlook, removes the selected item from the view and moves it to the Deleted Items folder.

DELETE SHEET
Deletes the selected sheets from the workbook. You cannot undo this command.

Move or Copy Sheet
Moves or copies the selected sheets to another workbook or to a different location within the same workbook.

NORMAL
Switches to normal view, which is the default view for most tasks in Microsoft Excel, such as entering data, filtering, charting, and formatting.

PAGE BREAK PREVIEW
Switches the active worksheet to page break preview, which is an editing view that displays your worksheet as it will print. In page break preview, you can move page breaks by dragging them left, right, up, or down. Microsoft Excel automatically scales the worksheet to fit the columns and rows to the page.

FORMULA BAR
Displays or hides the formula bar.

STATUS BAR
Shows or hides the status bar.

CUSTOM VIEWS
Creates different views of a worksheet. A view provides an easy way to see your data with different display options. You can display, print, and store different views without saving them as separate sheets.

INSERT
INSERT CELLS
Inserts the number of cells, rows, or columns you select. In Word, this command is available only when you’ve selected one or more end-of-cell marks.

INSERT ROWS
Inserts the number of cells, rows, or columns you select. In Word, this command is available only when you’ve selected one or more end-of-cell marks.

INSERT COLUMNS (TABLE COMMAND)
Inserts the number of cells, rows, or columns you select. In Word, this command is available only when you’ve selected one or more end-of-cell marks.

WORKSHEET
Inserts a new worksheet to the left of the selected sheet.

CHART WIZARD
Starts the Chart Wizard, which guides you through the steps for creating an embedded chart on a worksheet or modifying an existing chart.

PAGE BREAK
Inserts a page break above a selected cell. This command changes to Remove Page Break if you have a cell selected that is adjacent to a manually inserted page break.

PASTE FUNCTION
Displays a list of functions and their formats and allows you to set values for arguments.

DEFINE
Creates a name for a cell, range, or constant or computed value that you can use to refer to the cell, range, or value.

PASTE
Inserts the selected name into the formula bar. If the formula bar is active and you begin a formula by typing an equal sign (=), clicking Paste pastes the selected name at the insertion point.

MAP
Creates a map based on the selected data. The data should contain geographic references, such as abbreviations of countries or states. To set the location and size of the map on your worksheet, drag the cross hair.

Object (Insert menu)
Inserts an object ¾ such as a drawing, WordArt text effect, or an equation ¾ at the insertion point.

Insert / Edit Hyperlink
Inserts or edits the hyperlink you specify.

FORMAT:
Cells
Applies formats to the selected cells. This command might not available if the sheet is protected.

Row / Column
To auto fit, increase or decrease the size of the row / column.

Sheet
Rename
Renames the active sheet.

Hide
Hides the active sheet. The sheet remains open and accessible to other sheets, but it is not visible. You can’t hide the only visible sheet in a workbook.

Background
Inserts a tiled graphic image in the worksheet background, based on the bitmap you select.

AutoFormat
Applies a built-in combination of formats, called an autoformat, to a cell range or a PivotTable. If a single cell is selected, Microsoft Excel automatically selects the range surrounded by blank cells and applies the autoformat to that range. If the selection is part of a PivotTable, the entire table, except for the page fields, is selected and formatted. This command is not available if the sheet is protected.

Conditional Formatting
Applies formats to selected cells that meet specific criteria based on values or formulas you specify.

Style
Defines or applies to the selection a combination of formats, called a style.

TOOLS
Shared Workbooks
Switches to shared workbook mode, which allows you and other users on your network to edit and save changes to the same workbook.

Protection
Protect Sheet
Prevents changes to cells on worksheets, items in a chart, graphic objects on a worksheet or chart sheet, or code in a Visual Basic Editor form.

Protect Workbook
Protects a workbook’s structure and windows. You can prevent changes to the structure of a workbook so that sheets can’t be deleted, moved, hidden, unhidden, or renamed, and new sheets can’t be inserted. You can also protect windows from being moved or resized.
When the active document is protected, the command name changes to Unprotect Workbook.

Protect for Sharing
Protects the sharing and change history tracking in a shared workbook so the features can’t be turned off. If you select this check box and click OK when the workbook isn’t a shared workbook, you’re asked if you want to save it as a shared workbook. In a workbook that’s already shared, you can turn on protection for sharing and the change history, but you can’t assign a password for this protection. To assign a password, you must first remove the workbook from shared use.

When the active shared workbook is protected, the command name changes to Unprotect for Sharing.

Goal Seek
Adjusts the value in a specified cell until a formula that is dependent on that cell reaches a target value.

Scenarios
Creates and saves scenarios, which are sets of data you can use to view the results of what-if analyses.

Auditing
Trace Precedents
Draws tracer arrows from the cells that supply values directly to the formula in the active cell (precedents). To trace the cells that supply values indirectly to the formula in the active cell, click the Trace Precedents button again.

Trace Dependents
Draws a tracer arrow to the active cell from formulas that depend on the value in the active cell. To add additional levels of indirect dependents, click the Trace Dependents button again.

Remove All Arrows
Removes all tracer arrows from the worksheet.

Add-Ins
Specifies which add-ins are available automatically when you start Microsoft Excel. You can load or unload add-ins that come with Microsoft Excel as well as add-in programs that you create.

DATA
Sort
Arranges the information in selected rows or lists alphabetically, numerically, or by date.

AutoFilter
The quickest way to select only those items you want to display in a list.

Advanced Filter
Filters data in a list so that only the rows that meet a condition you specify by using a criteria range are displayed.

Form
Displays a data form in a dialog box. You can use the data form to see, change, add, delete, and find records in a list or database.

Subtotals
Calculates subtotal and grand total values for the labeled columns you select. Microsoft Excel automatically inserts and labels the total rows and outlines the list.

Validation
Defines what data is valid for individual cells or cell ranges; restricts the data entry to a particular type, such as whole numbers, decimal numbers, or text; and sets limits on the valid entries.

Table
Creates a data table based on input values and formulas you define. Data tables can be used to show the results of changing values in your formulas.

Convert Text to Columns (Data Menu)
Separates text in one cell on a worksheet into columns by using the Convert Text to Columns Wizard. The Convert Text to Columns Wizard helps you specify how you want the text divided into columns using a separator or delimiter, such as tabs or commas.

Consolidate
Summarizes the data from one or more source areas and displays it in a table.

Group and outline
Group
Defines the selected rows or columns of detail data as a group in an outline, so you can summarize the data. If you have not created an outline, this command creates one for you.
In a PivotTable, this command groups items by category to create a single item from multiple items; for example, you can group days, weeks, months, or other dates into quarters for analysis, charting, or printing.

Ungroup
Removes selected rows or columns from a group on an outlined worksheet.
In a PivotTable, this command separates each instance of a group into the items contained in the group; for example, it separates quarters into the original individual dates.

PivotTable Report
Starts the PivotTable Wizard, which guides you through creating or modifying a PivotTable.

Advertisements

21 thoughts on “MICROSOFT EXCEL

  1. The new Zune browser is surprisingly good, but not as good as the iPod’s. It works well, but isn’t as fast as Safari, and has a clunkier interface. If you occasionally plan on using the web browser that’s not an issue, but if you’re planning to browse the web alot from your PMP then the iPod’s larger screen and better browser may be important.

  2. Wow, incredible blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your web site is excellent, as well as the content!. Thanks For Your article about MICROSOFT EXCEL | SuriSurender .

  3. I like this web site very much, Its a rattling nice situation to read and obtain info. “Art is long, life short judgment difficult, opportunity transient.” by Johann Wolfgang von Goethe.

  4. When I first saw this title MICROSOFT EXCEL SuriSurender on google I just whent and bookmark it. Thank you for sharing superb informations. Your web site is so cool. I’m impressed by the details that you have on this web site. It reveals how nicely you understand this subject. Bookmarked this web page, will come back for extra articles. You, my friend, ROCK! I found just the information I already searched everywhere and simply could not come across. What a perfect web site.

  5. When I first saw this title MICROSOFT EXCEL SuriSurender on google I just whent and bookmark it. Heya just wanted to give you a brief heads up and let you know a few of the pictures aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different browsers and both show the same results.

  6. When I first saw this title MICROSOFT EXCEL SuriSurender on google I just whent and bookmark it. Thank you for sharing superb informations. Your web site is so cool. I’m impressed by the details that you have on this web site. It reveals how nicely you understand this subject. Bookmarked this web page, will come back for extra articles. You, my friend, ROCK! I found just the information I already searched everywhere and simply could not come across. What a perfect web site.

  7. When I first saw this title MICROSOFT EXCEL SuriSurender on google I just whent and bookmark it. With so many product options available, review sites provide valuable perspective in the decision making process. Several brands of table saws are reviewed at Table Saw Reviews Geek.

  8. It’s always excellent when you look over a posting which is not just educational but additionally entertaining. I’ve got to book mark MICROSOFT EXCEL SuriSurender in my laptop or computer. I have been trying to find information regarding this topic for moths and this is the foremost I’ve strategically located. I enjoyed reading your current blog post.

Comment please!!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s