This article has been provided by Filtered which is an online education platform which customises learning material for each user. The platform offers courses in essential business disciplines from leadership and management to strategy, spreadsheeting and project management. Filtered provides discounts for IAB members on a range of courses. To find out more about this offer please login to the restricted area of the IAB website (http://www.iab.org.uk/users/login.)
Today we’re presenting part two of our favourite new features of Microsoft Excel 2016.
EXCEL 2016 – TOP 10 NEW FEATURES (PART 2)
These features will help you bring your data to life and take you to the next level when using the popular spreadsheet programme.
These show values by hierarchy and are ideal, for example, for analysing sales of a company where you want a breakdown by salesperson, customers and products purchased. The chart would plot the sales people at the highest level and size their sections by the sales they have made. The next levels would let you drill down further into customers and purchases.
Waterfall charts are great for showing movement from an opening position to a closing position, ideal for plotting financial data such as cash flow over a period of time. They show the progression through the various stages of trading you may have and then stop at your closing balance. Useful for businesses of all sizes!
8. 3D daa map
The 3D data map, an add-in in the 2013 version, is now a fully integrated option. It’s perfect for analysing data with a global span (e.g. a sales report for a multinational company). The chart will give you a world map with bars in the locations that have fields attached to them. What’s more, if you set this against a particular period of time the chart will allow you to record a simulation video showing the change in values over that period.
PowerPivot, though still technically an add-in and not new to Excel, is a great tool to bring data into Excel. It allows you to import much greater levels of data (we’re talking hundreds of millions of fields here) and even has its own function language, Data Analysis Expression or DAX. This is where the new features lie, so if you’ve exhausted all of Excel’s functions have a go with PowerPivot.
10. Get & Transform
Another permanent fixture that started life as the PowerQuery add-in, Get & Transform helps you import data from various data sources. Traditionally you would need a Comma Separated Values (CSV) file or an Excel workbook to import data but now you can also choose options such as Facebook, Salesforce and other sources.
To help reinforce your Excel knowledge you can:
Comments are closed.