Out of all Microsoft Office suite software, Word and Excel are probably the two most popular applications among users. If the first one is the most famous editor and word processor in existence, the second one is undoubtedly the most used spreadsheet program in the world, both in domestic and professional environments.
With Microsoft Excel installed on your PC, you can work with different sheets and tables and all kinds of numerical and alphanumeric data, as well as create graphs and insert formulas, which is very useful for any kind of financial, statistical or engineering task. Its integration with Visual Basic for Applications also makes it very useful for anyone who wants to program small forms or applications with simple graphical user interfaces. And of course, its sorting and filtering functions make it perfect for searching and comparing different data.
View data strings according to your needs.
With all this, it is normal that over the years it has become a standard, replacing other applications of the same style, such as Lotus 1-2-3 or VisiCalc. Therefore, any computer equipped with Windows must have a version of Excel installed. Or if not the Microsoft solution, at least some alternative office suites like LibreOffice Calc or OpenOffice.
- Native Microsoft Office spreadsheet editor.
- Create custom spreadsheets or import data from databases or other documents.
- Insert tables with numeric and alphanumeric values and apply formulas and mathematical equations to process that data.
- Filter the values in the tables according to different criteria and sort them according to your needs.
- Generates charts of all types to represent cell values: column, bar, scatter, area, line and pie charts, etc.
- Program macros to automate tasks you perform repeatedly.
- Work in collaboration with multiple users by editing the same file at the same time.
- Access all your spreadsheets from any device thanks to its synchronization with OneDrive.
- Compatible with many formats including .xls, .xml, and .csv.
What does this new Excel 2019 edition have that previous Excel editions lack?
This Excel 2019 edition replaces the edition that was included in the Office 2016 package. Regarding this version, we can list the following new features:
- Up to 6 new native functions: Concatenate, Si.Set, Max.Si.Set, Min.Si.Set, Switch and UniStrings.
- Map and funnel graphs are added. The first option lets you compare values and display categories in different regions, while the second feature displays values through various process phases.
- Some visual elements are improved such as three-dimensional models that can rotate 360 degrees or the possibility to add visual elements using Scalable Vector Graphics (SVG).
- The use of the digital pen is now standard and most software functions are now compatible.
- Improved accessibility features.
- File sharing is much easier.