3ae9962b71b6ed5253ef4d0ef2eed72991e8a342_pexels-photo-392018.jpg

Microsoft Excel 2019 – what to expect

8d143c258dc323aa5f52d73dba8289f11f5e0965_fb28bcb53645438b03d3972b8c050fed.png
Chip Reaves
2018-10-28

For devotees of Microsoft Office, it is almost time for our triennial event: the unveiling of new versions of Excel, Word, Outlook, PowerPoint, and the rest of our “can’t work without ‘em” office apps.

Except…this year is different.  In 2007, 2010, 2013, and 2016 we watched as the folks in Redmond released the new version of Microsoft Office, and, depending on your level of enthusiasm for the new features, we either rushed out to upgrade or decided to wait another three years.  What makes Office 2019 different is two things:

  1. There aren’t very many new features, and
  2. You probably already have them (if you use Office 365)

You see, back in 2015 Microsoft decided to be more like popular cloud-based apps such as Salesforce or Google Apps by updating their apps on a more regular basis.  For Windows 10 this meant monthly security updates and semi-annual feature updates.  For Microsoft Office, this meant that they would push hard to encourage people to use their subscription-based Office 365 product, and that they would reward their Office 365 customers with monthly updates.

So when Excel 2016 for example was officially released in September 2015, it was just the first version that Office 365 subscribers would see.  Since then there have been 30 updates (almost but not quite monthly), which have added new features.  Some of the updates were small and unnoticed by most people.  Some were only useful to power users or people with touch screens.  A few were more broadly valuable, including improved abilities to share and co-edit spreadsheets, or the ability to add 3D models and SVG graphics.

If, however, you do not get your Office through Office 365, then your version of Excel 2016 is that same version that was released three years ago, without any of the intervening feature updates.

In October Microsoft is expected to officially take the latest versions of Excel, Word, PowerPoint, Outlook, and Access, along with all the feature updates that Office 365 users have already received, and call it Office 2019.  So if you are an Office 365 user, you’ll see very little difference.

If you are NOT an Office 365 user, and your organization does plan to move from the “traditional” version of Excel 2016 to 2019, here are some of the new features you can look out for:

  • Improved graphics:  Excel (and other Office apps) now support SVG image files, which can be scaled to any size without looking fuzzy, as well as 3D models.  The 3D models option sounds like something engineers might use, but really it’s great for clipart – you can grab a 3D model from Microsoft’s library at Remix3D.com and then tilt or rotate it to just the right angle to fit your need.
  • Ink & Stylus support:  On computers with a touchscreen or stylus you can draw freehand directly on your spreadsheet (or document in Word) using a variety of virtual pens and pencils.  You can convert your sketches to shapes if needed, and your customized pens will show up in any Office app.
  • Improved sharing and co-authoring:  It’s now very easy to share a spreadsheet from inside Microsoft Excel, which can include the ability to allow someone else to co-edit the spreadsheet with you at the same time.  This requires a cloud storage solution such as Microsoft’s OneDrive, SharePoint, Groups, or Teams, but can also work with some third-party solutions such as Dropbox.
  • New Charts, Functions, and Features: There are a handful of new charts and functions, the most useful of which might be the Stock Quote function.  A few new features can be handy, including the autosave feature for cloud-hosted files, and the Microsoft Translator tool to work with different languages.

Overall there is no big “wow” feature added to Excel this time, just lots of smaller but solid new tools and features that help to improve the world’s most popular number-crunching app.

For an overview of how to use all the new features found in Excel 2019, check out the “What’s New in Excel 2019” training course from Bigger Brains, available now in Go1 Premium. Contact Go1 today to get started!

 

About the Author:

Chip Reaves is the founder of Bigger Brains, an award-winning eLearning company, and has been an IT consultant for 30+ years. Formerly the founder of the worldwide Computer Troubleshooters franchise, Chip has been named one of the top 150 most influential people in small business IT and is a frequent speaker and contributor on Office 365 and Microsoft topics.

 

Go1 helps millions of people in thousands of organizations engage in learning that is relevant, effective and inspiring.
Latest stories and insights