In December 2020, we announced LAMBDA, which allows users to define new functions written in Excel’s own formula language, directly addressing our second challenge. These newly defined functions can call other LAMBDA-defined functions, to arbitrary depth, even recursively. With LAMBDA, Excel has become Turing-complete. How to activate Microsoft Office Professional Plus 2013. By Using this activator you can also activation all versions of Windows 10, Windows 8, Windows 8.1. Learn how to get Microsoft Word, Excel and PowerPoint for free in 2020. You also get Forms, OneDrive, OneNote, Outlook, Sway, To Do, Power Automate, and seve. The Office Suite 2020 Professional Is The Perfect Solution. Forget monthly fees and expensive Office software. Office Suite 2020 works with all of the default office file formats. Pdf, doc, docx, xls, xlsx, ppt, pptx alongs with many other formats. Download Microsoft Excel Free for Windows 2020. Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, iOS and Android.

One of the value propositions of subscribing to Microsoft 365 is that you continue to get new features that can make a significant difference in your productivity. That’s one of the benefits that has made the software so popular with businesses.

As of February 2020, there were approximately 595,935 companies in the U.S. using Microsoft 365 for their business workflows.

There are so many features being added to the platform regularly, it’s easy for users to miss one and not even realize a tool like Excel can now make their work even easier to do and improve business processes.

We’ve reviewed all the Excel feature updates that Microsoft has rolled out so far in 2020 to bring you the lowdown on some nifty new tricks you can do in this popular spreadsheet application.

Have You Seen These New Excel Features?

XLOOKUP Function

The XLOOKUP function in Excel allows you to find values that are located in a spreadsheet range or table.

For example, if you have a spreadsheet of employee names and ID numbers, instead of having to scroll up and down to find specific ID’s, you can do an XLOOKUP instead.

What this will allow you to do is create two cells side-by-side. One will be where you would input the employee’s name, and the second would be filled in automatically by Excel with that person’s ID.

· In an open cell type: =XLOOKUP

· Select an empty cell where you’ll put the lookup value (i.e. where you’ll type the person’s name that you want to find the ID for)

· Type in a comma

· Select where to look up the value (i.e. select a series of cells in a column where employee names are listed)

· Type in a comma

· Select the data you want to see (i.e. select the cells containing the employee ID numbers)

· Press Enter

Now you can type in any employee’s name to automatically see their ID number (or any other data you like). Here’s a handy video about XLOOKUP from Microsoft.

Workbook Statistics

Get a quick bird’s eye view of your Excel workbook with a new feature option. Just click the Review tab in Excel and you’ll see Workbook Statistics in the Proofing area.

Clicking the feature pops up a window with details on both your current sheet and entire workbook like:

· End of sheet cell

· Number of cells with data

· Number of tables

· Number of formulas

More Images, Icons, Backgrounds, Templates

Around the same time that Office 365 was renamed to Microsoft 365, thousands of new design “goodies” were added to the Office programs.

When you use the Insert > Illustrations menu option in Excel, you’ll find many royalty-free stock photos, icons, and other design items to use. Templates have also been expanded. Microsoft said they added “thousands” more of these design items to the platform for users.

Ideas in Excel

Need some help deciding how to express your data or put it into a visualization? You can now get help from Excel using the new Ideas function.

Just highlight any data that you have in your spreadsheet and from the Home tab, click Ideas. A pane on the right-hand side will open offering several different ways that you can express that data and the ability to click to add a chart to your sheet.

You can also go a step farther and ask about your data, such as “What are the sales by region?”, and Excel will answer you with a chart if all the variables are there to create it.

This can be a huge shortcut when you’re creating various KPI analytics for your team to review.

Stocks & Geography Data Types

Pull in stock and geographical information without having to do a Google search. When you convert your data to one of these data types, it will automatically connect it to an online database to pull in information.

For example, say you are building a report on cities and need to look up things like population, average household income, etc. All you have to do is convert your city names to the Geography data type, and you can bring in all that information from the online database in a click.

· To convert to a datatype, just highlight the data you want to convert, like city or state names, then on the Data tab, click either Stocks or Geography.

· Then, highlight the data again and you’ll get a box at the top of your selection. Click that, and it opens a drop down of options based on the data type you selected (like population).

· Click to choose, and the data is populated in the next open right-hand column.

Are You Making the Most of Microsoft 365?

Microsoft 365 is so feature rich that often companies miss optimization opportunities. BrainStomp experts can help you uncover those features that can save you time and money in your daily operations.

Contact us today to schedule a technology consultation! Call 260-918-3548 or reach out online.

February 20, 2020 - by Bill Jelen

For decades, some people have been wanting a better way to have multiple people in the same workbook at the same time. The old Shared Workbook functionality was awkward. People resorted to only one person having write access at a time', which led to someone opening the file and then forgetting to close it before going for a two-hour lunch and tying up the file that whole time.

After Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent over two years developing a feature that they call co-authoring. The feature was released to Office 365 customers in the summer of 2017.

The feature works well once you get it set up. But it is difficult to figure out all of the steps to allow multiple people to use Excel on their computers instead of having some people stuck using Excel online.

To start, choose one person to be the owner of the workbook. This person should already have a One Drive For Business or SharePoint Online folder set up. The owner of the document should use File, Save As and choose to save the document in either OneDrive or SharePoint Online.

The owner of the workbook clicks the Share icon in the top right corner of Excel.

The Share panel asks you to invite people by e-mail address.

But if you look at the bottom of the panel, you can generate a sharing link.

Microsoft Excel 2020 Product Key

Generate a sharing link where anyone with the link can edit the workbook.

Copy the link and send it to others on your team.

The next step is the annoying part. When they follow the link, they will be taken as a guest to Excel Online. The spreadsheet will appear and they can edit in Excel Online. I talked to people from one company who stopped at this point. One person (the workbook owner) would edit in Excel and everyone else was stuck in Excel Online.

Caution

As shown below, the 'Edit in Browser' button is very prominent and it is what you are likely to click. In desperation, you might try clicking Download, but this removes the ability to co-author. Not so obvious in the top right corner is the Sign In button.

For the other co-authors to use the workbook in the real version of Excel running on a PC, they have to first Sign In to Excel online. Use the credentials that are shown in Excel under File, Account.

Once they have signed in, then the Edit Workbook drop-down menu appears. Open the menu and choose Edit in Excel. This is the only way to have everyone co-author and use the real desktop Excel instead of Excel Online.

While you and others are working in a document, your active cell will be outlined in green. The active cells for others will be other colors. If you want to know who is editing a cell, hover over that cell.

Co-authoring will work fine provided everyone avoids editing the same cell at the same time.

When someone (probably your manager), dives in to edit a cell that you are already editing, then a confusing set of rules decides who's edit wins. Rather than dealing with these rules, be happy that co-authoring mostly works and have everyone agree not to edit the same cell at the same time.

Co-authoring is a whole new experience. There are good things and bad things that you need to get used to when you are co-authoring.

Microsoft Excel 2020 Book

Title Photo: Perry Grone at Unsplash.com

Microsoft Excel 2020 Interface Elements

Html editors for mac. This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.