MICROSOFT EXCEL 2021

Microsoft Excel 2021 as single license

Microsoft Excel is also in the current version 2021 the up to now unsurpassed spreadsheet software for the production of complex commercial and statistical calculations, supplemented by a multiplicity of functions, which make also logical as well as economic-mathematical computations and the use of Pivot tables possible. The analysis results can be presented informatively and clearly using a wide selection of chart types. Excel for this purpose, 2021 works together with PowerBI, the powerful business analysis service from Microsoft, which also enables the direct export of data to other environments.

With Microsoft Excel 2021 even more extensive or complex calculations are possible by means of extended formulas and new functions for the concatenation and selection of data. Important data can be marked in color to highlight them. New diagrams offer more options for graphical representation.

The available Microsoft Excel Online can be used with all common browsers, allowing the creation of tables and editing of data in real time as well as sharing with other users. Improved touch support makes it easier to use Excel on tablets or smartphones as well.

In addition, there are new tools such as freehand drawing and improved options for easy creation of accessible tables and workbooks.

Using Cloud services, sharing documents with other users for collaboration is quite straightforward.

By the way, in order to use Excel 2021 on your computer or other device, you need to install Windows 10. In the Wiresoft online store, you can obtain not only the current Word Excel version 2021, but also its predecessor and other Office programs at particularly low prices as a single-user version, without a software subscription. All important new features in Word 2021 can be found in the following overview.

Overview of the new Excel features in version 2021

Excel 2021 contains not only improvements of the previous version, but also many new features, some of which were previously only included in the subscription model Office 365 - these are now also available in the purchase version.

Specific Excel table functions

For linking tables to extended queries, Excel 2021 has been supplemented with some new practical functions:

• TEXT CHAIN: At first glance, this function does not hold anything significantly new compared to the previous CHAIN function, but unlike the latter, it is shorter and also easier to enter. In addition, the TEXT CHAIN function also supports range references, whereas previously only single cell references were possible. This means that TEXT CHAIN can also take into account a range of cells or entire columns.
• With the TEXT CHAIN function it is possible to combine text from multiple ranges, with each element separated by a separator specified by User. This allows, for example, words that are divided into cells to be combined into a sentence.
• IF: This function simplifies the input of complicated IF functions, because it tests the respective conditions in the previously specified order. To do this, the MAXWENNS function specifies the largest number in a defined range that satisfies at least one of the criteria; the same applies to the MINWENNS function for the smallest number.
• Deselect: In previous versions of Excel, it was not possible to exclude individual cells, rows or columns again in a previously selected range. In Excel 2021, users can now deselect superfluous rows that have been selected too much or incorrectly, for example.

Optimizations for PivotTable

PivotTable, the powerful Excel tool for analyzing and evaluating large amounts of data, including the clear presentation of results in documents, has been enhanced in the 2021 version with a number of additional practical functions:

• Personalized PivotTable default layouts: this feature now allows users to set up a pivot table individually according to their own ideas, including the display of partial results as well as overall results and the desired form of the report layout, and then save these defaults as a default layout so that it is immediately available the next time.
• Automatic detection of relationships: This feature builds on steps commonly used in analyses by automatically creating relationships between tables already used for a workbook's data model. Excel, for example, detects when at least two tables need to be linked for an analysis and alerts User to that fact. With a single click, the respective relationships are available.
• User-defined measures can be created and edited directly in the PivotTable field list in Excel 2021, as well as deleted.
• OLAP PivotTables can be created even faster: When using OLAP (Online Analytical Processing) servers for PivotTables, the query is now even faster. This applies not only to pivot tables connected to the Microsoft SQL Server Analysis Services, but also to other third-party OLAP-Server.
• Intelligent renaming: In Excel 2021, if the tables and columns of a data model are renamed in a workbook, Excel will also automatically update all corresponding associated tables and calculations, including all worksheets and DAX formulas, whenever a change is made.
• Power Query: By optimizing the already existing as well as new connectors - such as the Connector SAP Hana - data from different sources can be imported into Excel 2021 even faster and easier during ETL (Extract, Transform & Load) processes.

New diagrams and 3D models

For analyses and reports, a number of additional diagrams as well as three-dimensional models are now available in Excel 2021 to cover even more areas during evaluations.

• Map charts: This new feature in Excel 2021 makes it possible to display geographical values as well. Statistical distributions of data can thus be quickly and clearly displayed on a map by area - from global views to geographic regions to administrative districts or even by postal codes.
• Funnel charts: This diagram form can clearly depict the distribution and process data of a process in several phases, for example in sales processes or customer acquisitions.
• 3D models: New in Excel 2021 are three-dimensional models for illustrating reports - here, User can either choose from various readily available representations, which can also be rotated 360°, or create them themselves and insert them immediately into a document.
• Scalable vector graphics: SVG (Scalable Vector Graphics) files offer the advantage that they can be enlarged or reduced or even rotated as desired without loss of image quality. The integration of vector graphics in Excel 2021 is therefore particularly practical for presentations.

General functions

In addition to the specific Excel functions, there are also a number of other features in Excel 2021 that are also available in other Office programs.

New options for views and Desktop features

• New themes: The previous themes have now been extended to include the dark gray and white and black themes in Excel as well. Black offers the strongest contrast.
• Ribbon User interface: The previously familiar ribbon display has been combined with the tile look that is typical of the Windows 10 operating system. Frequently used elements and functions are placed prominently so that they are available more quickly for User. Of course, it is also possible to customize this view and, for example, show only the ribbon look.

Freehand tool for writing and drawing

A number of new freehand functions and effects are now also available in Excel 2021 . The new Freehand Drawing tool can be used not only by pen input and touch operation, but also with the computer mouse to mark areas or insert and edit formulas or self-drawn diagrams.

• Digital pens in various thicknesses and colors are available for this purpose: a pencil for drawing, a pen for writing, and the highlighter for highlighting text passages. Metallic pens and freehand effects such as rainbow, galaxy, lava, ocean, gold, silver and others expand the possibilities when designing.
• The Freehand FormulaInsert feature also allows users to insert complex mathematical formulas into a workbook.
• Lasso selection: Fingertips can be used to select a specific area of a freehand drawing to edit. This is also possible with the Surface Pen.

Optimized accessibility

Improved as well as new features are also available in Excel 2021 to optimize content so that it is easier to read and edit for users with disabilities. The supporting error correction suggests improvements here after activation, integrated features include the following:

• Use of internationally valid standards.
• By clicking on "Check" under "Check accessibility", the program makes suggestions that can be implemented immediately via one-click.
• The cue audio function actively supports the User via audio feedback with sound effects and audio cues, e.g. when certain features are (unintentionally) changed, or as a confirmation when an email is sent or content is inserted deleted.

Other features in Excel 2021

Other new features also make working with Excel even easier in Team:

• Changes in released workbooks can be displayed and, if necessary, undone more quickly; the people involved are also named.
• Translator:Translating individual words, passages or entire texts is now even easier in Excel: Whereas User previously had to call up a website via the browser in order to translate them, this is now possible directly in Excel thanks to the integrated translation function and automatic language recognition. More than 60 languages are available for this purpose in the Microsoft Translator.
• The integration of Data Loss Protection (DLP) makes it even easier to comply with data protection rules: content can be searched in real time, based on previously defined guidelines for particularly sensitive data types, such as account and credit card numbers, etc.

System requirements for Excel 2021

• Operating system: Windows 10, Windows 11, Windows Server 2021 /2022
• Processor: Min. 1.6 GHz
• Hard disk space: Min. 16 GB (32 bit) or 20 GB (64 bit)
• RAM: Min. 2 GB RAM (32 bit) or 4 GB RAM (64 bit) - recommended: 4 GB RAM
• Graphics card: Min 1,280 x 768 pixels, Min DirectX 9 with WDDM 2.0 - recommended: DirectX 10

Excel buy 2021 as Office single program cheap at Wiresoft

MS Excel is an indispensable, fixed component of the Microsoft Office suite. At Wiresoft you don't have to buy the Excel-version 2021 as part of the corresponding Office-suite, but you can also buy the software as a single program - in contrast to many other software vendors.

Your advantage: With the single User license, you do not have to enter into a long-term, expensive subscription commitment or accept a time limit on use. Therefore, it is worthwhile to buy Excel 2021 from Wiresoft as a stand-alone program, as you will then also not have to download any paid updates.

This stand-alone Excel single-user license is identical in terms of functionality to Excel, which is also included in the Office Suite 2021 . Thus also smaller companies or Freiberufler can profit from the advantages of Excel 2021 and save money - because the single place software is particularly favorable with Wiresoft in addition.

Not only Excel, but also all other Microsoft software licenses that you can buy in the Wiresoft software store are original Microsoft products. They often originate from a volume license or have been re-released by a company, which neither limits their usability nor enters a legal gray area. With the sale to Wiresoft, the previously installed software has been deleted and is therefore free again and usable by another User. Furthermore, as a reputable software dealer, Wiresoft only offers full versions that are unlimited and 100% usable.

If you have any questions about Excel 2021 or another Office program, you can also benefit from our competent advice by e-mail, phone and chat.