What’s new in Excel 2016 for Windows ?

What’s new in Excel 2016 for Windows ?

Excel 2016 for Windows has all the functionality and features you’re used to, with some added features and enhancements. Here are some of the top new and improved features.

NOTE: The following feature updates are available to Office 365 subscribers. They will first roll out to Office Insider participants, and later to consumer and commercial Office 365 subscribers. If you have an Office 365 subscription, make sure you have the latest version of Office.

October 2016 Updates

New Ink Replay button

Using ink in your spreadsheets? Now you can replay or rewind your ink to better understand the flow of it. Or your peers can replay it to get step-by-step instructions. You’ll find Ink Replay on the Draw tab. Give it a try!

Shared with Me

Does this sound familiar? Someone shared a OneDrive file with you, but you can’t find the email message that has the link. No problem. With this update, you can click File > Open > Shared with Me. This will show you all files that have been shared with you.

CSV (UTF-8) support

You asked for it on our Excel User Voice forum: You can now open and save CSV files that use UTF-8 character encoding. Go toFile > Save As > Browse. Then click the Save as type menu and you’ll find the new option for CSV UTF-8 (Comma delimited). CSV UTF-8 is a commonly used file format that supports more characters than Excel’s existing CSV option (ANSI). What does this mean? Better support for working with non-English data, and ease of moving data to other applications.

 

September 2016 Updates

New Excel training

The Office Training Center has 10 new Excel courses, created in partnership with LinkedIn Learning. Watch videos at your pace to learn about Excel 2016 including using formulas and analyzing chart data. Also learn how to get unlimited access to over 4,000 video courses from LinkedIn Learning. See all our Excel training.

New feedback command on the File menu

Have a comment or suggestion about Microsoft Office? We need your feedback to help us deliver great products. In Excel, you can suggest new features, tell us what you like or what’s not working by clicking File > Feedback.

Excel 2016

Updates for Get & Transform and the Power Query add-in

  • Added support for query parameters: You can now add parameters to your queries in the Query Editor. Just click Home > Manage Parameters > New Parameter.

    Power Query - Manage Parameters option

    Power Query - Manage Parameters Dialog

  • Create new queries based on merge/append operations: You can now use merge and append operations to create new queries in the Query Editor. Click the Home tab. Then click the down arrow next to Merge Queries, and then click Merge Queries as New. To append as new, click the down arrow next to Append Queries, and then click Append Queries as New.

    Power Query - Merge Queries as New option

    Power Query - Append Queries as New

  • Improved web connector with page preview: We’ve improved the web connector experience. Now you can see a live preview of a web page, and select the desired table(s) for importing. Select Data > New Query > From Other Sources > From Web. After you put in your URL and click OK, the Navigator will appear. On the right, click the Web View button. Now scroll through the page. Any table with a tab and border is ready to import. Select the table that you want, and then click either Load or Edit to work it further.