How to Easily Make Presentation Data with Microsoft Office Excel

Maxz Pro, How to Easily Make Presentation Data with Microsoft Office Excel,- Represent data in the form of charts sometimes can only be done by a few people. Not just a matter of ignorance, the problem was the difficulty in studying it is also another reason. However, the difficulty may be slightly reduced with Microsoft Office applications developed by Microsoft. The reason is certainly the ease of layout you can represent data accurately and professionally. In this article, the author tries to share how to use Microsoft Excel as a medium to deliver the data belongs to you. To do this tutorial you should have some programs or add-ins required:

Microsoft Excel is already installed, you can use 2010 or 2013.  Add-ins in Microsoft Excel that is not included and you has to download it first. Among others:

Power Query, used to retrieve the data. You can download for Microsoft Office on the Microsoft website; these files can be used either for Office 2013 or 2010. Installation you can do by clicking 2 times on the downloaded file, then just follow the step by step in the application. Once installed you need to restart the Microsoft Excel yours.

Power Pivot, is used to perform data modeling yours. When you install the Power Query, Power Pivot has actually included in them. However, you should do a bit of configuration to enable it to be used in Microsoft Excel. To activate it, go to the options. You can access it via the menu File - Options, and then select the menu add-ins.

Some add-ins that are installed in Microsoft Excel will be displayed in this menu, access the menu "Manage" select COM Add-ins. You just do a check on Microsoft Power Map, and a new tab will appear when you restart Microsoft Excel.

Power View and Power Map, used to display the results of your data in the form of graphs simultaneously spreading. As with Power query, you need to install the Add-ins in Microsoft Excel yours. You can download the add INS are on the Microsoft website. Step by step you will easily come when the installation of the add-ins. When it is installed, on the Insert tab you will find a new menu that is Power View and Power Map.

When the whole Add INS need has been installed, the next step is to collect data to display on the power View. Let's say the authors wish to compare data Smartphone sales in ASEAN with its large number of population in the country.

You can begin by collecting data and transform into a table format. Will display a warning when the action you performed, this corresponds to the table if you want to have a header on the table or not.

Tweet

Do not miss the best of the post-post Maxz Pro. Now also subscribe by email :

You can also follow Maxz Pro by clicking on the button below :

Artikel keren lainnya:

Ditulis oleh Unknown pada tanggal Sabtu, 20 Desember 2014