Microsoft Excel and Google Sheets are two of the best spreadsheet makers that you can use nowadays, and they both come with a set of powerful features. While Microsoft’s entry is the business standard, it took some inspiration from Google. Microsoft Excel now uses formula suggestions.
Using formulas is a large part of using spreadsheets for most fields, and it comes in handy for doing calculations. This can be a pretty high barrier to entry for some folks, so most programs have some sort of system to help them out. This is why both Excel and Sheets use automated formulas.
Microsoft Excel now uses formula suggestions
Microsoft just announced some new features coming to both Excel for web and for Windows. Both versions got a different set of features, so you’ll want to check out the list for the version you have.
If your job revolves around entering formulas into spreadsheets, then it can be tedious having to constantly put them. So, Microsoft Excel just introduced some new ways to speed up the process. With the new update, Excel will give you suggestions of what formula to put in when you start typing it. The company posted a video to YouTube to show how it works.
In the video, we see the user putting a new row for the Totals. The user then puts an “=” symbol. At that point, we’ll see the formula suggestion pop up for you to select. Microsoft suggests the formulas based on the context of what you’ve already typed. So, the system is giving you the most likely formula.
There are limitations to this feature. For starters, this feature is only available for English-speaking users. Also, this feature only accommodates a handful of formulas at the moment. It only includes Sum, Average, Count, Count A, Min, and Max.
This feature is only rolling out to users on the web version of Microsoft Excel. It’d make sense for it to arrive on the version for Windows, so we’ll have to wait and see.
Discussion about this post