1...CHART:-
In Microsoft Excel, you can represent numbers in a chart.
On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter.
The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data,
your chart will automatically update.
You select a chart type by choosing an option from the Insert tab's Chart group.
After you choose a chart type, such as column, line, or bar,
you choose a chart sub-type. For example, after you choose Column Chart, you can choose to have your
chart represented as a two-dimensional chart, a three-dimensional chart, a cylinder chart, a cone chart, or a pyramid chart.
There are further sub-types within each of these categories.
As you roll your mouse pointer over each option, Excel supplies a brief description of each chart sub-type.
To create the column chart start by creating the workshee
After you have created the worksheet, you are ready to create your chart.
1.Select cells . You must select all the cells containing the data you want in your chart.
You should also include the data labels.
2.Choose the Insert tab.
3.Click the Column button in the Charts group. A list of column chart sub-types types appears.
4.Click the Clustered Column chart sub-type. Excel creates a Clustered Column chart and the Chart Tools context tabs appear.
2. CLIP ART:-
Data sources you can use for a mail merge
You can use just about any type of data source (data source: A file that contains the information to be merged into a document. For example, the list of names and addresses you want to use in a mail merge. You must connect to the data source before you can use the information in it.) for a mail merge.
Here are examples of data sources.
Microsoft Outlook Contact List
You can retrieve contact information directly from your Outlook Contact List.
Microsoft Office Address List
You can create a simple Office Address List during the mail merge, and access it for later use. This is best for small, simple lists that you don't use frequently.
Microsoft Excel worksheet or Microsoft Access database
With Excel, you can select data from any worksheet or named range within a workbook. With Access, you can select data from any table or query (query: A means of finding all the records stored in a data source that fit a set of criteria you name. Queries can contain operators, quotation marks, wildcard characters, and parentheses to help focus your search.) defined in the database.
Other database files
You can use:
A data source you connect to by using the Data Connection Wizard.Files from single-tier, file-based database programs for which you have installed an OLE-DB provider (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) or ODBC (Open Database Connectivity (ODBC): A standard method of sharing data between databases and programs. ODBC drivers use the standard Structured Query Language (SQL) to gain access to external data.) driver (a number of which are included with Microsoft Office).You can access these sources or start the Data Connection Wizard by clicking New Source in the Select Data Source dialog box.
HTML file
You can use an HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) file that has a single table. The first row of the table must contain column names and the other rows must contain data.
Different type of electronic address book
You can use the following types of address books:
A Microsoft Outlook Address Book.A Microsoft Schedule+ 7.0 Contact List.The Personal Address Book that you created for use with Microsoft Exchange Server.Any similar address lists that were created with a MAPI (MAPI: The Microsoft interface specification that allows different messaging and workgroup applications (including e-mail, voice mail, and fax) to work through a single client.)-compatible messaging system, such as Microsoft Outlook.
Microsoft Word data source or a header source
You can use a Word document as a data source. The document should contain a single table. The first row of the table must contain headings, and the other rows must contain the records you want to merge. You can also use a header source (header source: A document that contains the header row (or header record) to be used with the data source specified for a mail-merge main document.) as a data source.
4. FILTER:-
The criteria definitions for filtering numbers for the Excel advanced filter are straightforward,
in that the standard mathematical operators (eg. "=", "<", "<>") are used. However,
the rules for applying the advanced filter to text values are less obvious.
=text" Select cells whose contents are exactly equal to the string "text
the * symbolises any number of characters
the < symbolises any standard mathematical operators
the ? symbolises any single character
the = symbolises any standard mathematical operators
5. FLOW DOCUMENT:-
Flow documents are designed to optimize viewing and readability.
Rather than being set to one predefined layout, flow documents dynamically adjust and reflow their
content based on run-time variables such as window size, device resolution, and optional user preferences.
In addition, flow documents offer advanced document features,
such as pagination and columns. This topic provides an overview of flow documents and how to create them.
creating folow
1.Flow-related Classes: Each class used in flow content has a specific purpose.
In addition, the hierarchical relation between flow classes helps you understand how they are used.
For example, classes derived from the Block class are used to contain other objects while
classes derived from Inline contain objects that are displayed.
2.Content Schema: A flow document can require a substantial number of nested elements.
The content schema specifies possible parent/child relationships between elements.
Using the RTF Editor, you can partition your text into separate sections, present the text in a section in columnar format,
and force page and column breaks to position text as you want. A multiple section document is useful to:
• Change the presentation and format of the text for different areas of information
• Change between portrait and landscape orientation for different parts of the document
• Vary the page margins from one page to another
6. FLOWCHART:-
flowchart intro
Flowcharts are excellent for presentations and organizing ideas.
how to creat
1.Start with a blank Word document. Place your title at the top.
clic Insert and select a shape from the Shapes menu under Illustrations.
2.You then use the plus-shaped cursor to position and choose the size of the shape.
3.You can create a new shape to link the arrow to or you can copy the shape you started with.
4.All you have to do is select shapes, size and position them, copy them if needed and link them together.
5. Right click a given box and select Add Text then start typing. Adjust the font if necessary.
6.Click on the shape in the flowchart and then select a color from the Format color chart,
7.Shadow and 3D effects can be added. From the Format tab on the Ribbon, find the 3D effects and click on
a shape then click on “3D effects” and select effects from the dropdown menu.
click on the color and the shape takes on that color.
8. then save your document by clickink save in file tab.
9.There is much more that you can do.
7. JAMES:-
A hierarchical list can be displayed in a hierarchical list form object or a hierarchical list Pop-up Menu form object.
1.Hierarchical List Hierarchical List Pop-up Menu
2.List Editor displaying a hierarchical list being Edited
3.Creating a hierarchical list object on a form called hlList2
4.Defining what hierarchical list to load during the On Load form event.
5.Getting the Text the User Clicked On
various style list:::::
list-style-type Specifies the type of list-item marker. See list-style-type for possible values
list-style-position Specifies where to place the list-item marker. See list-style-position for possible values
list-style-image Specifies the type of list-item marker. See list-style-image for possible values
inherit Specifies that the value of the list-style property should be inherited from the parent element
8. MACRO SECURITY:-
A macro is a series of commands that is recorded and assigned a keystroke so that it can
be played back at a later time. A macro can be used to format documents, enter text, and/or
execute vba code. Because of its ability to execute commands,
it is important to ensure that a macro comes from a trusted source.
It is a fact that, while most macros are both harmless and helpful, macros are an important security issue.
When created with malicious intentions, macros can contain destructive code that causes harm to your documents
or your system.
it contain ::
viruses
worms
trozans
bots.
To protect your system and your files, do not enable macros from unknown sources.
In order to have the option to enable or disable macros, set
macro security in your Office programs to Medium.
To set macro security in any Office program that offers VBA macros,
on the Tools menu click Macro, and then click Security. Select your preferred Security
Level and then click OK. Note that setting security to Low is not recommended.
In Microsoft Office 2003 or later, a component checks all XML files that have references to XSL files for script that could be unsafe. If macro security is set to High, running this script is disabled. If macro security is set to Medium, the user is asked whether or not to run script in XSL files. If macro security is set to Low, the script is run.
Very High
High
Medium
Low
9. MACRO:-
A macro is a set of computer instructions that you can record and associate with a shortcut key
combination or a macro name. Then, when you press the shortcut key combination or click the macro name,
your computer program carries out the instructions of the macro. This saves you time by replacing an often-used,
sometimes lengthy series of actions with a shorter action. For example, instead of clicking several menus and buttons
to add text to your business documents in Microsoft Word,
you can record those steps in a macro and then just click the macro to add the text in one step.
In the View tab, choose Macros?Record Macro.
Give the macro a name in the Record Macro dialog box.
Type a keyboard shortcut combination.
Click the Close button.
to stop recording, choose Macros?Stop Recording.
Documents, templates, worksheets, and presentations that you create in the 2010 Office
release are saved with new file-name extensions with an x or an m. For example, when you save a document in Word,
the file now uses the .docx extension, instead of the .doc extension.
The x signifies an XML file with no macros.
The m signifies an XML file that does contain macros.
Macro-enabled document .docm
10. MAIL MERGE 2:-
About mail-merge data sources
Show All
You use a mail merge when you want to create a large number of documents that are mostly identical but include some unique information. For example, you can use a mail merge to create a product announcement that you are sending to your top 1,000 customers. The text of the letter is always the same, but the name and address are different for each customer.
These customer names and addresses are stored in a data source, which is a file that contains the unique information that you want to include. The data file can be in a variety of formats, including:
Microsoft Office Outlook Contacts lists.
Microsoft Office Excel 2003 worksheets.
Microsoft Office Word 2003 tables.
Microsoft Office Access 2003 database tables.
Text files in which tabs or commas separate the columns, and paragraph returns separate the rows.
In a data file, information is organized into columns and rows. Each column represents a category, such as first name, last name, company, or street address. Each row, except for the first row, represents one complete record or set of data. The first row is special. Called the Header row, it contains the column names.
11. PIVOT TABLE REPORT:-
an interactive table that automatically extracts, organizes, and summarizes your data.
You can use this report to analyze the data, make comparisons,
detect patterns and relationships, and discover trends.
A pivot table report shows the summary of aggregated data,
and enables you to quickly investigate the source of the summarized data....
If you are basing the report on an Excel list or database, click a cell in the list or database.
On the Data menu, click PivotTable and PivotChart Report.
In step 1 of the PivotTable and PivotChart Wizard, follow the instructions, and click PivotTable under What kind of report do you want to create?
Follow the instructions in step 2 of the wizard.
Follow the instructions in step 3 of the wizard, and then decide whether to lay out the report onscreen or in the wizard.
Usually you can lay out the report onscreen, and this method is recommended. Use the wizard to lay out
the report only if you expect retrieval from a large external data source to be slow, or you need to set page
fields to retrieve data one page at a time.
If you aren't sure, try laying out the report onscreen. You can return to the wizard if necessary.
12. PIVOT TABLE :-
In data processing, a pivot table is a data summarization tool found in data
visualization programs such as spreadsheets or business intelligence software. Among other functions,
a pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet.
It displays the results in a second table (called a "pivot table") showing the summarized data.
Pivot tables are also useful for quickly creating unweighted cross tabulations.
You need a database before being able to create an use a pivot table.
It's possible to create and manage simple databases from Excel.
There are certain terms that you should know before starting.
Field Characteristic of a person, a thing or an event that you want to keep in a database.
Each column represents a field.
Record Series of fields that describe a person, a thing or an event. Each row represents a record.
1.Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
2.Click Analyze > Insert Slicer.
3.In the Insert Slicers dialog box, check the boxes of the fields you want to create slicers for.
4.Click OK.
A slicer appears for each field you checked in the Insert Slicers dialog box.
5.In each slicer, click the items you want to show in the PivotTable.
To choose more than one item, hold down Ctrl, and then pick the items you want to show.
13. SCREEN SHORT:-
You can quickly and easily add a screenshot to your Office file to enhance the readability or
capture information without leaving the program that you are working in. This feature is available in Microsoft Excel,
Outlook, PowerPoint, and Word. You can use it to
take a picture of all or part of the windows open on your computer.
Screenshots are useful for capturing snapshots of information that might change or expire,
such as a breaking news story or a time-sensitive
list of available flights and rates on a travel Web site.
1.Click the worksheet that you want to add the screenshot to.
2.On the Insert tab, in the Illustrations group, click Screenshot.
3.To add the whole window, click the thumbnail in the Available Windows gallery.
To add part of the window, click Screen Clipping,
If you have multiple windows open, click the window you want to clip from before clicking Screen Clipping.
When you click Screen Clipping, the program you are working in is minimized and only
the window behind it is available for clipping.
After you add the screenshot, you can use the tools on the Picture Tools tab to edit and enhance the screenshot.
14. SHAPES:-
introduction?????
You can add one shape to your file or combine multiple shapes to make a drawing or a more complex shape. Available shapes include lines, basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and callouts.
After you add one or more shapes, you can add text, bullets, numbering, and Quick Styles to them.
1.On the Insert tab, in the Illustrations group, click Shapes.
2.Click the shape that you want, click anywhere in the workbook, and then drag to place the shape.
To create a perfect square or circle (or constrain the dimensions of other shapes), press and hold SHIFT while you drag.
how to modyfy shaps???
1.Click the shape that you want to change to a different shape.
To change multiple shapes, press CTRL while you click the shapes that you want to change.
2.Under Drawing Tools, on the Format tab, in the Insert Shapes group, click Edit Shape , point to Change Shape, and then click the new shape that you want.
How to Insert Shapes in an Excel 2010 Worksheet????
By Greg Harvey from Excel 2010 For Dummies
You can insert graphic shapes such as lines, rectangles, block arrows, stars, and other basic shapes in your Excel 2010 charts and worksheets. All you need to do is select a thumbnail on the Shapes drop-down gallery on the Insert tab of the Ribbon and draw the shape in the worksheet.
On the Insert tab, click the Shapes button in the Illustrations group.
The Shapes gallery appears, revealing nine categories of shapes, including Recently Used Shapes at the top.
Click a shape thumbnail to select it.
The Shapes gallery disappears and the mouse pointer changes to a crosshair.
Click and drag the mouse in the worksheet to create the shape in the desired size.
Drag the object until it's approximately the size you want (you can fine-tune the size later).
Release the mouse button.
The shape appears in the worksheet.
After you release the mouse button, the shape you've drawn in the worksheet is still selected. This is indicated by the selection handles around its perimeter and the rotation handle at the top, which you can use to reposition and resize the shape, as needed. In addition, Excel displays the Drawing Tools Format tab, and you can use the Shape Styles gallery or other command buttons to further format the shape until it's exactly the way you want it. Click anywhere outside the shape to deselect it.
15. SMART ART:-
what is smart art graphis????
SmartArt allows you to visually communicate information rather than simply using text.
Illustrations can really enhance your document, and SmartArt makes using graphics especially easy.
In this lesson, you will learn how to insert a SmartArt graphic, modify the color and effects,
and change the organization of the graphic.
how to creat???
Most content that is created by using 2007 Microsoft Office system programs is textual,
even though the use of illustrations improves understanding and memory and encourages action.
Creating designer-quality illustrations can be challenging, especially if you are not a professional
designer or you cannot afford to hire a professional designer. If you use earlier versions of Microsoft Office,
you can spend a lot of time getting shapes to be the same size and to be aligned properly, getting your text to look right,
and manually formatting the shapes to match the document's overall style, instead of focusing on your content.
With the new 2007 Office release feature called SmartArt graphics, and other new features such as themes,
you can create designer-quality illustrations with only a few clicks of your mouse.
16. WORD CHART:-
chart is a::
1.a sheet exhibiting information in tabular form.
2.
a graphic representation, as by curves, of a dependent variable, as temperature, price, etc.; graph.
3.
a map, especially a hydrographic or marine map.
4.
an outline map showing special conditions or facts: a weather chart.
5.
Astrology , horoscope ( def 1 ) .
how to creat it in word.
Follow these steps to create a chart, such as a bar chart or a pie chart.
On the Insert menu, click Object, and then click the Create New tab.
In the Object type box, click Microsoft Graph Chart, and then click OK.
Microsoft Graph displays a chart and its associated sample data in a table called a datasheet.
To replace the sample data, click a cell on the datasheet, and then type the new text or numbers. If needed, you can import data from a text file, a Lotus 1-2-3 file, or a Microsoft Excel worksheet. You can also copy data from another program.
To return to Microsoft Word, click the Word document.
17. WORKSHEET:-
Although moving or copying the actual worksheet is a fast and effective way to transfer data to another location,
you can also move or copy all or part of the data in a worksheet to another worksheet. This method can be used to transfer data to a worksheet
in a workbook that is open in a separate instance of Excel.
1.In a worksheet, select the data that you want to move or copy.
2.On the Home tab, in the Clipboard group,
3.On the Home tab, in the Clipboard group,
4.Select the upper-left cell of the paste area.
5.On the Home tab, in the Clipboard group, click Paste
18. FUNCTION:-
introduction::::
The syntax of an Excel function refers to the layout and order of the function and its arguments.
All functions in Excel begin with the equal sign (= ) followed by the function's name - such as SUM, COUNT, or ROUND.
A function's arguments refer to all the data or information required by a function.
These arguments must be entered in the correct order.
The syntax of the IF function is:
=IF(logic test, value if true, value if false)
CHOOSE function
This article describes the formula syntax and usage of the CHOOSE function in Microsoft Excel.
Description
Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up
to 254 values based on the index number. For example, if value1 through value7 are the days of the week,
CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.
In Microsoft Excel, you can represent numbers in a chart.
On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter.
The basic procedure for creating a chart is the same no matter what type of chart you choose. As you change your data,
your chart will automatically update.
You select a chart type by choosing an option from the Insert tab's Chart group.
After you choose a chart type, such as column, line, or bar,
you choose a chart sub-type. For example, after you choose Column Chart, you can choose to have your
chart represented as a two-dimensional chart, a three-dimensional chart, a cylinder chart, a cone chart, or a pyramid chart.
There are further sub-types within each of these categories.
As you roll your mouse pointer over each option, Excel supplies a brief description of each chart sub-type.
To create the column chart start by creating the workshee
After you have created the worksheet, you are ready to create your chart.
1.Select cells . You must select all the cells containing the data you want in your chart.
You should also include the data labels.
2.Choose the Insert tab.
3.Click the Column button in the Charts group. A list of column chart sub-types types appears.
4.Click the Clustered Column chart sub-type. Excel creates a Clustered Column chart and the Chart Tools context tabs appear.
2. CLIP ART:-
On the Insert tab, in the Illustrations group, click Clip Art.
Illustrations group Ribbon
In the Clip Art task pane, in the Search for text box, type a word or phrase that describes the clip art that you want, or type all or some of the file name of the clip art.
To narrow your search, do one or both of the following:
To limit the search results to a specific collection of clip art, in the Search in list, select the check box next to each collection that you want to search.
For more information about collections, see About Clip Organizer collections.
To limit the search results to clip art, in the Results should be list, select the Clip Art check box. You can also select the check boxes next to Photographs, Movies, and Sounds to search those media types.
Click Go.
In the list of results, click the clip art to insert it.
3. DATA SOURCE FILES FOR MAIL MERGE:-
Data sources you can use for a mail merge
You can use just about any type of data source (data source: A file that contains the information to be merged into a document. For example, the list of names and addresses you want to use in a mail merge. You must connect to the data source before you can use the information in it.) for a mail merge.
Here are examples of data sources.
Microsoft Outlook Contact List
You can retrieve contact information directly from your Outlook Contact List.
Microsoft Office Address List
You can create a simple Office Address List during the mail merge, and access it for later use. This is best for small, simple lists that you don't use frequently.
Microsoft Excel worksheet or Microsoft Access database
With Excel, you can select data from any worksheet or named range within a workbook. With Access, you can select data from any table or query (query: A means of finding all the records stored in a data source that fit a set of criteria you name. Queries can contain operators, quotation marks, wildcard characters, and parentheses to help focus your search.) defined in the database.
Other database files
You can use:
A data source you connect to by using the Data Connection Wizard.Files from single-tier, file-based database programs for which you have installed an OLE-DB provider (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) or ODBC (Open Database Connectivity (ODBC): A standard method of sharing data between databases and programs. ODBC drivers use the standard Structured Query Language (SQL) to gain access to external data.) driver (a number of which are included with Microsoft Office).You can access these sources or start the Data Connection Wizard by clicking New Source in the Select Data Source dialog box.
HTML file
You can use an HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) file that has a single table. The first row of the table must contain column names and the other rows must contain data.
Different type of electronic address book
You can use the following types of address books:
A Microsoft Outlook Address Book.A Microsoft Schedule+ 7.0 Contact List.The Personal Address Book that you created for use with Microsoft Exchange Server.Any similar address lists that were created with a MAPI (MAPI: The Microsoft interface specification that allows different messaging and workgroup applications (including e-mail, voice mail, and fax) to work through a single client.)-compatible messaging system, such as Microsoft Outlook.
Microsoft Word data source or a header source
You can use a Word document as a data source. The document should contain a single table. The first row of the table must contain headings, and the other rows must contain the records you want to merge. You can also use a header source (header source: A document that contains the header row (or header record) to be used with the data source specified for a mail-merge main document.) as a data source.
4. FILTER:-
The criteria definitions for filtering numbers for the Excel advanced filter are straightforward,
in that the standard mathematical operators (eg. "=", "<", "<>") are used. However,
the rules for applying the advanced filter to text values are less obvious.
=text" Select cells whose contents are exactly equal to the string "text
the * symbolises any number of characters
the < symbolises any standard mathematical operators
the ? symbolises any single character
the = symbolises any standard mathematical operators
5. FLOW DOCUMENT:-
Flow documents are designed to optimize viewing and readability.
Rather than being set to one predefined layout, flow documents dynamically adjust and reflow their
content based on run-time variables such as window size, device resolution, and optional user preferences.
In addition, flow documents offer advanced document features,
such as pagination and columns. This topic provides an overview of flow documents and how to create them.
creating folow
1.Flow-related Classes: Each class used in flow content has a specific purpose.
In addition, the hierarchical relation between flow classes helps you understand how they are used.
For example, classes derived from the Block class are used to contain other objects while
classes derived from Inline contain objects that are displayed.
2.Content Schema: A flow document can require a substantial number of nested elements.
The content schema specifies possible parent/child relationships between elements.
Using the RTF Editor, you can partition your text into separate sections, present the text in a section in columnar format,
and force page and column breaks to position text as you want. A multiple section document is useful to:
• Change the presentation and format of the text for different areas of information
• Change between portrait and landscape orientation for different parts of the document
• Vary the page margins from one page to another
6. FLOWCHART:-
flowchart intro
Flowcharts are excellent for presentations and organizing ideas.
how to creat
1.Start with a blank Word document. Place your title at the top.
clic Insert and select a shape from the Shapes menu under Illustrations.
2.You then use the plus-shaped cursor to position and choose the size of the shape.
3.You can create a new shape to link the arrow to or you can copy the shape you started with.
4.All you have to do is select shapes, size and position them, copy them if needed and link them together.
5. Right click a given box and select Add Text then start typing. Adjust the font if necessary.
6.Click on the shape in the flowchart and then select a color from the Format color chart,
7.Shadow and 3D effects can be added. From the Format tab on the Ribbon, find the 3D effects and click on
a shape then click on “3D effects” and select effects from the dropdown menu.
click on the color and the shape takes on that color.
8. then save your document by clickink save in file tab.
9.There is much more that you can do.
7. JAMES:-
A hierarchical list can be displayed in a hierarchical list form object or a hierarchical list Pop-up Menu form object.
1.Hierarchical List Hierarchical List Pop-up Menu
2.List Editor displaying a hierarchical list being Edited
3.Creating a hierarchical list object on a form called hlList2
4.Defining what hierarchical list to load during the On Load form event.
5.Getting the Text the User Clicked On
various style list:::::
list-style-type Specifies the type of list-item marker. See list-style-type for possible values
list-style-position Specifies where to place the list-item marker. See list-style-position for possible values
list-style-image Specifies the type of list-item marker. See list-style-image for possible values
inherit Specifies that the value of the list-style property should be inherited from the parent element
8. MACRO SECURITY:-
A macro is a series of commands that is recorded and assigned a keystroke so that it can
be played back at a later time. A macro can be used to format documents, enter text, and/or
execute vba code. Because of its ability to execute commands,
it is important to ensure that a macro comes from a trusted source.
It is a fact that, while most macros are both harmless and helpful, macros are an important security issue.
When created with malicious intentions, macros can contain destructive code that causes harm to your documents
or your system.
it contain ::
viruses
worms
trozans
bots.
To protect your system and your files, do not enable macros from unknown sources.
In order to have the option to enable or disable macros, set
macro security in your Office programs to Medium.
To set macro security in any Office program that offers VBA macros,
on the Tools menu click Macro, and then click Security. Select your preferred Security
Level and then click OK. Note that setting security to Low is not recommended.
In Microsoft Office 2003 or later, a component checks all XML files that have references to XSL files for script that could be unsafe. If macro security is set to High, running this script is disabled. If macro security is set to Medium, the user is asked whether or not to run script in XSL files. If macro security is set to Low, the script is run.
Very High
High
Medium
Low
9. MACRO:-
A macro is a set of computer instructions that you can record and associate with a shortcut key
combination or a macro name. Then, when you press the shortcut key combination or click the macro name,
your computer program carries out the instructions of the macro. This saves you time by replacing an often-used,
sometimes lengthy series of actions with a shorter action. For example, instead of clicking several menus and buttons
to add text to your business documents in Microsoft Word,
you can record those steps in a macro and then just click the macro to add the text in one step.
In the View tab, choose Macros?Record Macro.
Give the macro a name in the Record Macro dialog box.
Type a keyboard shortcut combination.
Click the Close button.
to stop recording, choose Macros?Stop Recording.
Documents, templates, worksheets, and presentations that you create in the 2010 Office
release are saved with new file-name extensions with an x or an m. For example, when you save a document in Word,
the file now uses the .docx extension, instead of the .doc extension.
The x signifies an XML file with no macros.
The m signifies an XML file that does contain macros.
Macro-enabled document .docm
10. MAIL MERGE 2:-
About mail-merge data sources
Show All
You use a mail merge when you want to create a large number of documents that are mostly identical but include some unique information. For example, you can use a mail merge to create a product announcement that you are sending to your top 1,000 customers. The text of the letter is always the same, but the name and address are different for each customer.
These customer names and addresses are stored in a data source, which is a file that contains the unique information that you want to include. The data file can be in a variety of formats, including:
Microsoft Office Outlook Contacts lists.
Microsoft Office Excel 2003 worksheets.
Microsoft Office Word 2003 tables.
Microsoft Office Access 2003 database tables.
Text files in which tabs or commas separate the columns, and paragraph returns separate the rows.
In a data file, information is organized into columns and rows. Each column represents a category, such as first name, last name, company, or street address. Each row, except for the first row, represents one complete record or set of data. The first row is special. Called the Header row, it contains the column names.
11. PIVOT TABLE REPORT:-
an interactive table that automatically extracts, organizes, and summarizes your data.
You can use this report to analyze the data, make comparisons,
detect patterns and relationships, and discover trends.
A pivot table report shows the summary of aggregated data,
and enables you to quickly investigate the source of the summarized data....
If you are basing the report on an Excel list or database, click a cell in the list or database.
On the Data menu, click PivotTable and PivotChart Report.
In step 1 of the PivotTable and PivotChart Wizard, follow the instructions, and click PivotTable under What kind of report do you want to create?
Follow the instructions in step 2 of the wizard.
Follow the instructions in step 3 of the wizard, and then decide whether to lay out the report onscreen or in the wizard.
Usually you can lay out the report onscreen, and this method is recommended. Use the wizard to lay out
the report only if you expect retrieval from a large external data source to be slow, or you need to set page
fields to retrieve data one page at a time.
If you aren't sure, try laying out the report onscreen. You can return to the wizard if necessary.
12. PIVOT TABLE :-
In data processing, a pivot table is a data summarization tool found in data
visualization programs such as spreadsheets or business intelligence software. Among other functions,
a pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet.
It displays the results in a second table (called a "pivot table") showing the summarized data.
Pivot tables are also useful for quickly creating unweighted cross tabulations.
You need a database before being able to create an use a pivot table.
It's possible to create and manage simple databases from Excel.
There are certain terms that you should know before starting.
Field Characteristic of a person, a thing or an event that you want to keep in a database.
Each column represents a field.
Record Series of fields that describe a person, a thing or an event. Each row represents a record.
1.Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
2.Click Analyze > Insert Slicer.
3.In the Insert Slicers dialog box, check the boxes of the fields you want to create slicers for.
4.Click OK.
A slicer appears for each field you checked in the Insert Slicers dialog box.
5.In each slicer, click the items you want to show in the PivotTable.
To choose more than one item, hold down Ctrl, and then pick the items you want to show.
13. SCREEN SHORT:-
You can quickly and easily add a screenshot to your Office file to enhance the readability or
capture information without leaving the program that you are working in. This feature is available in Microsoft Excel,
Outlook, PowerPoint, and Word. You can use it to
take a picture of all or part of the windows open on your computer.
Screenshots are useful for capturing snapshots of information that might change or expire,
such as a breaking news story or a time-sensitive
list of available flights and rates on a travel Web site.
1.Click the worksheet that you want to add the screenshot to.
2.On the Insert tab, in the Illustrations group, click Screenshot.
3.To add the whole window, click the thumbnail in the Available Windows gallery.
To add part of the window, click Screen Clipping,
If you have multiple windows open, click the window you want to clip from before clicking Screen Clipping.
When you click Screen Clipping, the program you are working in is minimized and only
the window behind it is available for clipping.
After you add the screenshot, you can use the tools on the Picture Tools tab to edit and enhance the screenshot.
14. SHAPES:-
introduction?????
You can add one shape to your file or combine multiple shapes to make a drawing or a more complex shape. Available shapes include lines, basic geometric shapes, arrows, equation shapes, flowchart shapes, stars, banners, and callouts.
After you add one or more shapes, you can add text, bullets, numbering, and Quick Styles to them.
1.On the Insert tab, in the Illustrations group, click Shapes.
2.Click the shape that you want, click anywhere in the workbook, and then drag to place the shape.
To create a perfect square or circle (or constrain the dimensions of other shapes), press and hold SHIFT while you drag.
how to modyfy shaps???
1.Click the shape that you want to change to a different shape.
To change multiple shapes, press CTRL while you click the shapes that you want to change.
2.Under Drawing Tools, on the Format tab, in the Insert Shapes group, click Edit Shape , point to Change Shape, and then click the new shape that you want.
How to Insert Shapes in an Excel 2010 Worksheet????
By Greg Harvey from Excel 2010 For Dummies
You can insert graphic shapes such as lines, rectangles, block arrows, stars, and other basic shapes in your Excel 2010 charts and worksheets. All you need to do is select a thumbnail on the Shapes drop-down gallery on the Insert tab of the Ribbon and draw the shape in the worksheet.
On the Insert tab, click the Shapes button in the Illustrations group.
The Shapes gallery appears, revealing nine categories of shapes, including Recently Used Shapes at the top.
Click a shape thumbnail to select it.
The Shapes gallery disappears and the mouse pointer changes to a crosshair.
Click and drag the mouse in the worksheet to create the shape in the desired size.
Drag the object until it's approximately the size you want (you can fine-tune the size later).
Release the mouse button.
The shape appears in the worksheet.
After you release the mouse button, the shape you've drawn in the worksheet is still selected. This is indicated by the selection handles around its perimeter and the rotation handle at the top, which you can use to reposition and resize the shape, as needed. In addition, Excel displays the Drawing Tools Format tab, and you can use the Shape Styles gallery or other command buttons to further format the shape until it's exactly the way you want it. Click anywhere outside the shape to deselect it.
what is smart art graphis????
SmartArt allows you to visually communicate information rather than simply using text.
Illustrations can really enhance your document, and SmartArt makes using graphics especially easy.
In this lesson, you will learn how to insert a SmartArt graphic, modify the color and effects,
and change the organization of the graphic.
how to creat???
Most content that is created by using 2007 Microsoft Office system programs is textual,
even though the use of illustrations improves understanding and memory and encourages action.
Creating designer-quality illustrations can be challenging, especially if you are not a professional
designer or you cannot afford to hire a professional designer. If you use earlier versions of Microsoft Office,
you can spend a lot of time getting shapes to be the same size and to be aligned properly, getting your text to look right,
and manually formatting the shapes to match the document's overall style, instead of focusing on your content.
With the new 2007 Office release feature called SmartArt graphics, and other new features such as themes,
you can create designer-quality illustrations with only a few clicks of your mouse.
chart is a::
1.a sheet exhibiting information in tabular form.
2.
a graphic representation, as by curves, of a dependent variable, as temperature, price, etc.; graph.
3.
a map, especially a hydrographic or marine map.
4.
an outline map showing special conditions or facts: a weather chart.
5.
Astrology , horoscope ( def 1 ) .
how to creat it in word.
Follow these steps to create a chart, such as a bar chart or a pie chart.
On the Insert menu, click Object, and then click the Create New tab.
In the Object type box, click Microsoft Graph Chart, and then click OK.
Microsoft Graph displays a chart and its associated sample data in a table called a datasheet.
To replace the sample data, click a cell on the datasheet, and then type the new text or numbers. If needed, you can import data from a text file, a Lotus 1-2-3 file, or a Microsoft Excel worksheet. You can also copy data from another program.
To return to Microsoft Word, click the Word document.
17. WORKSHEET:-
Although moving or copying the actual worksheet is a fast and effective way to transfer data to another location,
you can also move or copy all or part of the data in a worksheet to another worksheet. This method can be used to transfer data to a worksheet
in a workbook that is open in a separate instance of Excel.
1.In a worksheet, select the data that you want to move or copy.
2.On the Home tab, in the Clipboard group,
3.On the Home tab, in the Clipboard group,
4.Select the upper-left cell of the paste area.
5.On the Home tab, in the Clipboard group, click Paste
18. FUNCTION:-
introduction::::
The syntax of an Excel function refers to the layout and order of the function and its arguments.
All functions in Excel begin with the equal sign (= ) followed by the function's name - such as SUM, COUNT, or ROUND.
A function's arguments refer to all the data or information required by a function.
These arguments must be entered in the correct order.
The syntax of the IF function is:
=IF(logic test, value if true, value if false)
CHOOSE function
This article describes the formula syntax and usage of the CHOOSE function in Microsoft Excel.
Description
Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up
to 254 values based on the index number. For example, if value1 through value7 are the days of the week,
CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.
No comments:
Post a Comment