Collaborate for free with an online version of Microsoft Excel. Save spreadsheets in OneDrive. Share them with others and work together at the same time. View and edit.xlsx,.xls,.csv,.tsv,.ods,.sxc files online, for free. View any Microsoft Excel or OpenOffice Calc file via Zoho Sheet.
We are excited to announce improvements to the Azure File Storage and Excel Online (Business) connectors to make them more useful and robust. Additionally, we have re-arranged the features between these two connectors for greater clarity and ease of use. These changes will be available in all regions by the end of April.
Azure File Storage Connector
With Microsoft 365 for the web (formally Office 365) you can edit and share Word, Excel, PowerPoint, and OneNote files on your devices using a web browser.
The Azure File Storage connector allows users to interact with their files in an Azure Storage account. We have removed the “blob” designation from this connector. This designation blocked Power Apps users from getting at the actions available for the connector. Now that this designation has been removed, users can now simply use the Azure File storage connector directly to store and display media files. Previously, as a work-around in order to use media files, users would use an Excel file with Azure File storage as a cloud storage service.
For Power Apps:
- Azure File Storage is no longer a supported cloud storage service when you generate a Power App for Excel.
- You can now invoke actions in the Azure File Storage connector directly in Power Apps
Excel Online (Business) Connector
The Excel Online (Business) Connector allows users to work with Excel files in document libraries that are supported by Microsoft Graph (OneDrive for Business, SharePoint Sites, and Office 365 Groups). There were several limitations of the old Excel connector including the fact that only a single user could work with the Excel file at a time and that you could not access files on a a SharePoint Site.
The updated Excel Online (Business) Connector is faster, more robust, allows for multiple users, and can work with all standard document libraries (One Drive for Business, SharePoint Sites, and Office 365 Groups.)
For Power Apps:
Free Online Excel Training
The updated connector is available when you add a data source in the Data Pane in Power Apps. It is not currently yet available when you use the App from Data experience.
Other FAQs
- How does this impact my existing application?
Existing app will continue to work. However, you will not be able to add additional Excel tables in PowerApps if those Excel files are in Azure File Storage.
- Does this impact Power Automate?
No, existing Power Automate flows will continue to work.
- Does this impact Logic Apps?
No, it only impacts Excel connector usage – which is not available in Logic Apps.
- Will we make similar changes to other file connectors like Dropbox, Box, Google Drive, etc?
We are planning changes for FTP, SFTP, SFTP with SSH, Azure File and File System connectors in the future.
MO-201: Microsoft Excel Expert (Excel and Excel 2019)
Languages: en es fr de ja ko zh-cn
Retirement date:
This exam measures competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations. The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.
Price based on the country in which the exam is proctored.
for Microsoft Excel Expert (Excel and Excel 2019)Free Spreadsheet Templates
All objectives of the exam are covered in depth so you'll be ready for any question on the exam.