Important features of MS Excel 2016

By -
MS Excel 2016 is more enhanced with its feature. For windows and OS X, MS office 2016 will release tomorrow (22-Sept-2015). You can easily download its preview from the official site and they are also providing the product key for office 2016 preview. This preview will be available on your system until you uninstall office 2016 preview or office 2016 is released. So get ready to know about few of them like Power-Query and Business Analytics. Read this post to know about them.


Power Query

Power query is not a new feature for Excel users but this time it is more integrated and available as an inbuilt feature of MS Excel 2016. This feature is available in Excel 2010 and 2013 as Add-in. In MS Excel 2016, this feature is available in Get & Transform section which provides fast, easy data gathering and shaping capabilities.























Image courtesy: Microsoft

I will discuss some important feature that you can achieve with power query in Excel 2016:

Data Connectivity: This feature is more updated in Excel 2016. It also helps to combine and filter the data. Now you can easily connect with the new data sources like Facebook and Salesforce to import the data. This is the new change in MS office 2016. As previous versions it also imports data from Files, Database, and Azure etc as shown in the figure:



Data Shaping: Query editor is the most significant feature of this new release. You can easily see the preview of your data and perform modification such as remove, pivot and unpivot columns with the help of query editor.

Data catalog: You can use this option to find the data according to your requirement. This is possible by the power BI enterprise catalog. To use this, you should have the power BI license.

Business Analytics

Any result is based on the analysis factor and it should be clear from the beginning of the project. Take a look on the following process:

Let’s discuss some features of business analytics of MS Excel 2016.

Modernized Data Analysis: Data analysis always plays an important role for every project growth. This feature is wonderfully enhanced in Excel 2016.Now you can be more focused on uncovering the insights rather than managing your data. I read about automatic time grouping and drill-down chart navigation feature to improve the usability. You can see them on below image:


New and Improved Charts: With this option, Excel 2016 has fined the new idea to expand the visualization of data by improvement in charts. It has the new set of modern charts with a consistent look and feel. With this option, you can easily understand the percentages of data. See the most useful charts, waterfall and sunburst in the image below: 


Excel Forecasting Function: You can feel the best experience of forecasting by FORECAST.ETS() function. You can see some reasonable results on the image below:


Sum Up: Power Query and Business Analytics are very interesting features in MS Excel 2016. Efficient data connectivity will make data importing more easy and by the use of query editor, user can shape the own data according to need. Similarly, Business Analytics feature will make your work easy in a graphical manner. 

Comments

Post a Comment

Popular posts from this blog

Simple Tips to Fix Bookmark Not Defined Error

By -
Image
Bookmark not define error occurs in the large size word document. The main reason of this error is broken link to into the bookmark. It is also related to TOC (Table of Content) and some user complaint this error during updating of TOC. The complete error message is: “ Error! Bookmark Not Defined. ” or “ Error! Reference source not found. ” Important Tip: If you get the same error then press Ctrl+Z to undo action. It works instantly on the document but not worked when you perform any other operations and save the document. Let’s see some reliable solution to fix it! Solution 1: If you are trying to merge the content into a new document, then unlink them before doing it. This process converts TOC field to actual text and tries to prevent it from any update. If you want to update the TOC, you must reinsert it. Steps to unlink the table of contents: Place insertion point within the table of contents. Press ctrl+shift+f9 (for Windows), or the command key+shift+f9 (for
Read more

5 Powerful Solutions to Fix QuickBooks Error 6177

By -
Image
Error 6177 occurs when QuickBooks software does not recognise the path to open the company file. This is the primary reason but, other reasons can also be cause for this error. Let’s discuss some important solution to fix this error. Solution 1: Move your company file to hard-drive Change the location of your company file from a server or any other drive to C drive. Now open the file from there. Create a portable file and save the company file in local drive. Close the company file. Now, restore your portable file from C drive and save to server. Select company file and open it from server. 5-powerful-solutions-to-fix-quickbook Solution 2: Update the QuickBooks version Visit the product page of QuickBooks and update with the latest release. Always update all the updates: manual & automatic to protect the QuickBooks from unwanted error. Solution 3: Manually Fix Follow these steps to manually fix the QuickBooks error 6177 Open the folder that contains company
Read more

How to solve “This document may be damaged (the file may be truncated or incomplete)” JPEG image error

By -
Image
JPEG image or any file type images are very sophisticated, If one pixel of your image get damaged or corrupt then that portion of image will get change. If header part of your image gets damaged then your image will not open. There are several reasons for corruption of JPEG images like virus attack, improper system shutdown etc. In the case of JPEG file corruption you need to repair it with some good JPEG repair software to access your image properly. These are some error messages which you may get in the case of images corruption. Different image viewer will show different message. In Windows Explorer “No Preview Available”. Windows Picture & Fax Viewer will show “Drawing Failed” message. Adobe Photoshop will show “This document may be damaged (the file may be truncated or incomplete)” message. In IrfanView “Can't read file header! Unknown file format or file not found!”. Adobe Photoshop “Could not complete your request because an unkno
Read more