How to Export A Chart From Microsoft Excel to Microsoft PowerPoint

November 28th, 2011 by

Excel is a powerful yet easy to use spreadsheet program. In many cases, Excel charts can be created to visually display complex information to the users. Excel 2010 has powerful new features to create impressive charts. When you want to present just the Excel chart and not the entire dataset to the audience, then the Microsoft PowerPoint application can be the right choice to do so. While PowerPoint has its own set of features to draw charts, it would be very difficult and time consuming to draw the charts in the PowerPoint slide that are already in the Excel workbook. As such it would be wise decision to export the charts from the Excel program to the PowerPoint program, or you could import the charts from the Excel program into the PowerPoint program. Either way will save you a considerable amount of time and effort.

Copy the Excel chart and paste it into a PowerPoint slide. To do this, follow the instructions below:

• Open the Excel file that contains the Excel chart. Go to the specific sheet and select the chart.

• From the Clipboard group of the Home tab choose Copy and click on it.

- You can also press the CTRL + C keys simultaneously.

• The chart is copied to the clipboard. Now go to the PowerPoint presentation.

• Open the PowerPoint presentation and select the slide where you want to paste the chart.

• From the Clipboard group of the Home tab choose Paste and click on it.

- For the keyboard shortcut press the CTRL + V keys.

- The chart will be pasted onto the PowerPoint slide.

• A small set of Paste Option icons will appear at the bottom of the pasted chart. Different options are there, choose the suitable options that will best suite your purpose.

• To keep the data in the PowerPoint slide the same as the data in the Excel workbook the chart should be linked to the source data. To link the chart in the PowerPoint slide to the Excel workbook select the option “Chart (linked to Excel data)” in the PowerPoint application. To view the chart as a static image, choose the ‘Paste as Picture’ option. To keep the original format, choose the option Keep Source Formatting. You can also choose the Use Destination Theme option to paste and format the chart by using the destination theme.

• To present the chart in a different design, its design can be changed by going to the design tab and clicking on the style form from the chart styles option.

• To view the chart as a motionless image you can use the Picture format and it will show a better quality image than the standard Bitmap format.

You can insert charts from an existing Excel workbook. You need not to recreate the chart in the PowerPoint presentation. You can import it from the Excel worksheet. Steps to do so are as follows -

• Open the PowerPoint presentation and go to the slide where you want to insert the chart.

• After activating the slide, go to the Insert tab and select the Object button from the Text group and click on it.

• For creating a new chart choose the Create New button. As for example for creating a new excel chart choose the MS Office Excel Chart.

• For inserting a chart which is already in an excel worksheet, click on the button Create from file, then click ok.

• Click on the Browse button and navigate to the file where the chart is. Select the file and click ok.

• There is a link box, click it if it is needed to keep a connection to the source file. Then click ok.

• Without pasting the chart one can display it as an icon. To do this, check the Display as icon check box then click ok.

• The icon of an excel workbook will be appeared on the slide. Drag it to the position where you want to set it.

• Resize and position the chart in the source file if necessary.

Among the above two processes, the first one is better. To know more about the procedures you should search the help files which are associated with the Excel program. You may want to speak with an Excel consultant for more specific details. There are many procedures and tips and tricks for different tasks in different versions of Microsoft programs on the internet. Visit the site and click on the program with which your problem is related to, then find out the required topics. This will certainly help you to solve your problem.

SharePoint Information Management Policies

November 28th, 2011 by

An information management policy is a collection of rules that control how organizational information is controlled. With the policies, SharePoint development becomes a comprehensive tool for information management, access controlling, and compliance enforcement. A contains multiple rules, also called as policy features, that govern how to access what information; that can perform what actions, and the time frame the privileges are active. The helps in easier compliance with legal/governmental regulations and internal business processes. Usually the creators and enforcers of policies are compliance officers, records managers, IT staff, and others who are involved in organizational risk management. When applied along with SharePoint WCM development (Web content development), policies enable consistent and risk-free management of data resources.

Benefits of SharePoint policies

* System administrators can manage both client-side and server-side features from a single location
* Policies are coupled to the content that it applies to
* Policies do not require end-user involvement – the corporate policies are followed automatically and universally

Different ways of creating a policy for a site

* Creating a policy for different types of content within a site
* Creating for a given site content type
* Creating for a content library or list

The capability to set control parameters makes it possible to outsource SharePoint development. A brief description of how to create policies follows.

1. Developing a policy for different types of content within a site

Create a policy at the site collection level and then apply it’s to relevant content types as part of SharePoint WCM development – this ensures that the policy is applied to all documents of a certain type within a site collection. These are referred to as site collection policies. To do this

* Click “Site Actions” on the site collection home page
* Click “Site Settings”
* Select “Site Collection Administration” list
* Then select the tab “Site collection policies”
* Click “Create”
* Give a name and describe the policy
* Write a policy statement of up to 512 characters detailing the policy for users
* Click “OK”

2. Development a policy for a given site content type

SharePoint development allows setting a new policy for a given content type. Alternatively, an existing policy can be associated with a content type. Creating policies for content types allows easier coupling of policy features across lists or libraries, especially when you outsource SharePoint development. To do this

* Click “Site Actions” on the homepage of the collection
* Click “Site Settings”
* Click “Site content types” present in the “Galleries” section
* Choose the content type on the “Site Content Type Settings” page
* Select “Information management policy settings” in the “Settings” section of the “Site Content Type” page
* Click on “Define a policy” on the page with “Information Management Policy Settings”
* Give a name and describe the policy in the “Edit Policy” page
* Write a statement of up to 512 characters detailing the policy for users
* Select the relevant policy features to add to the information management policy in the next sections
* Click “Enable Retention” to pinpoint the retention time-frame for different items and documents that this applies to
* Click “Enable Auditing” to enable auditing of events for different items and documents that this applies to
* Click “Enable Labels” to specify label settings for documents and items that this policy applies to

3. Developing a policy for a content library or list

To set to a content library or list, at least the “Manage Lists” permission is necessary in the SharePoint development architecture. Management of rights is essential when you offshore SharePoint development. A retention can be defined for a specific list, library, or folder.

* Navigate to the list or library from where the information management policy has to be set
* Click “Library” or “List” tab
* Click “Library Settings” or “List Settings”
* Click “Information Management Policy Settings” under “Permissions and Management”
* Ensure the source of retention for the list or library is set to “Library and Folders”. If “Content Type” appears as source, change this by clicking “Change Source”
* Enter a description for the policy in the “Library Based Retention Schedule” section of the “Edit Policy” page
* Click “Add a retention stage…” under “Non-Records” to select the retention period option to specify when documents or items are set to expire
* Select “Repeat this stage’s action…” under the “Recurrence” section to enter how often the action should reocc

Tips for Microsoft Access

November 27th, 2011 by

Microsoft Access is a compact but powerful database software package that has been used by most small and mid-sized companies as a part of their IT implementation projects. It is actually a part of the Microsoft Office suite. Similar to the other office products, MS access also has undergone a lot of changes over the last several years and the last full-fledged version to have hit the market is MS Access 2010. It has a number of features that helps customers to manage data effectively and effortlessly.

With the adoption of the web as the standard medium of buying and selling of goods and services, MS access also has adapted to the change and has developed services for making Access a database tables that have been created for simple office applications to be available across the web.

Another important feature that is available in the latest version of MS Access (2010) is to make the old stand-alone access database table into a web ready database table. For this purpose, one has to make use of the compatibility checker that is provided along with the Access package. This checker will not only check for the older objects but will also convert the older database objects in to a web friendly database object. The back-end view of the access database helps the users in customizing the appearance of the MS access user interface. With this option, users can hide the ribbons and toolbars and also the navigation pane.

Another excellent utility available in the latest version of MS Access is the ability to share the reports generated in MS Access in other formats. This export utility makes it possible for the user to export the report in to other forms such as Excel, PDF and HTML In this way the report can be shared with other users who don’t have Access on their system.

In the latest version of Microsoft Access, it is very easy to share images across multiple forms and reports. The user has to add the image to the common image gallery and then call that image in to the required form or report. Smart tags can also be added to the database forms created in MS Access. This will simplify the process of providing additional look up information. Previously a separate web form had to be created for displaying such additional information. Now with the availability of smart tags, there is no need to create a separate form.