Microsoft has added options to change the Automatic Data Conversion in Microsoft Excel for Windows and Mac. For example, this will allow you to control removal of leading zeros, etc. when importing data from a text file. These settings are found under File > Options > Data > Automatic Data Conversion (Windows) or
Excel > Preferences > Edit > Automatic Data Conversion (Mac).
Microsoft is currently testing a new Excel for Android feature that will allow you to take a picture of data with your phone or tablet and paste the photo’s data into an Excel worksheet. Insert Data from Picture is currently being tested by select Office Insider users.
Microsoft Office programs such as Word, Excel and PowerPoint create files in Open XML formats by default. The file extensions for OpenXML format include XLSX (Excel), DOCX (Word), and PPTX (PowerPoint).
Files with names that end with “.xlsx” ,”.docx” or “.pptx” can be renamed to “.zip”. These ZIP files can be uncompressed to reveal multiple files and folders.
Information on how to read the contents of the Open XML format for Microsoft Office may be found at docs.microsoft.com/en-us/office/open-xml/understanding-the-open-xml-file-formats.
The Microsoft Office Online browser extension for Edge and Google Chrome browsers allows you to open and create files for Excel, Word, PowerPoint, OneNote, and Sway in your browser without needing Office installed.
This free extension is available from Microsoft Store and Chrome Web Store.
Microsoft has provided some web pages that list Excel and Access functions and keyboard shortcuts:
The Microsoft Excel and Access Tech Community sites have additional helpful hints.
Microsoft has released a list of products that will no longer be supported in 2018, including:
- Microsoft Visual Studio 2008
- Microsoft SQL Server Compact 3.5
- Microsoft Dynamics C5 2014
- Windows 10 Mobile – November 2015 release
- Microsoft Office Communicator 2007
- Windows Web Server 2008
A full list can be found at https://support.microsoft.com/en-us/help/4043450/products-reaching-end-of-support-for-2018.
Free online versions of Microsoft Office applications can be found at https://products.office.com/en-us/office-online/documents-spreadsheets-presentations-office-online. These include:
Users are required to sign in using their Microsoft account.