15 Excel formulas and shortcuts you need to know! – WAU
There is no doubt that Excel is a very useful tool for organizing business and personal life. However, most people already used to using the software still don’t know all the features it has. There are countless Excel formulas and shortcuts that give agility to the creation process […]
There is no doubt that Excel is a very useful tool for organizing business and personal life.
However, most people already used to using the software still don’t know all the features it has.
There are countless Excel formulas and shortcuts that give agility to the spreadsheet creation process.
Therefore, we have created a post listing key commands and some shortcuts that will help you save your precious time while using the program.
Are you curious? Then read on!
Learn all about Digital Marketing
This comprehensive guide will teach you everything about digital marketing and how to apply it.
5 Excel formulas to make your job easier
1. Automatically fill rows and columns
When it comes to time optimization, there is a very important command in Excel to record data that follow a pattern.
Instead of filling in each cell manually, the feature allows the insertion of all the desired information with a single step.
To do this, click and in the lower right corner of the cell that contains the data you want to click and drag the checkbox, until the desired number of cells is completed.
Then, release the mouse. The program will replicate the content, completing the adjacent cells as the first selected.
2. Quickly select a desired section of rows or columns
Are you short on time and need to select part of an Excel table or even the entire document?
For those who still don’t know, this work can be done very simply and quickly, leaving more free time for the professional to edit other more important functions.
If you want to select the entire spreadsheet, know that it can be done with just one click:
There is a button in the upper left corner, between the numbering of the 1st line (number 1) and the title of the first column (letter A). With just one click, you perform the mentioned function.
However, given the need to mark only part of the rows or columns, the following shortcuts should be used:
- Ctrl + Shift + down arrow or Up arrow to select lines; and
- Ctrl + Shift + right arrow or left arrow to select columns.
On Apple computers, there is a small difference:
- Command + Shift + down arrow or Up arrow, in the selection of lines; and
- Command + Shift + left arrow or right arrow, in column selection.
3. Transform simple numbers into currencies
The Excel program is widely used for the management of financial resources (budgets, sales balance, payroll, etc.).
Formatting the numbers in your table to represent money, with their respective dollar signs, decimals and commas is also another agility that is much sought after by those who do this type of work.
To perform this process, just select the desired cells and then press the Ctrl + Shift + R $ buttons so that the cell numbers are represented as real.
4. Add comments to cells
It is often interesting to add a comment within a given cell, either to highlight relevant information or for any other type of clarification.
The 1st step is to click the right mouse button, above the desired cell, and then check the option “Insert Comment”.
The program will open a dialog box in which you must enter your text.
Click outside that box to save the added content.
5. Use the IF function
The SE function is an excellent tool for controlling and mastering the requested value conditions.
It allows you to know, for example, the quantity of products in the company’s stock, and, consequently, the items that need replacement.
The formula to be used is as follows:
= if (cellX <= 0; “What you need to know 1”; “what you need to know 2”)
How does this work in practice?
As an example, we have:
= if (B1 <= 0; “To be sent”; “In stock”)
The language = if (B1 <= 0; “to be sent”; “in stock”) tells Excel that, if the content of cell B1 is less than or equal to 0, it should display the message “To be sent” in cell containing the formula.
In case the content is greater than 0, the message “In stock” will appear.
10 Excel shortcuts to save time in your day to day
1. Control + (and Control +)
They are the functions of hiding and showing rows and columns again, respectively.
In very large tables, it usually takes more time to read the information, and it is not always possible to view all the data at once.
In this way, the aforementioned commands serve to facilitate your experience while using the software, allowing you to approximate the necessary information by hiding rows and columns.
Here the command to hide the lines is Ctrl + (and, for columns, Ctrl +).
When it is necessary for the hidden data to reappear, just press Ctrl + Shift + (.
2. Ctrl + + (plus sign)
To insert rows, columns or cells between data.
3. Ctrl + – (minus sign)
To delete entire cells, rows or columns.
4. Ctrl + Shift + #
Insert a date in the file, with the day, month and year.
5. Ctrl + Shift + _
Removes outline from selected cells.
6. Ctrl + Shift + &
Adds the outline to the selected cells.
7. Ctrl + Shift +%
Apply percentage format, without decimal places, to highlighted cells.
8. Ctrl + Alt + V
Makes the values of the copied cells appear without formatting.
9. Ctrl + Page up
Switch to the previous spreadsheet in your workbook.
10. Ctrl + Page down
Switch to the spreadsheet the next in your workbook.
The insertion of mechanisms to automate certain jobs always brings benefits. Among them, is the saving of time and availability of professionals to perform more important obligations.
Excel formulas and shortcuts are an excellent way to increase productivity when performing tasks in your business. So it is recommended that they be adopted as soon as possible!
Did you like this post? Now that you know how to do your work in Excel more efficiently, download our ebook Spreadsheet: Monthly Metrics for Marketing and Sales.