MICROSOFT EXCEL 2019

Microsoft Excel 2019 as single license

Microsoft Excel is also in the current version 2019 the so far unsurpassed spreadsheet software for the creation of complex commercial and statistical calculations, supplemented by a variety of functions that also allow logical as well as economic mathematical calculations and the use of pivot tables. The analysis results can be presented in an informative and clear manner through a wide selection of chart types. Excel for this purpose, 2019 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 2019, even more extensive or even more complex calculations are possible by means of extended formulas and new functions in 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, to use Excel 2019 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 2019, 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 2019 can be found in the following overview.

Overview of the new Excel features in version 2019

Excel 2019 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 advanced queries, Excel 2019 has been enhanced with some new handy features:

• 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 2019, 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 2019 version with several more practical functions:

• Personalized PivotTable default layouts: this feature now allows you to set up a pivot table individually according to your 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. For example, Excel detects when at least two tables need to be linked for an analysis and alerts User. 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 2019, 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 2019, if the tables and columns of a data model are renamed in a workbook, Excel also automatically updates 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 2019 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 2019 to cover even more areas during evaluations.

• Map charts: This new feature in Excel 2019 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 2019 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 2019 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 2019 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 Dark Gray and White and Black themes in Excel. 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, only show the ribbon look.

Freehand tool for writing and drawing

A number of new freehand functions and effects are now also available in Excel 2019. 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 2019 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 also as a confirmation when an email is sent, or content has been inserted deleted.

Other features in Excel 2019

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

• Changes in shared workbooks can be displayed and also undone more quickly if required; 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 policies for particularly sensitive data types, such as account and credit card numbers, etc.

System requirements for Excel 2019

• Operating system: Windows 10, Windows 11, Windows Server 2019 /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 2019 as Office single program cheap at Wiresoft

MS Excel is an indispensable, integral part of the Microsoft Office suite. At Wiresoft you do not have to purchase the Excel-Version 2019 as part of the corresponding Office-Suite, but you can also buy the software as a single program - in contrast to many other software providers.

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 worth buying Excel 2019 from Wiresoft as a standalone program, because then you also do not have to download any paid updates.

This standalone Excel single-user license is identical in terms of functionality to Excel, which is also included in Office Suite 2019. This means that even smaller companies or freelancers can benefit from the advantages of Excel 2019 and save money in the process - because the single-user software is particularly inexpensive at 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 2019 or any other Office program, you can also benefit from our competent advice via email, phone and chat.