Microsoft Excel

365 16.0.12827.20336

Microsoft Excel is the famous spreadsheet tool belonging to Office where you can comfortably work with tables, graphs, macros, and more on your PC

8/10 (2809 Votes)

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.

Main features

  • 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.
Requirements and additional information:
  • Minimum operating system requirements: Windows 7.
Manuel Sánchez
Manuel Sánchez
Microsoft
3 months ago
07/23/2020
5.5 MB

Microsoft Excel Tips & Tricks

Excel Portable: can it be downloaded?

Despite what many users think, there’s no such thing as Excel Portable, in other words, there’s no official portable version of Microsoft’s spreadsheet software that’s included within the Office suite. Unlike what many people think, Microsoft has never released a reduced version of this program although you might have seen announcements about the download of this product. Don’t be fooled, on the majority of occasions they are simply fake apps, frauds or pirated versions. In this last case that’s because there are users with enough skills to trim down EXEs to make them run as portable software thanks to programs of the likes of ThinApp or VMWare or any other app specialized in the creation of EXE files. But this is obviously a pirate procedure as it involves infringing the terms and conditions of use imposed by Microsoft.

View

What is Excel and what's it for?

Excel is a program that belongs to the Microsoft Office suite, a software to work with spreadsheets that is mainly used for math and financial tasks. It allows the user to create tables that include math calculations solved by means of math operators or automatically by means of formulas that are called functions and that can be configured manually. Furthermore, it also allows us to view the data graphically by means of different types of representations such as charts, for instance. The purpose of the latter can be different depending on our needs and the possibilities offered by this software are very broad. We can use it to carry out simple additions or even integrals, as well as the creation of graphics, the generation of reports or the organization of non-numeric information.

View

View all 9 Tips & Tricks

We'd love to hear from you. Do you want to give us your opinion?

Logged off

Logged off