Excel

Microsoft has a new scripting feature for Excel and it's going to make automating redundant tasks significantly easier.

For Office 365 customers this month, updates rolled out for Flow, PowerApps, Power BI, SharePoint, Teams, and even Excel.

Excel fans delight! You can now export task data for a Planner plan to Excel and slice and dice the task information to your heart's content. The new feature is likely to be popular with Office 365 users because it adds values and it makes sense to use Excel for this purpose, but another way of looking at it is that Planner is so poor at analysis and reporting that it needed external help. The truth probably lies in the middle.

If your Office 365 tenant has many private Teams, you might run the risk that people create duplicate teams because they don't know that a team already exists. Teams doesn't have a separate directory but you can create one with PowerShell and publish the output in Teams. The magic is provided by deep links, which users click to navigate to a team they want to join.

Another month has come and gone and the pace of change in the Office 365 ecosystem continues to wear me out.

If you use Office 365 and store documents in SharePoint or OneDrive for Business, the Office applications can autosave as you work to ensure that you never lose any content. It’s a good idea and the implementation works well. But I have a slight nagging doubt about the network impact for some tenants.

Microsoft Excel causes problems in genetic research. That’s the claim of three researchers from an Australian institute, who discovered almost 20% of data sets contained errors introduced by Excel. The problem is Excel being “clever”—guessing the type of data it’s being asked to import. Unfortunately...

Microsoft has announced the general availability of its REST API for Excel that will extend the capaiblites of the spreadsheet application to new products.

Microsoft's productivity future is based heavily on the fact that corporations are addicted to Excel, and there is not a compelling alternative.

Jeff Hicks shows us how to easily query Excel workbooks as a database with some help from PowerShell.

Russell Smith serves us three helpful ways to connect to the Office 365 Reporting Service from Excel for easier report viewing.

In part three of this series, learn how to read data from an Excel file using PowerShell.

In the second of this three-part series, Jeff Hicks goes into even more detail about how to create a rich Excel document with PowerShell. In the conclusion of this series, which will be posted next week, he will explain how to look at reading data from Excel files.

In the first of this three-part series, Jeff Hicks details how to integrate PowerShell with Microsoft Excel by exporting Excel files from PowerShell.