What's new in Excel 365?

Excel 365 is a paid version of Excel that's subscription based. It provides numerous services that the past versions lack. It comes within the Office 365 plan.

You could’ve purchased previous versions of Excel, but with this one that is not the case. You can just pay monthly or yearly subscriptions, there is no other option.

You can share it with up to five people at one time, and you have access to 1 TB of storage. Which are all impossible with regular Excel.

That all has its pros and cons, but if you are on a budget, maybe it’s better if you pay monthly subscriptions instead of buying a whole Excel package. It will cost less + you will get more features than on regular Excel.

We are going to showcase all new functions and features that it includes, and we are going to show how to find them and use them properly.

excel geomap

New Features

Unhide Multiple Worksheets

You can now even unhide multiple worksheets in this new version. It’s a feature that should’ve been added in the past, but even now it’s available in a separate version of Excel.

To unhide multiple worksheets, all you have to do is press a right click on any sheet tab, then you should select them by holding SHIFT.

Workbook Statistics

Under the Review tab, click Workbook Statistics and you will be able to see the statistics of your Workbook and your current sheet.

This can be quite useful if you want to clean up cells that contain unwanted data, or just if you want to have further insight into your work.

Smooth Scrolling

There is now a new feature where you can smoothly scroll across large row heights without accidentally going to the next row. It’s pretty relaxing once you think about it, a small but a great feature.

Navigation Pane

This is a great way to get a whole overview over a workbook’s layout. You can see everything that the worksheet consists of, and you can navigate through all of that. This will come in handy if you have a lot of data that you have to go through.

Open it by going to the View section, then click on "Navigation".

Resize Conditional Formatting

Dialogs If you use Conditional Formatting with long formulas, you will be now able to resize the conditional formatting dialog boxes, which will definitely ease up your work and way of seeing.

New Functions

ARRAYTOTEXT

This function combines all values that were selected in a specified range into a one cell. Text values are unchanged, but non-text values are converted to text.

There are two formats of returned data that you can choose.

0 - This one is the default, the text will be returned the same as the text in the selected cell, with the same exact formatting.

1 - This format will include escape characters and row delimiters. It will generate a string that can be parsed when entered into the formula bar.

VALUETOTEXT

This function returns the text from any selected value. Text values are unchanged, while non-text values are converted to text. It can also create a Dynamic Array Formula.

It has two formats that are:

0 - Default, simple and clean format, that is easy to read

1 - Strict, array format that has curly brackets.

FIELDVALUE

This function returns a value that is in a particular field from a linked data type. This function can be also used with Stocks Linked Data Type and Geography Linked Data Type. It’s a very useful feature for analyzing those types of data.

STOCKHISTORY

This function provides you historical data about a stock, or a financial instrument. It is very useful for scraping and getting data from certain stocks that you want to follow, it can be helpful for future analyses.

LAMBDA

This function returns the results of a formula that was added as a named range. It gives you a way to have custom functions that you can have throughout the whole workbook, without using VBA or macros.

It has two parameters:

param_or_calc1 - First parameter, or calculation,

param_or_calc2 - Second, optional parameter, or calculation.

BYROW and BYCOL

These two functions do the same thing, just in different places, BYROW affects a row, while BYCOL affects a column. They return the results from applying a LAMBDA function to each row/column.

ISOMITTED

This function returns the value true or false, depending on the value in a LAMBDA is missing.

MAP

This function returns the array that has been formed by applying a map using a LAMBDA function.

REDUCE

This function returns the total value after an array has been reduced by applying a LAMBDA function. SCAN This function returns the array after the LAMBDA function has been applied to each value, and it returns an array.

MAKEARRAY

This function returns the array that was calculated by applying the LAMBDA function.

Conclusion

Excel 365 has a lot of useful formulas that will definitely help you go through your work better. LAMBA is a great function that surely has a lot of potential. And other small features that will increase your comfort while navigating through Excel.

If you are on a budget, or a business that has just started, it’s certainly worth paying it monthly instead of spending a huge amount of money at once. As you can also share it with up to five people at once. It’s a great thing for a fresh start.

It’s not that different from regular Excel, but seeing how it’s subscription based, that can be a motivation for many people to purchase it, since they will not be forced to pay the whole package.