New excel functions that increase the performance of electric tables

The new Excel recently introduced Microsoft. By novelty, additional functions are clear. They increase productivity, simplify the analysis.

New tables are adapted to PC, Mac, iPad, writes Xrust. These updates are designed for a wide audience. Here are newcomers and an advanced audience. Among the proposed technologies — AI, Python. Some of the functions are improved.

Critics note the success of the company in simplifying the work process. This naturally increases productivity. From tools based on artificial intelligence, which actually think for you, to improvement of elegant design that simplify navigation according to your data, these functions are suitable for everyone.

Imagine an analysis trends using Python, the creation of multilingual reports in a matter of seconds or a joint Command work.

We list the key moments of the innovations:

• The high-contrast color choice, the Focus Cell function and the functionality of the flags, as well as the updated Office topic for better navigation and presentation;
• new formulas. These are the functions of Groupby, Pivotby and REGEX, optimize the analysis of data, and the XLOOKUP and XMATCH updates add the capacity capabilities for advanced data cleansing;
• improved weather (for example, export export in CSV), tools Improving the efficiency of Mac (for example, key tips, power query updates) and iPad functionality (for example, sheet protection, editing consolidated tables);
• Integration with Microsoft Forms and improved the possibilities of joint access, make command work more Effective, and Copilot based on artificial intelligence and Python scripts provide advanced capabilities of automation and analysis.

Practice will help to understand all the amenities.

P>