Tag Archives: Excel

Control automatic data conversion in Microsoft Excel

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 Office free apps for smartphones and tablets with 10.1 inch or smaller screen

Microsoft Office apps such as Excel, Word, and PowerPoint are available as free downloads for iOS , Android and Windows smartphones and tablets that have a screen size of 10.1 inches or smallerUsers can view, edit and create new Office format files with these free apps once they login with a Microsoft user account, but they must subscribe to Microsoft 365 (formerly known as Office 365) to unlock all app functionality.  Free web brower versions of Office apps are also available for users logged into OneDrive.

Students and teachers with a valid school email address are also eligible for the free Office 365 Education version.

Apple device users can run the iWork productivity apps, which includes Pages, Numbers, and Keynote.

Office Apps for Windows 10 Mobile will no longer be supported by Microsoft as of January 12, 2021.

Excel XLSX files and Word DOCX files are Zip files of XML data

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.

Microsoft Excel and Access function lists and keyboard shortcuts

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.

A list of Microsoft products no longer supported in 2018

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.