Showing posts with label Tips Microsoft Office 2010. Show all posts
Showing posts with label Tips Microsoft Office 2010. Show all posts

Tricks Open File 2010 in Office 2007 and Microsoft Office 2003

Each version is released is always created and generate a different file. These differences include changes to the file extension, core files and some others. This change also seems a bit membingunkan because sometimes files created in this version can not necessarily be read in the other versions.

For example, we will not be able to read the default file created in Office 2007 and 2010 in the MS Office 2003 or Office XP. You must first restore the file to be compatible with Office 2003 and Office XP. The problem, for those who do not have Office 2007 or 2010 will not be able to do that because Office 2003 does not necessarily able to read the file.

Apparently Microsoft knew about this and therefore Microsoft provides an application that can be used for additional office files 2010 and 2007 can be read using Microsoft Office 2003 and Microsoft Office XP. Application that is named Microsoft Office Compatibility Pack for Word, Excel and Power Point File Format can be found for free on microsoft website. How to use it is also quite simple and will not be difficult for even a novice user.

Tricks Easy Read File Office 2007 and 2010 in Microsoft Office 2003 ImageSetelah the install is complete, you can freely open office files, 2007 and 2010 using office 2003 or office applications XP. No need to re save the file to be compatible with the old program. You can also use it to store files in the format. Xlsx,. Docx and. Pptx like the latest office applications.

Tricks Easy Read File Office 2007 and 2010 in Microsoft Office 2003 compatibility pack ImageMeskipun Micosoft could be a solution to office files 2007 or 2010 could read the old office, the best choice to stick with the road to re-save the file to be compatible with the old office. Or, if you want to better dispose of old office and use the newer, at least Office 2007.

Tricks Easy Read File Office 2007 and 2010 in Microsoft Office 2003 Image

If you want more clearly, can visit the official support website regarding the compatibility pack from microsoft office.

Recognizing Easily Creating Basic Statistics With Microsoft Excel.

Make the processing of research data or administrative data are not always with statistical programs, Microsoft Excel was also able to do so.

A student confusion when given the task of teachers to create statistical data, because its on a laptop or PC there is no statistical program. In his mind, statistical data must be processed with statistical program, such as SPSS, SAS, and other students sebagainya.Yang even funnier is actually surprised to be told that statistical data can be processed by Microsoft Excel program. He thinks that Microsoft Excel only functions that use very limited statistics on the statistics themselves.

Thus the picture of some people about the usefulness of the program Microsoft Excel in the processing of statistical data. Therefore in this paper, FastNCheap will invite you to play with Microsoft Excel 2010 statistics.

Statistics is the science and art or technique for collecting data, presenting data, collect data and draw conclusions based on the data collected.

How to Enable Reference Tools Statistics In Excel 2010.

Microsoft Excel 2010 already provides two facilities for processing statistical data, namely by using statistical functions available, and orders that an analysis of additional commands (add-ins) that can not be displayed on the main menu Microsoft Excel 2010.

Before you can use the command data analysis, the first step that must be done adlah enable reference tools already provided by Microsoft Excel, where the steps are as follows:

1. Turn Microsoft Excel program until there is a blank worksheet.
2. Click the Microsoft Office Excel button located on the left edge of the main window.
3. Click the Options menu located in a collection of vertical menu, ranging from back to exit the menu.
4. An Excel Options dialog box appears, and click the add-ins menu in the window next to Easily Make kiri.Mengenali Elementary Statistics With Microsoft Excel. Image
5. Select and Click Analysis tool pack in the application list of add-ins that are not active.
6. Click the Go button, and an add-ins dialog box is displayed.
7. Give a check mark (see picture) on the check box analysis tool Easily Make pack.Mengenali Elementary Statistics With Microsoft Excel. Image
8. Finally, click the OK button and wait a while until the installation process berakhir.Mengenali Easily Creating Basic Statistics With Microsoft Excel. Image

How to perform a descriptive analysis stastik with Excel can be done with a few steps that anyone can actually do it. Several steps can be taken in the standard analysis process is as follows:

1. From the main menu MS.Excel, click the Data menu (see picture). Recognize Easily Creating Basic Statistics With Microsoft Excel. Image
2. Click the Data Analysis in the group analysis and an analysis of data dialog box appears (see picture).

Statistical analysis to be done is to seek convergence of a cluster size of data processed. Concentration of any size is a measure of the central cluster of data that has been sorted from the smallest to the largest. Concentration of most sizes include:

* Mean.

Mean is the average or median values ​​of the cluster data.

* Median.

The median is the value in the middle of a cluster of data in ascending order.

Modes.

The module is a value that most often arises from a cluster of existing data.

Example:

Calculate the mean, median, mode of data cluster Semester Final Examination score, ie: 95, 75, 70, 80, 75, 68, 80, 78, 97, 85, 64, 100, 70, 67, 90, 68, 65 , 89, and 75.

Answer:

1. Input the data UAS (see picture).
Recognizing Easily Creating Basic Statistics With Microsoft Excel. Image
2. Click on the Data menu MS.Excel Main menu, and click the menu in Data Analysis Group Analysis.
3. In the Analysis Dialog box, select Descriptive Statistics menu, and click the OK button to exit the dialog box.
4. Further Descriptive Statistics dialog box is displayed.
5. Click the button on the Input Range, and enter data into the Input Range field, namely by blocking the data on the sheet (see picture). Recognize Basic Easily Creating Statistics With Microsoft Excel. Image
6. Give a check mark on Labels in First Row if cell contains a label that is inserted before the data.
7. Click Output Range, click on the column output range, and place the pointer in any cell is empty.
8. Give a check mark on the choice of Summary Statistics.
9. Click the OK button.
Recognizing Easily Creating Basic Statistics With Microsoft Excel. Image

Conclusion:

From the calculation is known that the average (mean) is 77, 8, the median value of 75, and the mode is 75.

HISTOGRAM

And the last tutorial is on the histogram.

Must have the bored look at the tutorial extension right? Do not worry, this is the last really.

A little story first, word histogram is derived from the Greek word Histos and Gramma.

Microsoft Excel 2010 provides facilities to create a histogram, namely through the Histogram command in the Data Analysis dialog box.

Example:

Create a histogram from the sale of books per day for a month, which form the data is like-the picture below.

Answer:

1. Click the Data menu, and the group Analysis menu click Data Analysis.
2. In the Analysis dialog box, click Histogram menu.
3. Click the OK button until the Histogram dialog box appears.
4. Enter the book sales data in the Input Range field, and ignore the Bin Range field.
5. Give a check mark in the check box Pareto (Sorted Histogram). Cummulative Percentage and Basis Chart Output.Mengenali Easily Creating Statistics With Microsoft Excel. Image
6. Click the OK button, the process of histogram see figure dibawah.Mengenali Easily Create a Basic Statistics With Microsoft Excel. Image

So first tutorial to play these statistics with Excel.

Right trick to use Microsoft Office 2010

In the development of the cyber world today there is competition among the world's technology giants, Microsoft VS Google. To compete with Google, Microsoft went back to doing new innovations

Microsoft announced the latest offering from Microsoft Office version, this software will be offered in the web version of Microsoft Office 2010 is free. Potential competition between the giant technology company, Google and Microsoft, is also increasing. Google also has made Chrome the operating system to attack Microsoft Windows, now the competition of competition among them increased after Microsoft announced the release web versions of Microsoft Office 2010 for free alias alias gretongan free, Microsoft is a pretty extreme was certainly intended to beat up Google Apps, free software from Google that is widely used by Internet users in the world.

The online version provides software Word, Excel and PowerPoint that can be edited directly via the user's Internet browser.

The web version of Office 2010 defaults on popular browsers including IE, Firefox or Chrome. But Microsoft underscores that although it may be more interesting than Google Apps, a web version of Office 2010 is not complete as desktop version.

System Requirements
Microsoft Office 2010 can be used with either the operating system Microsoft Windows XP and Windows Vista. So to run Office 2010 you must follow the requirements sistematau both the operating system requirements. But if you are still using Windows 2000 operating system or under it should undo your intention to install the Microsoft Office 2010, because you will be disappointed and advanced applications will not be used. As the picture below I show the necessary system specifications Microsoft Office 2010.

Component Requirements
Operating system Microsoft Windows XP Service Pack (SP) 2 or later, Microsoft Windows Vista, Microsoft Windows Server 2003, Windows Server 2008, Windows 7 (or higher) required. Computer and processor 500 megahertz (MHz) processor or higher; 256 megabytes (MB) of RAM or higher; DVD drive, 1 gigahertz (GHz) and 512 MB of RAM or higher is required to run Microsoft Office Outlook 2010 with Business Contact Manager, Hard disk 2 gigabyte (GB) Necessary for install: a portion of this disk space Will be freed after installation if the original download package is removed from the hard drive, Monitor Minimum resolution 800 × 600; 1024 × 768 or higher recommended, Internet connection Broadband connection, 128 kilobits per second (Kbps) or Greater, for download and activation of products, Additional components Microsoft Internet Explorer 6.0 with service packs, Microsoft Exchange Server 2000 or later required for Outlook 2010 users. To install Outlook 2010 with Business Contact Manager, you Will need to first install Outlook 2010

Installation Process
Microsoft Office 2010 installation process very easy, first you have to do is insert a master Microsoft Office 2010 in DVD format, then let the computer work to display the option to perform the installation. The installation process is not difficult, because you will be guided the rest you just press the Next button to continue the installation process. So in this case the installation work is not something that is difficult because it can be done by anyone and requires no special expertise. After the installation is complete, then try to run one of the existing applications, such as Microsoft Word 2010, Microsoft Excel 2010 or Microsoft PowerPoint 2010. After running one of these applications run computer applications that will show the statement to run all the applications in Microsoft Office 2010 family must be activated or registered to situnya Microsoft. Without the activation process applications or programs you can not be used forever as there are time limits for such activation. For that after the installation process is completed as soon as you activate the Microsoft Office 2010. One significant difference is the presence of a more sophisticated Ribbon with a thin menu quite charming. Since Microsoft 2007, has left the menu options, as well as Office 2010. Ribbon in Office 2010 is an advanced facility that is not owned by any application for now. With this user Ribbon menu is no longer bothered with the various menus and sub menus in an application. Ribbon is a new way to classify the menu in the toolbar. With this facility the user is no longer bothered with a variety of text-based menus because the menus are grouped in the toolbar icons in the form of beautiful and sophisticated. Excess Ribbon menu is that each menu can be accessed with one click and no need to go out into the menu to find the necessary facilities. In addition these facilities can be displayed Ribbon or hidden according to taste by pressing or double-clicking anywhere on the menu tab for menyembunyikanya. Similarly to redisplay menus is double click on one menu to redisplay the existing icons. In addition the user can also click on the menu by pressing the CTRL and F1 simultaneously.

for more details you can immediately download a free Microsoft Office 2010 following a video-based tutorials explain how to install and use here the most complete free download center

Recent Post