Microsoft Excel 2016 - Tips and Tricks
Microsoft Excel is, undoubtedly, the most popular spreadsheet software in the market. Each iteration of this software improves upon the previous to give the users all that is needed for their statistical needs. Let’s look at some interesting features of Excel 2016. Power Query: Power Query is available as an add-on in the 2010 and 2013 versions, but it is integrated with the 2016 version. Power Query is a data connection technology which can be used to manipulate data; modifying columns, merging tables and changing data types are just some scenarios in which Power Query could come in handy. Read-only mode: Excel 2016 users can use this to minimize the risk of accidental file changes. Using this is simple- while saving the file click on the Tools’ drop-down at the bottom of the 'save as’ dialog, then click on general options’ from the list and finally check the Read-only recommended’ box to make sure the file is read only. New chart types: The im