It appears that working with Excel formulas is about to become much easier and more interesting. Microsoft is working on several new updates for its spreadsheet software, MS Excel, with the goal of making it easier to work with formulas.
Formulas are one of Excel’s most fundamental features, allowing users to perform calculations and solve problems quickly and easily using built-in functions.
Multiline Formula Bar and Argument Assistance
If you’re just getting started with Microsoft Excel formulas, you can download the company’s Formula workbook, which walks you through Excel’s most common formulas in a well-guided step-by-step fashion.
When it is released, users will be able to resize the formula bar, making it easier to navigate when working with longer formulas.
Furthermore, as part of its roadmap, the company intends to add a new feature to its spreadsheet software called Argument Assistance.
When the user is writing a formula, the Argument Assistance feature will appear in the form of a card on the Excel sheet and will remain on-screen during the arguments insert/edit phase.
The Argument Assistance card will assist users in being more efficient when writing formulas, lowering the risk of errors. It even includes descriptions of each of the formulas, as well as the various arguments used as examples.
If you haven’t used formulas in Excel as part of your workflow until now. We recommend that you begin using it right away. There’s never been a better time to start taking advantage of Microsoft’s spreadsheet software.
To read our blog on “MS Excel Shortcut Keys: Best Microsoft Excel Keyboard Shortcuts for Windows and MacOS Computers,” click here.