Top Microsoft's new Excel feature: Updated Information

Safalta expert Published by: Ishika Jain Updated Mon, 26 Dec 2022 09:57 AM IST

Highlights

Users of Microsoft Excel can find patterns in data and classify it into useful groups. Additionally, Excel handles human resources tasks that assist firms in understanding the composition and activities of their staff, such as categorising hours worked and arranging employee profiles and expenses.

Microsoft unveiled 14 new functionalities and 14 intriguing new features in August 2022. Some of these additional features are accessible to everyone, others are exclusively available to Insider channel subscribers. The Insider features will progressively be made available to everyone as well. Let's examine each of these features and functions and how you may utilize them in Excel to more accurately evaluate and calculate your data.

Table of Content:
1 Functions for Arrays:
2 Text Functions:
3 Power Query Group Operations:
4 Improvements to the Excel and Power BI Connection:
5 Insert Images in Cells:
6 Option Show Changes:
7 New Excel for the Web functions:

1 Functions for Arrays:
Excel for the Web and Office 365 are accessible.
Let's examine the 11 array functions that Excel included in its August 2022 version and how they can enhance your use of the program:

Combined Use of Several Dynamic Arrays
The additional VSTACK and STACK functions allow you to vertically or horizontally join several dynamic arrays.

Lists from 2D Arrays and 2D Arrays to Lists
Use the TOROW and TOCOL functions to divide the 2D array into a single row and a single column, respectively. Alternately, after a row or column reaches the specified dimension, you can employ the WRAPROWS and WRAPCOLS functions to transform them into 2D arrays (height or width.)

Maintain or Discontinue Rows/Columns
You can keep or remove a specific amount of rows or columns using the TAKE and DROP methods (either from the start or the end).

Free Demo Classes

Register here for Free Demo Classes

Please fill the name
Please enter only 10 digit mobile number
Please select course
Please fill the email
Something went wrong!
Download App & Start Learning

Source: Safalta

However, you can utilize the CHOOSEROWS or CHOOSECOLS functions to retrieve particular rows or columns from a dynamic array.

Dynamic Arrays Expand
Additionally, Excel now offers a function called EXPAND that allows you to grow dynamic arrays. You can define the new array's dimensions as well as the value that will go within each of its new cells.

2 Text Functions:
Office 365 and Excel for the Web both have text functions.
It is simpler to extract text strings from a cell with the new TEXT BEFORE and TEXT AFTER functions. Text first before the intended delimiter is returned by the TEXT BEFORE function, while text after the delimiter is returned by the TEXT AFTER function. The TEXTSPLIT function, which allows you to split text across several rows or columns, is another intriguing feature.
Download ebooks to gain extensive knowledge about them.

3 Power Query Group Operations:
Excel for the Web & Office 365 are both available for Power Query Group operations (Business or Enterprise plans) There are numerous benefits of using Excel's Power Query: You can incorporate and import data from outside sources. After that, you can manipulate it in many ways to learn important things while leaving the source(s) alone. Sorting and analyzing the data just on the Queries pane is now much easier and more effective thanks to new Power Query group actions. A single click can now be used to perform operations on numerous queries (in the same group) thanks to the ability to group inquiries. For instance, you can refresh all of the queries inside a group by refreshing the group.

Additionally, Excel now allows you to effectively reorganize the Power Query groups. A query or group can be transferred to another group, and you can also remove specific queries from a group. You can concurrently extend and compress all Power Query groups. Finally, utilizing Properties has made updating the group description and name easier.

                 Boost your skills by learning:
                         Digital Marketing
                         Content Writing 

4 Improvements to the Excel and Power BI Connection:
For a visual study of your data, you may create pivot tables in Excel and connect them to a Power BI dataset. Two additional enhancements to Excel have been made to increase analysis efficiency: Dates are no longer strings but date-and-time objects. As a result, you can reorder data by putting the oldest items at the top or bottom. Drag-and-drop aggregations are now supported in Power BI-connected PivotTables. In the past, you had to design measures to analyze data.

5 Insert Images in Cells:
Accessibility: Windows, Mac, iOS, and Android Insiders for "Insert Images in Cells" With Excel's new image function, you may return an image for a cell. Before, a picture that you added to your spreadsheet hung above the cells. The image will not be affected by changing spreadsheets or moving cells because the new image condition returns images directly into cells. To obtain the image, simply enter the source location into the image function formula. You can also insert alternate text and set the image dimensions using the formula.

6 Option Show Changes:
Excel for the web, Excel for Microsoft 365, and Excel for Microsoft 365 for Mac are all accessible. The Show Changes function widens the scope for cooperation. To view the modifications made to your workbooks, use the Show Changes option under the Review tab. More recent modifications are displayed at the top of the Changes window, which displays changes made within the last 60 days (you must access the Version History to evaluate older changes). Who made the modifications, where and when where they were made, as well as the prior cell value were all disclosed in the Changes window.

                         Read More: Top 5 Functions Of Ms. Excel

7 New Excel for the Web functions:
In addition to the formulae and upgrades we just covered, certain new capabilities are exclusive to Excel for the Web. Here is a list of them:
  • Use Rich text formatting to prepare a portion of a cell.
  • Use the sort-by-color or -icon options in Excel to arrange cells according to their color or icons.
  • The element of the chart can be deleted. Simply click the Delete or Backspace key on your keyboard after selecting a data series in the chart.
  • For improved visibility, you can enlarge (and compress) the formula bar.
  • Edit old data connection-containing files (like Web Queries) or access data without changing or refreshing such connections.
  • Utilize the dated Shared Workbook feature to edit files.
Users of Microsoft Excel can find patterns in data and classify it into useful groups. Additionally, Excel handles human resources tasks that assist firms in understanding the composition and activities of their staff, such as categorising hours worked and arranging employee profiles and expenses.

What do Microsoft Excel's eight tabs represent?

Tabs on the Excel ribbon. The File, Home, Insert, Page Layout, Formulas, Data, Review, View, and Help tabs are the other eight on the Excel Ribbon. When Excel is opened, the Home tab is selected by default. Let's now examine each tab one by one, from left to right, to comprehend each of its aspects.
 

What are Excel's characteristics?

Microsoft created the spreadsheet program MS Excel, which is available for Windows, macOS, Android, and iOS. Pivot tables, graphing tools, and a macro programming language called Visual Basic for Application are some of the capabilities offered by MS Excel (VBA).

How many different sorts of menus does MS Word support?

The file is the first item on the menu, followed by Edit, View, Insert, Format, Tools, Table, Window, then Help. You instruct the software by using the menu.

What Excel formula is the most crucial?

The first Excel calculation you need to master is the SUM function. It typically averages numbers from a few of the columns or rows in the range you've chosen. Example: A straightforward selection that adds the values in a row is =SUM(B2:G2).

Free E Books