TEE Website Blog Post Headers Images 5

Improvements with Excel in 2017

Excel has gained many new features and improvements this year, with even better features announced for release next year. This year’s updates include better background removal of images, support for collaborative editing, and automatic file saving. The features added this year have helped to make Excel better for both collaboration and note-taking.

Better Background Removal

Excel 2016’s February update added better background removal. While the ability to remove the background of an image has existed since 2010, but this year’s updates have improved its capabilities drastically. Rather than cropping out the background using straight lines alone, users can now use a free-form select tool to better fit the borders of the desired object. Additionally, Excel automatically detects the general background to eliminate the need to draw a rectangle around the foreground.

The New “Dubai” Font

Microsoft has worked with the Executive Council of Dubai to create a new font with support for Arabic and Western European languages. In March, Excel and other Office products began to include Dubai alongside their other fonts. Designed with legibility in mind, the Dubai font is very easy to read.

Better Access for Subscripts and Superscripts

This addition is a minor one, but some users will find it quite useful. In June, the Quick Access bar received an option to include the superscript and subscript buttons. Users writing mathematical or chemical formulas will now be able to write their equations without constantly switching tabs.

Collaborative Cloud Editing

Teams can now work on the same Excel workbook at the same time. When “co-authoring”, users will see changes from other users within seconds, similar to how users can work on the same sheet in Google Sheets. After uploading your workbook to OneDrive, it becomes shareable with any number of users for easy collaboration.

Co-authoring also automatically enables AutoSave. As its name suggests, this long-awaited feature will periodically save your files to OneDrive. With this, the old advice of “save early, save often” is made redundant by automatic saves every few seconds. Co-authoring requires AutoSave, but Autosave can optionally be enabled for any file uploaded to OneDrive.

Better Note-Taking

Excel 2013 was the first version to add support for drawing tools. These tools, supporting both mouse and touchscreen input, helped users take notes better by allowing for both visual and textual notes. Beginning with the June 2017 update, users are able to create a custom “pen set”, which synchronizes across all of your Windows devices. Additionally, the October update added a pencil texture for users that desire a more realistic note-taking experience.

For more information on how you can get the most out of Excel and the recent updates, see the Excel services on offer from The Excel Experts.

Automating tasks with excel (1)

Cut and Fill

With Construction Twin we want to model the foundations  and the cut and fill process of a construction project.  Every square meter of the site

Read More »

Need Help With Excel?

The Excel Experts are here to help with your Excel tasks big or small, including spreadsheet help, consulting, reporting, VBA, automation, and Power Bi. Let us help you take your Excel skills to the next level with our experience in delivering solutions.

    Max. file limit is 20mb

    Recommended For You

    The Excel 2023 Book

    Master Microsoft Excel from scratch in less than 7 minutes a day!