Excel

Microsoft unveiled a slew of new consumer and enterprise-focused products and services in 2021. It’s been a big year for the company with the most significant announcements such as Windows 11, Teams 2.0, a new Visio web app, and an affordable Windows on Arm development kit. Here’s a look at everything you need to know.… Read More

Microsoft 365 is a subscription service that brings the latest Office desktop apps together with cloud apps and services like file storage, security, collaboration, and productivity, including Microsoft Teams, Lists, SharePoint, Exchange, Planner, OneDrive, and much more. Microsoft 365 is available in plans for personal users, families, businesses, and large enterprises. Microsoft 365 includes apps… Read More

Have you ever been scrolling through a large Microsoft Excel spreadsheet and stopped because you came across some cells with important data and it whips right past you? Well, Microsoft Excel engineers have been working to enhance this aspect of Excel for a long time. When they set out to 'put the idea to code'… Read More

On one of Microsoft's Office Insider blogs, a PM on the Excel team recently announced new functionality in the helpfully consistent evolution of Comments and Notes. Specifically, the debut of yellow sticky comments, now called Notes, in Excel for the web. There are also some new additions around threaded comments and the notes experience in… Read More

One of Microsoft Excel's Project Managers (PMs) on the Office Insider team recently published another 'Feature deep dive'. They announced a coming feature called Show Changes, which will allow authors more confidence when sharing and collaborating with others on Excel for the Web. 'Show Changes' will allow users sharing Excel files on OneDrive or SharePoint… Read More

If there is one app in the Office 365 suite that keeps people coming back to the productivity tools it is not Teams, but Excel. The spreadsheet application is easy to use, highly flexible, and in many companies around the world, worksheets are a structural part of the operational workflow. Last year, when XLOOKUP was… Read More

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.