O Excel It is one of the most widely used software programs in the world. It is estimated that 90% of companies use the application for general controls: payments, profit projections, production control, etc. Even in Brazil and in Small and Medium Enterprises (SMEs), the Excel It's the preferred choice. And for good reason: it automates all your accounting, among many other functions. It's almost unrealistic to expect to work in administration or deal with numbers, in general, without it. Excel.

There are two ways to learn how to use it. Excel. The first is self-teaching. This works best for those seeking general knowledge of the software or who will only use it for simple functions. For those seeking more in-depth knowledge, It's important to look for Excel courses.. Specific lessons can also help you master a particular area within the application (such as, for example, a full course business-oriented or with specific external applications, like VBA). 

Below, we have separated two lists of formulas from Excel to help you: the most searched on Google Brazil and the most commonly used in Excel. Save this list to keep it handy and save time when working on your spreadsheets: 

Top 15 Excel formulas most searched on Google Brazil

Check out the formulas for Excel most searched on Google Brazil, especially for beginners or people looking for quick solutions to common problems:

1. SUM(): sums a range of cells.
2. AVERAGE(): calculates the average of a range of cells.
3. VLOOKUP(): searches for a value in the first column of a table and returns a value from a column to the right.
4. IF(): performs a logical comparison and returns one value if true, and another if false.
5. INDEX(): returns the value of a cell in a table based on row and column numbers.
6. MATCH(): finds the position of a value in a range.
7. SUMIF(): sums the cells in a range that meet a specific criterion.
8. SUMIFS(): sums the cells in a range that meet multiple criteria.
9. CONCATENATE() or &: joins (concatenates) two or more texts or values.
10. LEFT(): returns a specified number of characters from the beginning of a text string.
11. RIGHT(): returns a specified number of characters from the end of a text string.
12. TEXT(): formats a number or date in a specified format.
13. LARGE(): returns the largest value in a range or set of data.
14. SMALL(): returns the smallest value from a range or set of data.
15. PRODUCT(): multiplies all numbers in a range and returns the result.

15 most used formulas in Excel

These formulas are the most common for those familiar with Excel and who deal with calculations and data manipulation on a regular basis:

1. SUM(): to quickly sum ranges of data.
2. AVERAGE(): to calculate the average of a data set.
3. SE(): used to perform logical tests and return different results depending on the condition.
4. VLOOKUP(): searches for a value in one column of a table and returns a matching value from another column.
5. INDEX(): used with **MATCH()** to search for data in tables, allowing for more flexible searching than VLOOKUP().
6. SUMIF(): sums values in a range that meet a specific criterion.
7. SUMIFS(): sums values in a range based on multiple criteria.
8. CONCATENATE() or &: joins two or more texts or values into a cell.
9. LEFT(): to extract the first characters of a text.
10. RIGHT(): to extract the last characters from a text.
11. TRIM(): removes extra spaces from text (very useful for cleaning up imported data).
12. REPLACE(): replaces text within a cell with other text.
13. TEXT(): to format numbers and dates according to a custom pattern.
14. LARGE(): to find the largest value in a range.
15. SMALL(): to find the smallest value in a range.

ChatGPT helped us.

Ah! The research for this material was done with the help of ChatGPT. Generative artificial intelligence can be a great advantage when researching rankings, lists, and placements. To understand what the questions might be and the best way to address them all in one place, various questions were asked to determine the most common doubts people have regarding Excel shortcuts.

O ChatGPT It can be a great ally in various professions, including developers, administrators, and marketers. The biggest secret is understanding the nuances of how it works and knowing exactly what to ask. Here at ESEG College, part of the Etapa group., we have a This course is designed exclusively to teach you everything about ChatGPT.. The classes are 100% online and the course costs R$250; the amount can be paid in up to 12 installments. Learn more.