Excel shortcut keys Formulas Cells | Excel short keys: Microsoft Excel is extensively used across the globe to store and analyze data. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data.
The shortcut keys in Excel help you work on your data in a jiffy. In this article, we’ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively.
most Popular searches:
excel shortcut keys
m s excel shortcut keys
m.s excel shortcut keys
excel shortcut keys pdf
what are the shortcut keys to insert a new row in an excel spreadsheet
What is Microsoft Excel?
Although many of you are already aware of Excel, let’s have a small introduction anyways. Microsoft Excel is an application developed by Microsoft that is used to record, analyze, and visualize data. Excel, a spreadsheet application, was developed by Microsoft in 1985.
Data in Excel is in the form of rows and columns. Excel is commonly used to record and analyze data, perform mathematical operations, and visualize structured data in charts and graphs. Finally, another important application of Excel is that it helps in automating tasks through excel macros.
To perform the tasks mentioned above quickly, has a set of shortcuts. Various operations can be achieved with a few simple keyboard strokes. Let’s dive deep into the Excel shortcuts that can help us work better on an spreadsheet.
Need for Excel Shortcuts
Excel supports a plethora of keyboard shortcuts that help you work efficiently and increase productivity. Instead of accessing the toolbar with a mouse, two or three keystrokes are used to perform significant functions. Isn’t that easier and time-saving? Using shortcuts drastically increases the speed, and thus reduces work-time.
Now the question is, if you have to memorize these shortcuts, the answer is no. However, it would be an advantage if you can remember a few of them. With regular practice, you will be able to remember most of the common Excel shortcuts.
Let’s now look at the top 50 shortcuts, which you should know when working on Microsoft. In this article, we have categorized 50 Excel shortcuts based on their operations. First, we will look at the workbook shortcut keys.
Workbook Shortcut Keys
In this section, we will understand the basics of operating a workbook. We will learn how to create a new workbook, open an existing workbook, and save a spreadsheet so that you don’t lose any data or calculations that you have done. We will then go through how you can toggle between several different sheets in a workbook.
Cell Formatting Shortcut Keys
A cell l holds all the data that you are working on. Several different shortcuts can be applied to a cell, such as editing a cell, aligning cell contents, adding a border to a cell, adding an outline to all the selected cells, and many more. Here is a sneak peek into these Excel shortcuts.
In addition to the above-mentioned cell formatting shortcuts, let’s look at a few more additional and advanced cell formatting Excel shortcuts that might come handy.
We will learn how to add a comment to a cell. Comments are helpful when giving extra information about cell content. We will also learn how to find value and replace it with another value in the spreadsheet. After this, we will look into how to insert the current time, current date, activate a filter, and add a hyperlink to a cell. Finally, we will see how to apply a format to the data in a cell.
Excel Formulas You Should Know
Microsoft is the go-to tool for working with data. There are probably a handful of people who haven’t used , given its immense popularity. Excel is a widely used software application in industries today, built to generate reports and business insights. supports several in-built applications that make it easier to use.
One such feature that allows to stand out formulas. In this article, we’ll be discussing the various Microsoft functions and formulas. These formulas and functions enable you to perform calculations and data analysis faster. Here, we will look into the top 25 Excel formulas that one must know while working . The topics that we will be covering in this article are as follows:
What is Excel Formula?
In Microsoft , a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division. In addition to these, you can find out averages and calculate percentages in excel for a range of cells, manipulate date and time values, and do a lot more.
There is another term that is very familiar to formulas, and that is “function”. The two words, “formulas” and “functions” are sometimes interchangeable. They are closely related, but yet different. A formula begins with an equal sign. Meanwhile, functions are used to perform complex calculations that cannot be done manually. Functions in excel have names that reflect their intended use.
Excel Formulas and Functions
There are plenty of Excel formulas and functions depending on what kind of operation you want to perform on the dataset. We will look into the formulas and functions on mathematical operations, character-text functions, data and time, sumif-countif, and few lookup functions.
Let’s now look at the top 25 Excel formulas you must know. In this article, we have categorized 25 Excel formulas based on their operations. Let’s start with the first Excel formula on our list.
SUM
The SUM () function, as the name suggests, gives the total of the selected range of cell values. It performs the mathematical operation which is addition. Here’s an example of it below:
As you can see above, to find the total amount of sales for every unit, we had to simply type in the function “=SUM (C2:C4)”. This automatically adds up 300, 385, and 480. The result is stored in C5.
AVERAGE
The AVERAGE () function focuses on calculating the average of the selected range of cell values. As seen from the below example, to find the avg of the total sales, you have to simply type in “AVERAGE (C2, C3, C4)”.
It automatically calculates the average, and you can store the result in your desired location.
COUNT
The function COUNT () counts the total number of cells in a range that contains a number. It does not include the cell, which is blank, and the ones that hold data in any other format apart from numeric.
As seen above, here, we are counting from C1 to C4, ideally four cells. But since the COUNT function takes only the cells with numerical values into consideration, the answer is 3 as the cell containing “Total Sales” is omitted here.
If you are required to count all the cells with numerical values, text, and any other data format, you must use the function ‘COUNTA ()’. However, COUNTA () does not count any blank cells.
To count the number of blank cells present in a range of cells, COUNTBLANK () is used.
SUBTOTAL
Moving ahead, let’s now understand how the subtotal function works. The SUBTOTAL () function returns the subtotal in a database. Depending on what you want, you can select either average, count, sum, min, max, min, or others. Let’s have a look at two such examples.
In the example above, we have performed the subtotal calculation on cells ranging from A2 to A4. As you can see, the function used is “=SUBTOTAL (1, A2: A4), in the subtotal list “1” refers to average. Hence, the above function will give the average of A2: A4 and the answer to it is 11, which is stored in C5.
Similarly, “=SUBTOTAL (4, A2: A4)” selects the cell with the maximum value from A2 to A4, which is 12. Incorporating “4” in the function provides the maximum result.
people are also looking for:
excel formulas
shortcuts
ctrl
excel download
MODULUS
The MOD () function works on returning the remainder when a particular number is divided by a divisor. Let’s now have a look at the examples below for better understanding.
In the first example, we have divided 10 by 3. The remainder is calculated using the function “=MOD (A2, 3)”. The result is stored in B2. We can also directly type “=MOD (10, 3)” as it will give the same answer.
POWER
The function “Power ()” returns the result of a number raised to a certain power. Let’s have a look at the examples shown below:
As you can see above, to find the power of 10 stored in A2 raised to 3, we have to type “= POWER (A2, 3)”. This is how power function works in Excel.