Excel Commands

Updated on March 19, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What Are Excel Commands?

Excel commands are used to find the data with ease. Whether in engineering, medicine, chemistry, or any field, an Excel spreadsheet is the common tool for data maintenance. Some of them use it to maintain their database and others use this tool as a weapon to turn fortune for the respective companies they are working on. So, you, too, can turn things around for yourself by learning some of the most useful Excel commands.

In this article, let us learn how to use the Excel commands.

Key Takeaways

  • Excel commands are helpful in enhancing productivity and profits.
  • In Excel, the fundamental Excel formulas and commands can also be leveraged at an advanced level. In addition, these Excel functions are necessary for operations, and one may use the Excel commands regularly. The Excel commands application is unlimited to basic tasks but can be extended to complex calculations.
  • Advanced formulas in Microsoft Excel fall under advanced-level courses. Moreover, every space is regarded as one character in Excel.

List Of Top 10 Commands In Excel

We have listed the top 10 commands used in Excel. Let us learn the Excel commands with the following examples in detail.

You can download this Commands in Excel Template here – Commands in Excel Template

#1 – VLOOKUP Function To Fetch Data

The data in multiple sheets are common in many offices, but fetching the data from one worksheet to another and from one workbook to another is a challenge for beginners in Excel.

If you have struggled to fetch the data, VLOOKUP will help you bring the data. For example, assume you have two tables below.

Excel Commands Example 1

In table 1, we have the subject list and their respective scores, and in table 2, we have some subject names, but we do not have scores for them. So, using these subject names in table 2, we need to fetch the data from table 1.

  1. First, let us open the VLOOKUP function in the E2 cell.

    Excel Commands Example 1-1

  2. Then, select the LOOKUP value as a D3 cell.

    Excel Commands Example 1-2

  3. Next, we must select the table array as A3 to B8 and press the F4 key to make them an absolute reference.

    Excel Commands Example 1-3

  4. Column Index Number is from the selected table array from which column you need to fetch the data. So, in this case, from the second column, we need to bring the data.

    Excel Commands Example 1-4

  5. For the last argument range, LOOKUP, we must select “FALSE” as the option, or else we can enter “0.”

    Excel Commands Example 1-5

  6. Close the bracket and press the “Enter” key to get the score of “Sub 4.” Also, copy the formula and paste it to the below cell.

    Excel Commands Example 1-6

    You have learned a formula to fetch values from different tables based on a LOOKUP value.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

#2 – IF Condition To Do Logical Test

The Excel IF condition can be your friend in many situations because of its ability to conduct logical tests. For example, assume you want to test the scores of students and give the result. Below is the data for your reference.

Excel Commands Example 2

In the above table, we have students’ scores from the examination. So we need to arrive at the result as either “PASS” or “FAIL” based on these scores. So to reach these results criteria, if the score is >=35, the result should be “PASS” or else “FAIL.”

  • We must first open the IF condition in the C2 cell.
Excel Commands Example 2-1
  • The first argument is logical to test. So, in this example, we need to do the logical test of whether the score is >=35, select the score cell B2, and apply the logical test as B2 >= 35.
Excel Commands Example 2-2
  • The next argument is value if true. If the applied logical test is “TRUE,” what is the value we need? If the logical test is “TRUE,” we need the result as “Pass.”
Excel Commands Example 2-3
  • So, the final part is value if false.If the applied logical test is “FALSE,” then we need the result as “Fail.”
Excel Commands Example 2-4
  • Now, close the bracket, and we also need to fill the formula to the remaining cells.
Excel Commands Example 2-5

So, students A and F scored less than 35. Therefore, the result has arrived as “FAIL.”

#3 – CONCATENATE Function To Combine Two Or More Values

If we want to combine two or more values from different cells, we can use the CONCATENATE function in Excel. For example, below is the “First Name” list and “Last Name.”

CONCATENATE Function Example 3
  • First, we need to open the CONCATENATE function in the C2 cell.
CONCATENATE Function Example 3-1
  • For the first argument, “Text 1, select the “First Name” cell, and for “Text 2,choose the “Last Name” cell.
CONCATENATE Function Example 3-2
  • Then, we need to apply the formula to all the cells to get the full name.
CONCATENATE Function Example 3-3
  • If you want space as the “First Name” and “Last Name” separator, we can use the space character in double-quotes after selecting the first name.
CONCATENATE Function Example 3-4

#4 – Count Only Numerical Values

If we want to count only numerical values from the range, you need to use the COUNT function in Excel. Take a look at the below data.

Count Function Example 4

From the above table, we need to count only numerical values. For this, we can use the COUNT function.

Count Function Example 4-1

The result of the COUNT function is 6. The total count of cells is 8, but we have got the count of numerical values as 6. In cells A4 and A6, we have text values, but in cell A8, we have date values. The Excel COUNT function treats the date also as a numerical value only.

Note: “Date” and “Time” values are numerical values if the formatting is correct. Otherwise, they will be treated as “text” values.

#5 – Count All Values

If we want to count all the values in the range, we need to use theCOUNTA function. We will apply the COUNTA function for the same data and see the count.

Count All Values Example 5

We got the count as 8 because the COUNTA function has counted all the cell values.

Count All Values Example 5-1

Note: Both the COUNT and COUNTA functions ignore blank cells.

#6 – Count Based On Condition

If we want to count based on condition, we can use the COUNTIF function. For example, look at the below data.

Excel Commands Example 6

From this “City List,” if we want to count how many times “Bangalore” city is mentioned, we must open the COUNTIF function.

Excel Commands Example 6-1

The first argument is “RANGE,” so we need to select the range of values from A2 to B9.

Excel Commands Example 6-2

The second argument is “Criteria,” i.e., what you want to count, i.e., “Bangalore.

Excel Commands Example 6-3

Bangalore has appeared three times in the range A2 to B9, so the COUNTIF function returns 3 as the count.

#7 – Count Number Of Characters In The Cell

If we want to count the number of characters in the cell, we need to use the LEN function in Excel. The LEN function returns the number of characters from the selected cell.

Excel Commands Example 7

“Excel” has 5 characters, so the result is 5.

Excel Commands Example 7-1

Note: Space is also considered as one character.

#8 – Convert Negative Value To Positive Value

If we have negative values and want to convert them to positive ones, the ABS function can do it for us.

Excel Commands Example 8

#9 – Convert All Characters To UPPERCASE Values

If we want to convert all the text values to UPPERCASE, we can use the UPPER formula in Excel.

Excel Commands Example 9

And if we want to convert all the text values to LOWERCASE values, then use the LOWER formula.

Excel Commands Example 9-1

#10 – Find Maximum And Minimum Values

If we want to find maximum and minimum values, we may use MAX and MIN functions in Excel.

Find Max & Min Example 10

Important Things To Note

  • These are some of the important formulas/commands in excel which are used regularly.
  • We can also use these functions at the advanced level.
  • There are more advanced formulas in Excel which come under advanced level courses.
  • Space is considered one character.

Frequently Asked Questions

1. What contains the most frequently used Excel commands?

The “Home” section in Excel provides a range of necessary commands, like copy, paste, sort, and filter, that are frequently utilized in day-to-day operations.

2. How many Excel commands are there?

In total, 450+ functions in Excel are available that can perform numerous tasks. Excel includes Excel functions such as VLOOKUP, SUMIF, COUNTIF, etc.

3. What is the difference between a command and a function in Excel?

The difference between a command and a function in Excel is that a function considers parameters, conducts a series of actions, and RETURNS a value. In comparison, a command takes parameters and considers a series of actions. Essentially, it does not RETURN values.

This article is a guide to Excel Commands. Here, we discuss the top 10 commands in Excel, examples, and a downloadable template. You may learn more about Excel from the following articles: –