It doesn't come with Office Home & Student 2019, so you'll only get it if you buy Office Home & Business 2019 - or subscribe to Office 365 instead. Outlook is Office's email, calendar, and contacts application. Map and funnel charts might be new to Excel, but they're a good example of Microsoft playing catch-up - Google Sheets has offered the ability to create charts like these for some time now, while both Sheets and LibreOffice's Calc let you deselect cells by Ctrl-clicking them. Also included are two new types of chart map charts - for displaying different values across different territories, for example - and funnel charts, which display values at different stages of a process. It sounds boring, but it's actually a big time saver.Įxcel 2019 introduces a selection of new functions, most useful of which are MAXIFS and MINIFS, which return the largest or smallest value in a range, respectively. Now, however, you can hold down the Ctrl key and click to deselect any cells or ranges of cells within an existing selection. How many times have you selected multiple cells in a worksheet, only to realise that you've accidentally included one or more cells you don't want? In the past you'd have had to reselect it all again from scratch.

The new Excel feature that got us excited is the ability to deselect cells. The latest version of Excel shares some of Words improvements (including the new Draw tab tools and Translator) and offers some new features of its own, most notably the ability to publish to Power BI (Microsoft's business analytics service).Įxcel 2019 lets you visualise data in funnel and map charts

Can i upgrade office 2003 to 2016