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.
Artikel keren lainnya:
Belum ada tanggapan untuk "How to Easily Make Presentation Data with Microsoft Office Excel"
Posting Komentar