Microsoft Excel for Mac

Tell us is a text field in which you can enter words and sentences on what you want to do and quickly access the features you want to use or the actions you want to perform.

News of Excel 2021 for Mac

Excel 2021 for Mac allows you to collaborate with other people and easily analyze data with new Excel features, including co-publishing, dynamic tables, xlookup and let functions.

Noticed : Certain features listed below are not included in Excel LTSC for Mac 2021 for commercial customers. Each of these features is noted if it does not apply to Excel LTSC for Mac 2021 for commercial customers.

Co-publishing

You and your colleagues can open and work on the same Excel workbook. This is called co-publishing. When you co-edit, you can quickly see the other changes, in a few seconds.

Noticed: Co-publishing is not available in Excel LTSC 2021 for Mac.

Improved collaboration thanks to modern comments

Check the moment you send comments to your co-editors and be productive thanks to a consistent comment experience in your binders and other Office applications.

Noticed : Modern comments are not available in Excel LTSC 2021 for Mac.

Know who is in your workbook

See who others work with you and the place where they are in the workbook.

Noticed: This feature is not available in Excel LTSC 2021 for Mac.

Save your changes as soon as they are made

Download your files on OneDrive, OneDrive Entreprise or SharePoint Online to make sure that all your updates are automatically saved

Noticed: This feature is not available in Excel LTSC 2021 for Mac.

Personal leaves

Create personal leaves in an Excel leaf without disturbing the others.

Noticed: Personal sheets are not available in Excel LTSC 2021 for Mac.

Look to the left, look to the right. XLookUp is here.

Line by line, search for everything you need in a table or beach with XLookUp.

Return the exact correspondences by default; it is not necessary to specify it.

FUNCTION.LET

The letter affects names to the results of the calculation. This makes it possible to store intermediate calculations, values ​​or to define names within a formula. These names apply only within the framework of the letter function.

Identical of the programming variables, the Let is made thanks to the person’s native formula of the native formula.

Dynamic paintings

Write a formula and return a table of values. Accelerate calculations and perspectives in six
Other new functions: filter, sort, trierpar, unique, sequenceet array.

XMATCH function

The xmatch function is looking for an element specified in a matrix or a range of cells, then returns the relative position of the element.

You can also use xmatch to return a value to a matrix.

Find what you’re looking for

Use the search zone to find text, commands, help, etc.

Tell us is a text field in which you can enter words and sentences on what you want to do and quickly access the features you want to use or the actions you want to perform.

Visual update

Work with a modern start -up experience and newly updated tabs in the ribbon.

Discover a clear and refined style with a single-line iconography which indicates actions and functionalities with simple visuals.

Performance improvements

Discover improved performance, stability and speed within Excel.

Get faster calculations to leave Excel common functions such as sum.If, account.If and medium.IF.

Monitor your formulas

Look at cells from several sheets and binders in a single pane or window.

There waking window Facilitates the verification, audit or confirmation of formula calculations and results in large spreadsheets.

Discover the news of the stock market media

We constantly add richer multimedia content to the collection of Office Premium creative content, an organized library of stock images, icons, etc. that allows you to express yourself.

Save your images and graphics as SVG

We now take care of the recording of images, graphics and other graphs of your workbook in SVG (Scalable Vector Graphic) format).

Your recorded images can be resized without loss of image quality.

Try the sketch style outline

You can give an informal and hand -drawn overview to the forms of your presentations with the outline of sketch.

Try the curved, hand -raised or raised drawing options under Format > Line > sketch.

Develop your Development Office Skills.

Need help ?

You want more options ?

Explore the advantages of the subscription, browse the training courses, find out how to secure your device, etc.

Communities allow you to ask questions and answer them, give your comments and benefit from the expert opinion to in -depth knowledge.

Microsoft Excel for Mac

Microsoft Excel is a bureautic software which is part of the Microsoft Office and Microsoft 365 suite by subscription. Created and developed by Microsoft, this basic productivity application has become the Reference spreadsheet. The suite also includes Microsoft Word, Microsoft PowerPoint and Outlook software.

Updated regularly, the software is now available in its latest version Excel 2021 with a number of new products. He has noted smart fillers which allow you to easily analyze your data. You can consult the related data types to external sources. In terms of functionalities, the software has benefited from several additions of functions.

What is co-edition on Microsoft Excel ?

On Microsoft Excel, co -edition consists of Open a file and modify it at the same time as your colleagues. You become co-authors, and the application indicates exactly the contributions of each on the spreadsheet thanks to the colorful cells. This allows you to follow the changes of all the authors simultaneously without the need to send notes or emails in addition. The updates thus made save time and Fluidify collaboration.

What are the other news from Microsoft Excel 2021?

Microsoft Excel 2021 has a number of new functions.

• Function XLookUp Allows you to search line elements by line in a table or beach.
• Function LET attributes names to the result of calculations. You can store intermediate calculations, values ​​or define names inside your formulas.
• Function Xmatch allows you to search for a specified element or a value in a table or a range of cells and to return its relative position.

What innovations for the Microsoft Excel 2021 interface ?

Microsoft 365 brings a remained interface to his spreadsheet, to give him more modernity and remain in line with the design of Windows 11. Like the other applications of the suite, Microsft Excel has a palette of neutral colors to help users concentrate better. The windows are a little more rounded and the toolbars include new tabs and colored presence indicators which allow to quickly identify the co -authors on the same document. THE dark fashion has been preserved.

A powerful productivity application

Microsoft Excel remains a powerful spreadsheet that can meet all your needs. This impressive tool was enriched with even faster research and collaboration functions. Beginner users will have to hang on for learning new functions, but their effort will be rewarded.

Excel unlocks productivity and analysis with Microsoft 365 Copilot

Paragraph: Microsoft 365 COPILOT pupils the user experience in Excel By helping them to discover ideas, to identify trends and to create visualizations of professional data easily. Integrated into AI, Copilot assists users in their data analysis tasks, reducing the time spent on these tasks and allowing them to focus on the most important aspects of their work.

• Careful interface
• Full set of functions
• Management of real -time collaboration
• Best presentation of your data thanks to quick analysis